NeoEdge Networks www.neoedge.com We're looking for a Senior Database Administrator, for our office in Toronto, Ontario Canada. Position...

jsaccomanno@gmail.com

03-21-2007 10:42 AM
jsaccomanno@gmail.com

NeoEdge Networks www.neoedge.com We're looking for a Senior Database Administrator, for our office in Toronto, Ontario Canada. Position...

jsaccomanno@gmail.com

03-21-2007 10:34 AM
jsaccomanno@gmail.com

Hi, I am planning to automate a nighty restore of a DB on another server can someone point me in the right direction with the SQL script to modify...

blueboy

03-21-2007 08:39 AM
blueboy

Hi, I have a need to create a table detailing the ID of all contacts and the last time they were contacted. This information is stored in 2...

Mintyman

03-21-2007 07:20 AM
Mintyman

Hello, I have a problem with XML schema update for one XML column (problem exists in both SP1 and SP2 for SQL Server 2005). 1. I have a table that...

eduardasm

03-21-2007 06:56 AM
eduardasm

The first query returns me the results from multiple databases, the second does the same thing except it puts the result into a #temp table? Could...

santaferubber@gmail.com

03-21-2007 03:38 AM
othellomy@yahoo.com

I am using SQL Server Express and ASP. I have a table that contains news articles, headlines, start and end dates. I am trying to create a...

t8ntboy

03-20-2007 05:02 PM
AlterEgo

Hi, I posted this in an access adp newsgroup, but there don't seem to be any messages there since 9-06. I am accessing an online SQL Server (2k)...

JA

03-20-2007 12:38 AM
Jonathan Roberts

I was able to view table content easily before, but after I reinstalled everything, I cannot find the option to view table content in MS SQL Server...

antonyliu2002@yahoo.com

03-19-2007 11:09 PM
antonyliu2002@yahoo.com

Sorry if this seems too easy to be interesting - I have yet to find an elegant solution, as I am completely new at this so don't really know what to...

jrpfinch

03-19-2007 02:49 PM
David Portas

I have a table with a date_created and date_expired and I want to look at the 15th of each month and every month since the system started and count...

Giorgio

03-19-2007 02:41 PM
Hugo Kornelis

Can someone tell me options to do this statment because this one does not work! SELECT Name FROM tbl_J WHERE J_ID IN (SELECT J1, J2, J3, J4, J5,...

Giorgio

03-19-2007 09:02 AM
Roy Harvey

I installed an application which adds an extended stored procedure. I've since uninstalled the application and deleted the xp it added, however...

Jwilliams

03-19-2007 07:58 AM
Jwilliams

I have a stored procedure that calls another stored procedure with the first stored procedure opening a transaction: BEGIN SET XACT_ABORT ON BEGIN...

cricketweb@gmail.com

03-19-2007 12:12 AM
M A Srinivas

What is the easiest way to solve "," problem Fields A, B and C are float-values INSERT INTO Table (A, B, C) VALUES (1,2,3) This is ok, but. How...

Kaitsu

03-18-2007 11:13 AM
Dan Guzman

I have a table that has a DateTime column which uses a DataTime datatype. How do I retrieve a range of records based on the month and year using ms...

Eugene Anthony

03-18-2007 03:50 AM
Jack Vamvas

Hi everybody, I've five instances of SQL Server 2000 with the SAME database with a DIFFERENT owner in each server. I, as the administrator, have a...

MADS

03-16-2007 09:49 AM
MADS

Hi, I believe my SQL server was configured as Case sensitivity. I have a number of stored procedures which were moved from a non-Case sensitivity...

sweetpotatop@yahoo.com

03-16-2007 09:45 AM
--CELKO--

Hello, I have set up a database for movies. In one table (Movies) I have movie names, and production years, and also genres. In another...

Dot Net Daddy

03-16-2007 09:40 AM
--CELKO--

I'm trying to write some T-SQL code for adding some fills and thrills to backups but ran into a snag. Is there a way to query what backup model a...

Utahduck@hotmail.com

03-16-2007 09:30 AM
Utahduck@hotmail.com

Is there any documentation on the new features that do/don't work when you set the backward compatibility for Sql Server 2005 to 80? I tried the...

eavery@cdc.gov

03-16-2007 09:15 AM
eavery@cdc.gov

I'm pretty new to SQL and querying, and I'm not sure if this is the correct group to post this to, but hopefully someone can point me in the right...

sephent@gmail.com

03-15-2007 05:57 PM
Utahduck@hotmail.com

I have a table that has a DateTime column which uses a DataTime datatype. How do I retrieve the minimum and maximum year using ms sql? Eugene...

Eugene Anthony

03-15-2007 05:41 PM
--CELKO--

Imagine a restaurant which we want to store information about. Two types of people are related to it. 1) People who simply call and the food is...

hadi

03-15-2007 02:44 PM
ZeldorBlat

I have been unsuccessful locating information about the maximum number of CPU's SQL Server 2005 Enterprise supports. However I did find info in a...

