Your query will not work in sql server..also you dont need subquery for this..

try this..

select bar

from serves join likes on

serves.bar = likes.bar

and likes.drinker =...

If drive space is constraint, you can create new database snapshot after every update in chnuk. This way disk space issue will be minimal .

You can try finding the process using SQLMail and kill it.

or try doing this

EXEC master..xp_cmdshell "Kill MAPISP32"

NJ

try to do..

xp_stopmail and then xp_startmail

NJ

kyle,

You can find this @key location by runnig regedit also for verification. This is the default location in registry for sql server parameters and configuration.

You can also search...

Actually i am running this script in my environment which have all default instances so working fine for me..

Anyway thanks for valuable advice.

Thanks

NJ

This will work for Sql Server 2000

DECLARE @test-2 int

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key='SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',

@value_name='AuditLevel',

...

Sql server saves this information in registry.

You can use this query to get the info

DECLARE @test-2 int

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer',

...

gundulz,

We are doing this refresh during database maintenance window and i also made sure that there was no user connected to the database.

Moreover we are moving the database which doesn't exist...

Adam,

You can modify the logical file name of the database using alter database command even after restoring from the backup.

ALTER DATABASE 'DB Name'

MODIFY FILE(NAME = logical_file_name, NEWNAME = new_logical_file_name)

GO

Maya,

For killing the connections u need to run the script using the sysprocesses system table for active users and moving the databse to single-user mode.

You can not use EM and...