Another possible way is like so.

ALTER DATABASE dbname

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE

then run your restore and take out of single user mode.

I see now. In order to get what you want you have to build the entire thing dynamically.

DECLARE @Query VARCHAR(8000)

SET @Query = 'Select user_ssn

From OPENROWSET(''provider'',''server_name'';sa;pswd,

''EXEC db.dbo.proc_name ' + @parameter1 +...

I do believe it is

sp_mergecleanupmetadata [ [ @publication = ] 'publication' ]

[ , [ @reinitialize_subscriber = ] 'reinitialize_subscriber' ]

Just make sure you set @reinitialize_subscriber to...

Can you post the DDL of the table from DB1 and DB2 for the underlying tables and the view. May be that something about the datatypes is causing the issue....

There are just too many possibilities. If starts occurring more often you can open the package then open the package porties and set logging up to possibly give you a...

Check out the following thread. http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3389&FORUM_ID=19&CAT_ID=3&Topic_Title=Run%20DTS%20package%20from%20stored%20procedures&Forum_Title=Data%20Transformation%20Services%20(DTS)

Check out this thread. http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3389&FORUM_ID=19&CAT_ID=3&Topic_Title=Run%20DTS%20package%20from%20stored%20procedures&Forum_Title=Data%20Transformation%20Services%20(DTS)

You can't you can only remove the conditional processing to prevent from occurring.

The way we do it is setup a dummy DB that has nothing but a control table to know what the logged in user has access to. All users when...

Also, in you backups make sure you turncate the transaction log periodically right before the ful backup. Unless you are using simple recovery model. Even then set a max growth...

I am pretty sure they are but there are no guarantees and if not the process could potnetially work for a long time and then fail without notice.

Duplicate post see additional response in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8580&FORUM_ID=23&CAT_ID=2&Topic_Title=New+to+SQL&Forum_Title=General

Front Page is easy to use as is DreamWeaver but nothing as simple as Access forms to build. Ths best places I have found to look for ASP, PHP or...

quote:

---

quote:

---

Is it possible to import a single binary/text file into an...

quote:

---

From 1st hand: we took the create a linked server and query over approach. Oracle has a nice provider and the...