rcamarda

03-15-2007 08:56 AM
Plamen Ratchev

I have a SQL table with the following fields: accounts, orderid's and datetime Account OrderID Datetime 1 ...

Spook

03-15-2007 03:29 AM
avode

Imagine opening SQL Server Management Studio (SSMS), drilling into a database, and seeing all objects with little lock symbols in front of them. That...

Tom van Stiphout

03-14-2007 08:32 PM
Tom van Stiphout

Does anyone know of any documentation on the performance of partition merge/split? Does the merge or split of a partition cause any locking on the...

eavery@cdc.gov

03-14-2007 02:13 PM
eavery@cdc.gov

Hello, I am trying to write a script using SQL Server 2000 to list all of the roles that have any permissions on a specified object (view,...

Bruce

03-14-2007 08:29 AM
Bruce

Someone at my job who was a IT Professional before me wrote a SQL statement. That statement or file is working with a program that we use called...

The Man

03-14-2007 07:10 AM
othellomy@yahoo.com

I need to run a SELECT DISTINCT query across multiple fields, but I need to add another field that is NON-DISTINCT to my record set. Here is my...

Techhead

03-14-2007 03:40 AM
M A Srinivas

I have a table with id an identity column. Can I forbid the identity column of taking the same values of deleted ones? How can I resolve this...

Marie-Christine Bechara

03-14-2007 12:08 AM
Russ Rose

Hi, I'm trying to create views on all my existing tables and for that I'd like to create a script or so. I don't want to specify the '*' for the...

clir

03-13-2007 09:43 PM
Tom van Stiphout

We have a SQL 2005 server running the following backup job: EXECUTE...

Bryan

03-13-2007 07:48 PM
Greg D. Moore \(Strider\)

We have a SQL 2005 server running the following backup job: <font face="Courier New" size="2"><br><font color="blue">/* Created by <a...

Bryan

03-13-2007 05:50 PM
Greg D. Moore \(Strider\)

I'm sure this has been brought up many times, but I will ask anyway. Let's say I have 2 tables related: Owner: --------- o_id o_name Dog:

Steve London

03-13-2007 05:02 PM
KoliPoki

I've got an issue that is perhaps a bit different than any other related posting on this topic. I have successfully installed and configured SSRS...

scottdistefano@gmail.com

03-13-2007 10:39 AM
scottdistefano@gmail.com

I was wondering if there is any online user reference/manual for transact sql (SQL Server) in PDF format? Download links? I know about online help...

othellomy@yahoo.com

03-13-2007 08:13 AM
Jack Vamvas

Hi I'm not really a MS SQL Admin. I have only one system in our house holding an MS SQL DB. I need to made a backup of the DB. Can someone tell me...

Dominik Hirt

03-13-2007 07:46 AM
Greg D. Moore \(Strider\)

I was checking out an indexes property via SQL 2005 Management Studio and it looks like I can move the index to other filegroups via the drop down. I...

rcamarda

03-13-2007 01:32 AM
Paul S. Randal [MS]

As some readers of this newgroup can recall, I use Cognos' program called Data Manager to build my data warehouse. I has the ability to create...

rcamarda

03-12-2007 09:28 PM
rcamarda

I have SQL Server 2005 x64. I found in the studio I can generate all sorts of scripts, including the creation of indexes. I works, however the script...

rcamarda

03-12-2007 07:55 PM
jezemine

how to select 200 first records from table? -- Thank you, De Cool, EPE

Dmitry Kulinich

03-12-2007 07:40 PM
Greg D. Moore \(Strider\)

With help of others on this group, I've been learning and researching about indexes; an area I neglected. I see I can specify which filegroup I wish...

rcamarda

03-12-2007 03:03 PM
rcamarda

hi, i have a column of type ntext in the db, we're using that to allow users to store essays they can enter. problem is when i'm running a select on...

phil2phil

03-12-2007 12:51 PM
Greg D. Moore \(Strider\)

Does anyone know of any documentation on the performance of partition merge/split? Does the merge or split of a partition cause any locking on the...

eavery@cdc.gov

03-12-2007 07:03 AM
eavery@cdc.gov

How can I get the value of the last Item in a coums? SELECT COLUMN FROM DATABASE ORDER BY COLUMN DESC? something with Fields(0).value? Thank you in...

andreas.hei@googlemail.com

03-12-2007 06:59 AM
Plamen Ratchev

Hello, I am wondering if anyone could help me in choosing a right training course. My company has agreed to send me on a training course for sql...

AK

03-12-2007 05:37 AM
AK

Dear Group I've installed MSSQL 2005 STD on Vista and now can't attach my databases. I've installed SQL SP2 and the SQL Vista Beta Update. The error...

theintrepidfox@hotmail.com

03-12-2007 04:29 AM
theintrepidfox@hotmail.com

I thought I would delve into index fragmentation and I found some great sql from many posters (thanks Erland!). My question is how bad is bad? I know...

rcamarda

03-12-2007 03:44 AM
John Bell