Remove the "()" from this, "@QTR_EndDate()", in the second one. That should do it.

I don't think there's a way to customize that.

Personally, I've found attaching the query results pretty useless. The formatting is horrible, and it ends up being pretty unreadable.

When I...

You can have a proc query the XML data and turn it back into relational data, if you like. Use Nodes() and Value() functions to turn it back into...

Since it's the clustered index, it actually includes all the data in the column, technically.

You'll have to make that rebuild be "offline". Just change where it says, "ONLINE =...

I was wrong.

Just tested it. Transactional replication from one instance to another. Updates, inserts, deletes, all transfer successfully (and immediately).

Truncate gets this error:

Msg 4711, Level 16, State 1,...

What I tested was mirroring, but transactional replication would do the same thing.

The Log Reader Agent monitors the transaction log of each database configured for transactional replication and copies the...

Steve, that still puts all the results in one tab, doesn't separate the result-sets, which is what I think is being looked for here. (Or I could be over-complicating...

In Management Studio, you can right-click the database and go to Properties, and it will tell you who created it and when.

I just did this:

create database TestCSV

go

use TestCSV

go

create table dbo.testcsvdm (

ID int identity primary key,

Col1 varchar(100))

go

insert into TestCSV.dbo.testcsvdm (col1)

select number

from common.dbo.numbers -- Table with numbers from 0 to 10,000

go

EXEC master.dbo.XP_CMDSHELL 'bcp...

Your partial query doesn't make sense to me. It looks like you're building a Case statement inside a dynamic SQL string, and in the Case statement, you've got table...

The other thing you can do, if you don't want to have to detach the database every time you shut down Management Studio, is set the database options to "Auto...

daverugz (7/8/2008)

---

Guys, along with one of my workmates, we had created a table and made it permanent but we were told to delete this table because someone thought it would...

Nope. I don't see an option for that.

Yes, you can set up two databases to be mirrored from the same server. I just set this up on my test box, between two instances of SQL Server.

I...

Have you tried just running the resulting command?