Something like this should work too.

DECLARE @myColumn VARCHAR(MAX)

SET @myColumn = (SELECT name + ',' FROM sys.databases FOR XML PATH(''))

PRINT @myColumn

Have a look at the response by Mark Kenyon on the following post. That might be what you're looking for.

http://www.sqlservercentral.com/Forums/Topic470550-147-1.aspx#bm471414

1. When Server_A comes back online it will take the Mirror role and resynchronize with Server_B, the principal. To switch the roles again would be done manually.

2. ...

I think that's normal with distributed queries to see DBCC SHOW_STATISTICS commands.

Might be that the timeouts are due to a less than optimal query plan caused by inaccurate statistics.

Have you...

Brandie,

I had that same #13119 message awhile back in Visual Studio. Deleting the following files under my user profile and reopening Visual Studio fixed that.

CD "C:\Documents and Settings\MyUsername"

CD "Local...

This blog entry from Ken Henderson might help answer that question.

http://blogs.msdn.com/khen1234/archive/2005/10/20/483015.aspx

To summarize, one of the indicators is the Attention event under Errors and Warning.

GSquared makes a good point.

If your intended purpose of mirroring is to allow for rolling updates of your server then a manual failover test would probably be good...

To have the mirror and witness on the same physical server you need a separate SQL instance running to host the witness.

Also, if the operating mode is high safety with...

From SSMS a binary file can be inserted using OPENROWSET.

INSERT INTO img_item(img_data)

SELECT * FROM OPENROWSET(BULK N'C:\myfile.jpg', SINGLE_BLOB) AS img_data

In a .NET application a binary file can be loaded into...

I can't offer any insight based on experience, but from your description it took about 10 minutes to get the Unpivot transformation working in SSIS.

[Excel source] --> [Unpivot]...

Since you mentioned using a sort, chaining together two Sort components in the Data Flow would work. This would only make sense if SSIS was running on a server...

Patrick,

Since it looks like SQLCMD is connecting to the instance I would double-check that database name. Maybe test that from the prompt instead of a script file.

C:\SQLCMD -s lebhq-actsql\itdev

1>...

David,

You mentioned that SQL 2005 and Windows 2003 were...

Usage information for that utility can be displayed by typing three question marks after the name.

ROBOCOPY /???

For a single file copy it would look something like this; where SERVER1...

I don't think you can change that in the Tables view in access. However, in text boxes on both Forms and Reports you can set the IsHyperlink property to...