Anyone?

Yes, static login. Not impersonating. If I connect directly through management studio the same query works fine

i'm sure this isn't the world's best solution, but i've done it on a number of medium-sized projects with good results.  i keep the entire database create script in source...

sql rather splatters its installation log files (typically) at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\ and below.  i've often found clues to install failures there.  if you call microsoft that's the first...

can you connect to it logged on locally?

check that sql server is running on the server you're trying to connect with (of course)

check the protocol you're connecting with (click the...

i believe shutdown is from the Resource Kit for Windows.  check http://www.microsoft.com/downloads

thank you jeff, for your excellent example code!

if you need the new column(s) to be NOT NULL constrained, you can accomplish what you want in two steps.  first create the column you want and provide a default...

bob,

long articles and whole books have been written about the rationale for configuring resource intensive databases.  if you had a high transaction volume or large number of users, there are...