ok i know i have SQL Express with Advanced Options instealled...i certainly have the options i was describing: some i've turned off, some are turned on...you can decide which to...

thanks!

i think the script is pretty kewl, but there's so many ways to skin a cat...you can do the same in SMO and stuff, so not too many people want...

pretty sure the SSMS can do this for you; it's just some check marks int he scripting options to include triggers, constriants, etc.(TOOLS>>Options>>Scripting>> section for TABLE...check/uncheck various scripting options)

i contributed...

you cannot reuse the numbers if there are gaps...at least not easily.

assuming you want a 10 digit number, ie 1 with 9 preceeeding zeros:

'0000000001'

Alter Table MyTable Add MyCalculatedColumn As RIGHT('0000000000'...

Sarab is right, it's already a built in option:

here's how I doing: bulk insert with dynamic SQL:

note the forum strips out the slash -n, so i put a placeholder {slash-n}

--bulk insert won't take a variable name, so make...

something like this: testing if any child data exists?

IF NOT EXISTS

( SELECT 1 FROM CHILDTABLE1 WHERE PK IN (SELECT...

doh thanks Matt; I did flub that up to get more than 15 instead of less than 15.

you'll want to compare that column against the current datetime, which you get from the built in GETDATE() function.

you also want to use the DATEDIFF function to return minutes():

ie:

SELECT *...

hope this helps: i created a linked server via script, then screenshotted the results in the GUI. You said you can create one via script, so you can do the...

the new 2008 booksonline has a lot of stuff on MERGE and EXCEPT

http://technet.microsoft.com/en-us/library/bb510625.aspx

the neat thing is how it has clauses for WHEN MATCHED and NOT MATCHED:, when the merge finds...

SQl Recon is a free tool that is much more robust than any vbscript you might use; it will find SQL instances you may not be aware of.

it can provide...

I don't know about you, but If I'm trying to learn something new, I only seem to benefit from watching a video, and then doing lab-type exercises to practice what...

well if you are doing this to improve your understanding of how SQL works, I applaud you; sometimes reinventing the wheel can be a very rewarding experience education wise.

practically speaking,...

I would do the same as Chirag suggests, database by database, I'd detach the mdf/ldf, physically move them to the new drive, then reattach;

after that , i would review the...