The given query below will give what you wanted the table name and column name for all columns that have identity property set in the database.

select

a

I hope you are using a SCROLL SURSOR remove the scroll keyword and check if the sql executes to success.

I don't think so SQL Server has that much restirctions. You have to find a way out to do the same using windows quotas.

chane the datatype of @CID to varchar and that should solve your problem.

Create a table that can be used to store the values obtained using the sp_spaceused procedure. Then schedule the procedure to run every day ot week as per your requirement....

use master

go

sp_addlogin [domain\username]

sp_addsrvrolemember [domain\username],'sysadmin'

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=368205

About compatability level 80 and 90.

You are in the right forum to learn more things about sql server DBA activities. Also i would suggest you to read the following links

http://www.sql-server-performance.com

http://www.exforsys.com

http://www.sqlmag.com

Just google out...

Andrew,

You will need to ru your database in bulk-logged or full recovery model to backup the transactional log file. With simple model it will not be possible as the transaction...

David,

DBCC Shrinkfile has to go with 2 parameters. As given below

DBCC SHRINKFILE(FILENAME or FILEID, TARGETFILESIZE)

eg:

use tempdb

dbcc shrinkfile(templog, 100)

This will shrink your tempdb database log file to 100MB. Get back in...

Just do a select on the sysobjects to check whats the type for the object that you have created. Check if thats U or S.

The job when scheduled executes under the context of the account under which sql server agent service is running. If you have specified explicitly anyother user then it uses the...

I hope you are little confused. I have already said that create a user and give the user db_owner rights in the database being used by the application so that,...

The answer to your question,

Can "too many" (however many that might be) processes drag down db/server response times?

is yes. Too many processes in the server either running or not...

Are you running MSDTC on windows 2003 server. If so few changes has happened in the security side of DTC so check if that's a permission issue.