Also if you expecting the integer value to be return then why you creating your @..... as char type?

if its numeric then what do you mean by

Else 'July.F1007'.

not sure but could be the reason.

you can justify by giving the data like :-

1) how important your database performance and role fo tempdb in this.

2) performance comparison by putting the temdb log on another drive...

so whats stopping you to do this....

if account you want in sql then create sql account else windows account and give required permission to that specific account

FROM Sales where Sales.SERVICE = SERVICE.SERVICE or sales.service is null

OR if it different table then

FROM Sales where Sales.SERVICE = SERVICE.SERVICE or SERVICE.service is null

no problem....just bit more explanation with code what I was saying earlier...

in bat file

for /f %%G in (serverlist.txt) do sqlcmd -S %%G -E -i serverversions.sql

or if the...

my personal view.....

first check your database that which are the tables consuming most of the space. google it, you will find the query how to find the tables sort by...

try this:-

select convert(char(8),getdate(),102)

you can delete all the data by comparing to temp table and then as temptable have unique record you can import it back to original table

something like

select * from table...

once you get the serverlist in text file then you can use that to check server version and other details by running query which you will run on any specific...

i am not talking about replication monitor, i said activity monitor where you can see if any process is still running for replication

use master

go

drop database 'adv...dw'

check if dist.. database exist in system database or not?

If in sql server 2005 or higher, check activity monitor. Might get some clue what process still running

are you restoring with correct version...

what i mean is...

lets say if the backup was taken by litespeed and you trying to restore from management studio or by sql server restore...

open cmd and run

sqlcmd -L

if you want output of this in text file, lets say in c drive then :-

sqlcmd -L >c:\serverlist.txt