I don't know of anything that will tell you what is being used from an automated fashion. I suspect that you'd need something that combs through SSRS logs and tries...

Just ran this:

C:\Users\Steve>bcp "select * from db1.dbo.mytable" queryout out.txt -C -T -t "|" -S sevenfalls

I didn't see a server name in yours.

Haven't tested them together, but both have worked for me. I have been hesitant to use them without stopping SQL Server. Even then, make sure I have 2 backups, just...

Not to make it more complicated, but where are backup files going? I'd make sure you have space somewhere separate from the data files.

Do you use tempdb a lot? If...

The transfer task, if it's the same as 2005, just automates the object creation and then the transfer of data from one place to another.

It works, but you could potentially...

Be careful of using LEN, as noted by Philpacha.

Datalength is much better: http://msdn.microsoft.com/en-us/library/ms173486.aspx

Note that the default trace is limited in size, so it might not be there.

This can be hard to track down if a lot of activity has happened on the...

Congrats!

Brandie Tarvin (6/9/2011)

---

Hey, Steve (and other Prius owners), I just heard about this and wanted to pass it along:

Toyota says a problem with electric power steering is prompting a recall...

Brandie Tarvin (6/9/2011)

---

Just a reminder for anyone in or near Dallas this weekend. I'll be attending A-kon 22 to promote and sign anthology copies of The Ladies of Trade Town....

Something like this:

declare @t varchar(max)

declare @n varchar(50)

set @n = 'MyAppMyTable'

select @t = 'create table [' + @n + '] ( [Person_ID] [int] NOT NULL,

[MayLog] [bit] NOT NULL,

[Rubrique] [bit] NOT NULL...

Glad you liked it. Not sure you can read much into the distribution since it might be a guess for many of the correct answers. This wasn't to try and...

That sounds right, but out of curiosity, are you trying to use this for something?

date meaning data published?

For repeats, the latest date?

What about tags?

you are missing the point. Log shipping is not just there for handling...