While creating the table to store filestream data you have specified the filestream file group with the keyword "FILESTREAM_ON". Is it necessary because i did not find the same in...

sknox (9/3/2009)

Yes. That will catch the error as it happens. So you determined the value of...

As you mentioned you need to find out from the where is the SQL DMO backup command being executed. I can give you some pointers on how to find out.

1)...

This is what i did

begin try

EXECUTE sp_rename N'fakename', N'fakename2', 'OBJECT'

end try

begin catch

select @@ERROR

end catch

I found the question confusing. It asks for value of @@Error which is 15248. I put the statement in a TRY/CATCH and got the @@Error as 15248.

Hi

Your question is not clear but are you are implying that 2 different processes are taking a backup of the database at the same time. If that's the case...

If you are not going to take advantages of SQL 2005 specific features why upgrade ?

I haven't tried this but if you have a maintenance plan then i suppose you can modify the plan. If you have a T-sql statements put in a job...

Glad i could help.

You can do a select distinct and insert the records in a new table , drop the old table and rename the new table to the original table. You can...

You can check out SET ANSI_WARNINGS statement although i am not sure whether it will help.

Matt is right you would want to do this inside the database rather than outside. One suggestion is to do this update in small batches rather than on single update....

You can do DML and DDL operations only on the table variables defined in the function.

Well you cant combine the 2 files but you can move the objects from one file to another and then remove the empty file.

what for?