Hi

Have u indexed the correct column?? one more thing is that when u are using a SQL to retrive data from the...

Thanks Jack

All the applications use SQL Logins, So i am planning to get one Schema to each Application. But...

Hi Jaaba

Check the surface area configuration on your server, you have to enable to Open rowset option on the...

Hi Robert

As other said that this is half a days job, max of a day, in case if...

you can use any login that have administrator previliges, linked servers can only be created by logins that have admin previliges

Cheers

🙂

Hi Ericzbeard

Try this

** Open SQLMS

** Connect to ServerA on Object Explorer

** Expand Server, Click on...

Hi

What RAID are u using, what's the SQL Configuration, what's the performance issue you are facing, since then some one can suggest that the counters that...

Can't you use Between instead of = ???

🙂

Hi Magic

Have u figured out which Query was causing this problem, i mean was it for a Query or for...

Hi

you can write a script to restore all the databases, once you need to bring the warm servers live then run this script, the same...

Hi Scott

DBMail Defenitly works on SP2, i am working with it, please check the configuration, else if possible...

Thanks mate, but can i make this as a job that runs every 1 hour and kills the process that runs for a long time

Cheers

🙂

Thanks White

I have just found out that he old instance has been configured with...

Thanks G-Squard

There is no such instance on control panel, so i cant...

Thanks for your post, exactly, when i see the screen for Authentication there is one instance name (say XX) for MSSQL and other instance name for reporting server ( say...