Hello Ajay,

Here are answers to your questions.

Q: If they are in sleeping mode yet can they be a reason of

slow performance?

A: Sleeping means...

Hi,

This is very general error message. Now the first thing that we should do is please check

1) Can we Succesfully start from SQL Server Configuratio Manager.

2) Can we Succesfully...

Hi,

Its good idea to have multiple FILEGROUPS so that you can spread your data to different files which will give performance improvement as well if placed on different drives all...

Hi,

Below is the meaning of DORMANT.

DORMANT

*********

Same as "sleeping", except a "DORMANT" SPID was reset after completing an RPC event from remote system (possibly a linked server). This cleans up...

Hi,

Sorry but your last statement " DATABASE IS IN SIMPLE RECOVERY MODEL" & "LOG FILE BACKUP IS DONE EVERY HOUR", how this is possible? In Simple recovery model we cannot...

Hi,

Please refer to below MSDN article and it will give answer to your questions.

http://msdn.microsoft.com/en-us/library/ms175511.aspx

Regards

GURSETHI

Hi,

I did a small test at my end.

1) Created a local windows account (Gurpreet\test).

2) In SSMS created a WINDOWS LOGIN which is mapped to this newly

...

Hi,

Please go thru this link. I am sure it will help you out.

http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

Hi,

Good one. I can provide a handfull list for sever hung but I have some questions before that:

1) As you mentioned we are not able to connect to SQL Server,

...

Hi,

I am not able to fully understand the question but what ever I can here is the crux.

Q: We have 2 tables Table A & Table B.

...

Hi,

As you mentioned that the size of DB is 1 TB and 3 od the tables

history

Archive

(3rd one you have not metioned)

which aer of 500 GB and want only them...

Hi,

Good one. I have some questions on this.

Problem Description

================

--Procedure when called from Query Analyzer processes 100 records/sec.

--Procedure when called from a Job processes 10 records/sec.

Questions

==========

--Are we doing this...

Hi,

So here is the deal.

1) We have to stop mirroring every month in order to do our routine

work.

2) We don't want to Re-initiallize it from scratch.

In...

Hi,

Now your server 2000 and 2005 are in different Box, say server 2000 is your client, and 2005 is your target server. So, first, try...

Hi,

yes this is normal. When we provide location for keeping up the files it didn't differentiate between a MDF or LDF file it will initially keep MASTER DATABASE files (MDF...