Server administration was blocking the port. Thanks

Just tried. No I cannot telnet to 1433

I'm not sure that I would agree that the stars don't add value. It is interesting to know how active posters are. The stars are simply a measure...

The files are copied by an ARCSERV process but I didn't think this process runs at the same time as my database backup job. I will check into the...

If you enter the command sp_helpfile, the name that shows up in the name column is what you use in first parameter of the DBCC SHRINKFILE. This is the...

quote:

---

Qualified candidates should send resumes with cover letters, including salary requirements to (resumes without salary requirements WILL NOT BE CONSIDERED): ...

If your boss is willing to shell out the money for either Red Gate's SQL Compare or SSW SQL Total Compare then this is may be a easy if you...

Assuming SQL Server wasn't running on the machine you copied from (otherwise you'd probably get sharing violations) and assuming you stored all you databases in this \Data directory (including master,...

I see the problem now. There are the same tables on the old server and the new server but you want the data in the old server to be...

NEWTONS2 is right. Profiler can help with this . For more information how to make profiles record sucessful and unsuccessful logins see http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/prodtech/dbsql/sql2kaud.asp

You can change your SELECT statement(s) to use the WITH (NOLOCK) hint as in:

SELECTs.SourceName,

FROMtablea s with (nolock)

WHEREs.ID = 'test'

Microsoft Name Search should be run under localsystem even if your SQL Server starts and runs under a different account. Check what account the name servers runs under (Settings,...

Are these tables in the database you moved? If so the users need to just point to the new server. Tables aren't just part of a server, they...

Hi Karen. I can't see the benefit if you only have one drive. There is more of a benefit putting index, data and logs on different drives. ...

See Clinton's Stored proc for sending mail. I have tried it and unlike xp_smtp_sendmail (which is still good) Clinton's proc allows the results of queries to be emailed. See