Sorry for the blank post. You could use sp_executesql to execute two commands like so:

declare @cmd nvarchar(4000)

set @cmd = 'select colname' + char(13) + 'exec strdprc'

exec sp_executesql @cmd

Is this...

quote:

---

Hmm, since that was too easy, now let me complicate it

I want to generate a view (not hard)...

Could you post the code for you SP?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

I guessing you might want to think twice before killing. The command might be repairing the database, and killing it might corrupt the database that is being repaired.

Why do you...

I'm not sure that copying the txlog from box a to box b get all the committed transactions to box b. Since the transaction have already been comitted on...

This command will run under the MS SQL Server service account. Is that service account set up to have network access (meaning is it a domain accout), or is...

I don't mean delete every record, but only the ones you are planning on updating. If the records are a true replacement, then you should be able to delete...

It is true you can only have one connection open in single user mode, but the service running at the command prompt does not count. I'm normally able to...

I don't suppose you can do a delete and insert, instead of an update? Are you expanding the records sizewise, with all the set statements? What is your...

You are not suppose to get your command prompt back, until SQL Server is shutdown. What you are seeing, are the messages that normally would be stored in the...

If you want to transfer SQL Server logins between SQL Server machines, then read this KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website...

Try a recursive call. Here is some code I got off the list from someone. Sorry I can't remember who. This might help.

create table employeelist(id int, parentid...

Try something like this:

select * from table where convert(char(10),yourdate ,101) = '04/11/2002'

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

I think the standby option is required to be set to an undo file file, like this:

STANDBY = undo_file_name

check it out in BOL

Gregory Larsen, DBA

If you looking for SQL...

How about inserting the records from table 1 and table 2 into a third table "Table 3". Then you could run a select statement from table 3 to output...