your co workers are under informed, I think.

when you move the primary key/clustered index of a table to a new file group, you move it's data as well.

example:

CREATE...

there's a pretty good thread on the issue here, but it may or may not be the same thing you are experiencing:

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/ef029812-45d0-4544-a00f-bd9e66a6d4bf

it seems the default behavior of SQL 2005 changed,...

well, just as the error message says, the first thing I'd do is check to see if the server allows remote connections:

This issue vs your credentials in your signature don't...

the above trigger example assumes thre would only be ONE row ever updated at any one time...it best practice is to assume more than one row comes from the INSERTED...

yeah i agree; either fix the data, or the one parameter raising the issue. I would not try to change hundreds of other parameters...to many things for the QA team...

@Param1 NUMERIC(2, 0)---this says the definition is 2 digits, none after the decimal....but you are assigning a 5 digit number to it: @Param1 = 92229.0

since the biggist...

he can use a case statement to group them horizontally;

well...three case statements, right?

case

when c1 <= c2 and c1 c1 and c2 <= c3 then c2....

RESTORE DATABASE myDatabase WITH RECOVERY would work only if there is already a backup in place and you want to restore the default backup. if this is on a diffrerent...

you'll want to read up on RESTORE from Books online; if you are restoring from a file, the command would look something like this:

RESTORE DATABASE [YOURDB]

FROM DISK =...

data like this is tough; i always do this via TSQL and not through SSIS, just because I'm more familiar with TSQL.

Here's how i would do it:

I'd grab the entire...

you can create a table, and then insert into it directly, but if you alter a table, a GO statement is expected.

simply create your table with the constraint in a...

One of the harder concepts to grasp is how SQL server works with Set Based operations, compared to programmatically based processing, which thinks about processing data "Row By Agonizing Row"...

since from the perspective of the server you are looking at, the mdf files are located on a \\UNC drive, I'd speculate that an instance of SQL server on...

if you have the mdf and ldf files, in SSMS in the Object Explorer window on the left, you would simply right click on the Database Folder and select Attach...

then...

easy enough middletree;

add the procedure and run it on your test server.

then immediately run this statement:

select * from sp_DMLTrace

you'll get results for at least 5 rows, which include the commands...