the only other thing you might want to do is the upgrade will create schema for each SQL account and set that as its default schema. As most SQL2000 dbs...

good stuff, thanks for posting back

Perry Whittle (7/19/2011)

open reporting services configuration manager and when setting the SSRS instance details a set of database connection options are there, simply...

if you are just after a rowcount then

sp_spaceused after a dbcc updateusage,

rowcnt in sysindexes where indid = 0 or 1,

a max value if you know you have...

sorry thought you meant test centres, which prometric is for when you want to take the exams.

Prometric often seem to use QA training centres.

try the prometric site.

they have a number of test centres dotted around london. If you are in the city there is one in king william street.

Definitely worth spending money on...

yes

duplicate post.

answers here:

http://www.sqlservercentral.com/Forums/Topic1144043-360-1.aspx

you are asking for a count to be returned, that cannot be done by a seek. the smallest index will be scanned to return the count value.

the correct answer here is - you don't want to start from here.

Best practice would be to place the system databases where you want them as part of the install...

check very carefully what you have specified the task to do. Its probably something simple like directory path wrong or putting the suffix incorrectly (i.e. .bak when it should just...

Its frequent enough for full backups but to be able to use mirroring your databases must be in full recovery mode, therefore you MUST do transaction log backups as well.

they may mean this:

http://sqlfool.com/2009/03/ssms-server-settings/

off the top of my head -

c:\program files\microsoft sql server\90\setup bootstrap\log

adding 'order by name' to the query might make it a bit easier to find the correct database statements