What is actually slow?

If the application is responding slowly then have you tried running the queries ran by application manually under query analyzer? What is the Index structure and index...

There is no such reason tht I don't want to specify but I just wanted to know when do we need to specify it and when its not required.

Basically I...

Thanks for your replies guys. As per Matt I think if sql native client is there then there is no need of specifying failover partner in connection string but if...

Which version and service pack of sql server are you running? I tested it on my standard Edition, SP2 and job didn't run once its disabled even though schedule was...

Try this:

SET NOCOUNT ON

Drop Table #Usersdetail

Create Table #Usersdetail

(

IDintidentity(1,1),

DBName sysname ...

After users are moved make use of below mentioned stored procedure for resolving orphan user problem:

CREATE PROCEDURE SP_AUTOFIX_SQL_USERS_FOR_ALL_DBS

AS

declare @Dbname Varchar(100)

DECLARE Database_cursor CURSOR FOR Select name from sysdatabases Where dbid...

Check the index fragmentation and execution plan of query.

MJ

Massage is correct you cannot delete the primary data file from your database. In your case its file in E drive so you won't be able to drop it.

MJ

Please add and islogin=1 to your where clause as on my installation its displaying rows for userid which is not there under sysusers and not under syslogins too(its weird but...

Take backup of existing user databases or keep their mdf and ldf files before you do any changes to existing installation.

MJ

How many rows are there in transactions table? If its a big table then try indexing this field fld1 which u said is slowing down the query and see if...

It would be better if you make use of cursor and do the same. One time cursor run is fine.

MJ

You can change the name of the virtual server, you cannot change the instance name. For example, you can change a virtual server named VS1\instance1 to some other name, such...

Check under jobs in enterprise manager to see if there is any job which is under execution.

MJ

Contact the database administrators and ask them whether there is any maintenance going on the database or is there any maintenance job(running in background) that lock the database before it...