Make sure SQL Browser service is running on the server and also If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception....

Easy one.

Why restore database for suspect database. Try to find the status of database in sysdatabases table. I had a situation before and status was 8 and when doing...

In current SQL Server error log check for this statement: Server is listening on [ xxx.xxx.xxx.1 2392].

2392 is the port number.

Or you can also find it in...

Sree,

Check this: http://blogs.msdn.com/sql_protocols/archive/2005/10/15/481297.aspx

Apart check,

once I got this error because of mismatch of time/clock between client and server machines. Also, once Windows account password was changed and I was using...

I had been there and tried what you are saying. But failed. You keep getting error now and then.

Finally, uninstalled 2005 from server and re-installed it with desired...

Sqlfrenzy (7/30/2009)

---

An easy way of executing scripts.....

Create a batch file and place it in the folder containing the scripts...

@for /r %%s in (.) do (echo ..............%%s /b >> "C:\Build Deployment\output\Log.txt"...

Never bothered to check all these while scripting. It was mostly copy and execute but CONCAT_NULL_YIELDS_NULL is new to me.

Thanks for article Bob. We use three different third party tools to monitor same stuff but good to have all in one place.

SanjayAttray (7/21/2009)

---

Marcin Zawadzki (7/15/2009)

---

Resource database is not wide known.

We belive in 4 system databases: master, model, tempdb, msdb.

For those who would delete resource database - remember, you have to...

Marcin Zawadzki (7/15/2009)

---

Resource database is not wide known.

We belive in 4 system databases: master, model, tempdb, msdb.

For those who would delete resource database - remember, you have to restore...

This is easy one.

Hell...........it took 20 minutes to single out correct answer after googling.

Why are we seeing so many question these days on Spatial Data ? Think this is probably 4th...

Thanks for the article and bringing the possible show stopper in before I start installing my new cluster next month for a new project.

I added your article in briefcase, to...

Very basic. But, still 16 people got it wrong as of now. Amazing. :hehe: