Hi,

May be you can try querying the "sysprocesses" table filtering on the nt_domian/nt_username columns. If user is logged in, it should return the corresponding rows.

Hi,

In Taskpad view the size is shown in MBs. Ideally it should match with the results of DBCC SHOWFILESTATS.

@used_space=(CONVERT(dec(10,2),usedextents*64/1024))

@total_space=(CONVERT(dec(10,2),totalextents*64/1024))

The results are in MBs and should match with Taskpad view...

I am not sure if there is direct query or a command, but if you use DBCC SHOWFILESTATS it returns Total extents and the Used extents of the Database; if...

Hi,

In the Enterprise Manager, usind Taskpad view, the fress space can be verified.

Hi,

Yes. SQL 2000 and SQL 2005 can be installed on a single machine.

Hi,

There is another method to get the last executed SQL statement through a client session using a built in table valued function : fn_get_sql .

DECLARE @HANDLE BINARY(20)

SELECT @HANDLE = sql_handle...

Hi,

The maximum number of instances "supported" in SQL Server 2000 is 16. It can vary as the number of instances that can run on a single computer depends on available...

Hi,

Check the below link, it might help you.

http://www.microsoft.com/downloads/details.aspx?familyid=3D5E96D9-0074-46C4-BD4F-C3EB2ABF4B66&displaylang=en#QuickInfoContainer

Thank you Steve for your reply.

We tried with 2 previous backup sets and had no luck.

We are now given a machine which is built completely in German interface (same...

You can query sysobjects table. The field "type" holds all the object types in the database (Tables, procedures, triggers, constraints etc., identified by type). The datatypes of the columns of...

Hi,

Hope this helps your requirement.

xp_logininfo 'Windows Group Name','members'

Hi,

The sysusers table holds all the users (SQL and windows) information. It also includes the roles in that database. If you want to exclude the roles, may be you can...

Hi,

It can be done in 2 ways.

1. Open DTS package. Go to Package-->Save as ; Location- select as SQL Server and choose the destination server and provide the credentials. Click...

Hi,

Setting up database in single user mode does not kill SPIDs. But, if there are any active connections to the database exist, then it would not allow you to set...

Is that CSV file is populated everyday or is it appended. In case it is appended everyday and if it was working fine till yesterday, may be you can check...