default location is C:\program files which is not good location for system databases for anything other than a PC installation.

define a directory on a drive other than C drive and...

if distmdl in same location as master upgrade will work

shame you had to go thru all that pain, the simple solution is to just stop SQL, move the distmdl files with explorer and restart SQL.

SQL is not using distmdl files right now so just use explorer to move them to the new location. Not sure whether SQL will need to be down or not,...

apart from tempdb potentially I have always thought separating data and log for system dbs WAY over the top..............

so this is homework? Look up BCP in books online.

theres another current post on this subject:

http://www.sqlservercentral.com/Forums/Topic220317-146-1.aspx

this technet article is the one I would believe on moving 2005 system databases. it says master and resources must be in same location

http://technet.microsoft.com/en-gb/library/ms345408(SQL.90).aspx

In...

its not possible to have the engine run in 'SQL Authentication ' mode only.

If the users can connect via SSMS without an id and password then their windows ids, or...

from what I remeber from posts on this site if the resources database is not in the same location as the master database SQL upgrade can (will?) fail. The...

SanjayAttray (9/9/2008)

---

My tempdb database property shows size as 16.6 GB and space available 99%. when I look at shrinkfile window datafile show 16.6 Gb size but in shrinkfile size...

go into sql server configuration manager, right click the service and...

Steve, most DBAs and developers you know don't get overtime pay? For a DBA at least out of hours work is a given so I hope they are compensated for...

we use diskkeeper too with no problems

dirkstraathof (9/8/2008)

---

Hi George,

Thanks for your quick answer... But I'm still not sure which hotfix does what...

I was running Sql Server 2000 build 2187 in a test environment. So I applied...

expand the FAQ section on article http://www.microsoft.com/technet/security/Bulletin/MS08-040.mspx, that will explain it.

which fix you apply depends on your current version of SQL (run select @@version). I have applied both patches, and...