Google returned these

http://www.sqldba.org/articles/36-check-if-file-exists-in-sql-server.aspx

I would suggest the last one xp_fileexists

-- last check file exists using xp_fileexists

DECLARE @Path varchar(128) ,

@FileName varchar(128)

SET @Path = 'C:\'

SET @FileName = 'FILE_NAME.EXT'

DECLARE @i int

DECLARE...

Look for

AdventureWorks_Data.mdf

or

AdventureWorks2008.mdf

on your hard drive

or

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

and directly attach them in SSMS 2008

Yes, you need to upgrade to SSMS 2008 to connect to SQL 2008

SQL 2005 SSMS cannot connect to SQL 2008

I resent Twitter (looks like a good choice, ha)

Facebook - check 1~2 times daily

LinkedIn - don't check often but once in a while, usually just wait for emails

No MySpace at...

I've done MCTS & MCITP 2005

Standard fee is $125 USD

but you can buy certificate vouchers from elsewhere from $105 to $115 USD

e.g. http://www.getcertify4less.com/microsoft.asp

There may be a 50% code coming Apr...

To revive an old thread, just to add this is still an issue.

I know people don't normally see 7.0 databases anymore, but here I am, seeing 20+ of them

I...

Krishna (3/27/2009)

You can...

I think it'd involve connecting to a remote server (either via OPENROW or Linked Server)

compare the sys.logins table, and DROP LOGIN

Look at the Microsoft SP sp_help_revlogin

http://support.microsoft.com/default.aspx?scid=kb;EN-US;918992

To go to extreme, you...

Both links led to errors

unless I am clicking while Steve is still editing

This week there was a process sitting in sleeping status AWAITING COMMAND that blocked some other processes, and cascading effects was about 100 processes blocked

Killing the process resolved the issues...

Log Shipping wizard has always generated 1 on PRIMARY and 2 on SECONDARY for me, every time

What did you put in for the "Secondary databases"?

Did you actually see a...

In SSMS, right-click on the DB -> Tasks -> Shrink -> File

change dropdown to "Log", and see the free % in there of 32GB

You can do a BACK UP LOG,...

I thought that's...

SQL server is powerful, but it cannot do everything for you

Logs will be in Error Logs and SQL Job histories, I think there are Log Shipping monitors tools out there...

Interesting

Can you add a output file in the Job Step (not the Job level, but for each step) to a .log file

Then see if the log says anything (beats the...