Glad we could help.

I haven't used those other tools, but I have used ROBOCOPY and I've been very happy with it.

Heh. Well, thank goodness no one knows that we make mistakes. 😀

Ahhrrr!!!

try it like this:

CREATE PROC spWhichTable

@ColumnName varchar(50)

AS

SELECT o.name as [Table]

, c.name as [Column]

FROM sys.tables o

JOIN sys.columns c ON o.object_id = c.object_id

WHERE c.name = '@ColumnName'

...

You should use dynamic SQL for this, unless you want to make one stored procedure for every business unit.

Heh, I just assumed that you were leaving something for...

Thanks for the feedback, Gary.

Probably himself. Seriously. It's easy enough...

Why are you using Varchar's for your dates? why not use Datetime datatype?

Actually, Anton, what you are describing is extremely non-standard functionality. SQL Server is actually...

Jeff Moden (11/29/2008)

---

What is true about triangles? The hypotenuse has a ratio to the sides no matter how long the sides are. You do not need to calculate...

I don't really have a problem with someone who has a bunch of certs asking questions on methodology or approach. IIRC, the certs don't really test for that sort...

You posted XML got eaten by the security filters. Please repost it as a .txt attachment.

What question are you asking?