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

Hugo Kornelis (5/9/2008)

---

Hi...

Jeff Moden (5/8/2008)

---

It's a 1995 Honda NTV650. (The little brother of the Pan European)

It's current evolution is known as "Deauville".

Quit fault...

Correct me if I'm wrong but IMO if result changes because of a changed index, your query symantics do not reflect what you want 100%!

In the example you've...