This may help you

DECLARE @session_id int

Declare @command varchar (max)

DECLARE DATABASES_CURSOR CURSOR FOR

select session_id FROM sys.dm_tran_active_snapshot_database_transactions

where elapsed_time_seconds>30

OPEN DATABASES_CURSOR

FETCH NEXT FROM DATABASES_CURSOR INTO @session_id

WHILE @@FETCH_STATUS = 0

BEGIN

SET @command='KILL '+convert( varchar(2),@session_id)

exec (@command)

FETCH...

Thanks steveb

I got the point. I ran index rebuild job and update statistics without checking whether indexes are there or not. Actually keys,indexes are not copied when copied using import export...

It was copied using Import and export wizard. There is no fragmentation of indexes and statistics were updated.

The application is connecting to the database through ODBC and default database is...

Hi grant,

As you said ANSI 89 outer joins are no longer supported in 2008, I have one doubt. If we change the database compatiblity level to SQL server 2000, will...

http://www.mssqltips.com/tip.asp?tip=1240

You can pass single value at a time using a single variable.

@suresh Nice example

select name, code, status, COUNT(*) "rowcount" from tablename group by Name,code,status

Is it a domain account that you have created on your server?

So apart from that, there are no other option like adding my account to a group which is having sysadmin access like that?

SP2 is redownloaded and server is restarted but it does not start after extracting the files. Can it be somthing is missing in server?

I checked system log and it has two information log during that time- "The TPM Base Services service entered the stopped state." and "A compatible Trusted Platform Module (TPM) Security...

Hi,

It is SQL server 2008 with SP1. I checked the logs here in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log. But there is no logs with todays date. Actually once I run...

you have to run it from cmd prompt.