[font="Verdana"]Do the below steps and see:

1.Goto Enterprise Manager.

2.Right click on the servername

3.Goto properties

4.Click on 'memory' tab and see if 'Dynamically configure SQL Server memory' radio button is selected.

If 'yes' then,...

[font="Verdana"]You should be able to see it, from SQL Server itself. When adding a new login, click on browse and search in the whole directory. you should be able to...

[font="Verdana"]Run it. Schedule it as a weekly job if you are monitoring space to make adjustments...

[font="Verdana"]Don't want to sound like an idiot but, why can't we install ODBC drivers on a cluster? I thought, as long as the drivers were available...then the DTS will work....

[font="Verdana"]How to increase size of database (Enterprise Manager)

http://msdn.microsoft.com/en-us/library/aa197143(SQL.80).aspx

HTH :)[/font]

[font="Verdana"]Hmmm...interesting. Did not think about the scenario you detailed. But, it is always good to know these sorta things. Thank you :)[/font]

[font="Verdana"]I don't think so. See the following extract.

----------------------------------------------

http://doc.ddart.net/mssql/sql70/sp_ae-az.htm

----------------------------------------------

The effect of sp_altermessage with the WITH_LOG option is that it changes the logging behavior of an existing message.

If a...

[font="Verdana"]

--CODE PROVIDED AS IS.

SELECT BS.SERVER_NAME,

BS.DATABASE_NAME,

CASE BACKUPTYPE =

WHEN BS.TYPE = 'D' THEN 'DATABASE'

WHEN BS.TYPE = 'L' THEN 'TRANSACTION LOG'

WHEN...

For Transferring maintenance plans between servers:

http://www.sqlservercentral.com/Forums/Topic614875-5-1.aspx

[font="Verdana"]I found this while browsing couple of days ago. Did not test it but, I hope it helps.

Original Location:

http://www.dbforums.com/archive/index.php/t-883004.html

Request you to, not remove the Author comments on...

[font="Verdana"]You have two locks. One is an eXclusive(X) lock for the insert and the second an Intent eXclusive(IX) for the update. These lock types are incompatible( Search BOL: LOCK COMPATIBILITY)...

[font="Verdana"]I could be wrong but, this looks like a permissions issue. Maybe, you don't have rights to access the registry key. Just check and see.[/font]

[font="Verdana"]

If you run the SQL2K5 setup on a box that has SQL2000 instance(s) on it, and choose to...

[font="Verdana"]What kind of upgrade are you trying to do? In-place or Side-by-Side? If you are doing a Side-by-Side upgrade, the easiest way would be using the copy database wizard and...

[font="Verdana"]

I think we all missed this 🙂 He is using a linked server to access...