i think the 2005 %%LockRes%% row identifier and the 2008's equivalent %%physloc%% only tell you how the data is stored, which is based in the clustered index of the table...

i have this saved in my snippets as a DR framework from a post that appeared on SSC fairly recently...I thought simon provided a pretty good list of things to...

also notehow a DEFAULT constraint is used! default does not mean "replace null with the default value", it means "if not included, use THIS"

if you include a value in your...

i thought re-enabling the constraint prevents future...

if you disable FK's, then insert, then renable, a FK is is_not_trusted = 1 if there is data in the child table that violates the FK constraint right (like inserting...

another option is that SSIS can migrate data both to-and-from SQL to another data source....all you need is an ODBC connection.

you could set up a package with the import/export wizard...

run the msi and click next five or six times....

seriously, an "application" server is just another server that is being used for a specific purpose.

you would have to decide if...

I believe that you can connect as sa(if you know the password), and then add the the right groupsto the sysadmin group.

otherwise as a local administrator, you need to connect...

there may be a more streamlined way to do it, but this works:

--results:

BDayYearBegin dob ...

mostly your problem is your design is not using an identity...but it is also procedurally based, and not thinking in terms of SET based solutions.

what if i were to insert...

why are you using a GETNEWKEY functionality to generate a number for your PK column instead of allowing an identity column to generate the value for you? the identity property...

it's fairly easy; you just need to add a linked server, and then select using 4 part naming conventions:

EXEC master.dbo.sp_addlinkedserver @server = N'ANOTHERSERVER\INSTANCENAME', @srvproduct=N'SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'ANOTHERSERVER\INSTANCENAME', @locallogin...

crap someone else asked this exact same question a while ago and i answered it;

is this a homework question?

http://www.sqlservercentral.com/Forums/Topic968341-131-1.aspx

SQL Server thinks of arrays as tables, so it doesn't have an array data type....

to decode a string from a delimited list to a table, you can use one of...

it depends on the job. way to many reasons to fail.

a job can be poorly written, try to access databases or database objects that don't exist(anymore? maybe someone dropped a...