No doubt about it. The methode Michael Earl proposed is the simplest !

- Simple

- Straight forward

- complete

- no log overhead

- the space you need = the space of your prod...

This would mean the column's value must exist in both "parent" tables ?

IMO that doesn't feel like it should.

A key is just a key and should represent nothing else...

If I'm correct, this is one of the features SQLCMD has.

You can use DOS-variables with it!

Check SQLCMD in BOL !

Also keep in mind that with Windows 2003 you can use "mounted drives" to get over the 26 letter drive naming.

Each of these mounted drives can point to different luns,...

In a view each column needs to have a name.

The querybuilder gui just puts Exprn if you don't provide one.

Regarding the layout,...

John Carlson (5/13/2008)

---

I am attempting to use xp_cmdshell to start and stop a remote application server in a job.

When executing the following:

exec xp_cmdshell 'sc \\MYSERVER stop MYSERVICE'

I get...

Are you on RTM, SP1 or SP2 ?

Indeed, you'll spend most of the time getting used to the new GUI with SQL2005.

You can always right click on a table and select "edit" (SP2) then it will show...

can you post the ddl of XML_GSK ?

did you have a look at "http://www.sqlservercentral.com/scripts/Miscellaneous/30268/ ?

You may be better off taking this question to a new thread.

Check BOL for "Understanding Synonyms " (Local BOL url) ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/6210e1d5-075f-47e4-ac8d-f84bcf26fbc0.htm and...

- 15 million rows per month = +/- 350 rows a minute. Should not be a problem.

Try to implement as many best practises a you can, because it can go...

Jeff Moden (5/9/2008)

---

Mine's a nice little ol' man's bike... Honda VTX 1300 S (retro with spoked wheels) and something I love dearly... shaft drive. Took me a long time...

So the queries are known and fixed, just the db is unknown

and the executors have the needed rights to read the data.

- are this individualy single database actions ...

Seing that sqlcat list, this may also add to a well concerned decision:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx