Yes I tried this already. Surprisingly "If exists" works if I use it individually and when I use "script drop" it just drops the table but doesnt check the condition...

Thanks Andrew. Yes I know this is SQL Server site and I have been a member here for some time now. I must appriciate all the help I have got...

I didn't know and thought of taking help from people here who are experts and know much more than I do, that was the only reason I thought of posting......

I dont really know what this statement means. I would like to convert this statement to SQL and apply it on one of my tables. Got this from the user...

Thank you for the reply Jeff...

there is a comma between 100 and 200, won't it cosider comma?

see if this helps...

http://support.microsoft.com/kb/961126

You can also use this,

select DB_ID ('Your DatabaseName')

select spid from sys.sysprocesses where dbid = YourDatabaseId

kill

Okay, thanks for the reply. I would probably move the log file to some other location if possible.

Thanks both for the reply,

If I change the recovery model to bulk logged, and then shrink -- will it help?

Each file has column names in the header and they are separated by tab. 3 of the 10 columns will be varchar(500) and the others will be float. This is...

You guys are awesome... Thanks both...

I came up with something like this,

declare @string varchar(100), @len1 int, @new varchar(100), @lenfinal int, @newfinal varchar(100)

set @string = ';ABCD;EFGHIJ;'

select @len1 = LEN(@string)

set @new = LEFT(@string,...

I am looking for the second option. There is only one text file which is zipped and I want to unzip it on the fly and load it in to...

Thanks everyone...