Along with the other suggestions, I'd also take the time to upgrade to at least Service Pack 2. From what I saw on my own machine, SP2 fixed a...

Heh... no, not a waste. In fact, thank you very much! I now know how long it takes to create an index on an INT column that has...

Oh yeah... almost forgot...

The "AT linked_server_name" probably cannot be a variable... you'll need to use dynamic SQL to create the EXEC's, and then execute the dynamic SQL. That can...

Damned smiley faces... wish they could fix that...

Here's the listing without the smiley...

[font="Arial Black"]Execute a pass-through command against a linked server[/font]

{ EXEC | EXECUTE }

...

I've never had to do that before but, according to BOL, here's the correct syntax for how to do it...

[font="Arial Black"]Execute a pass-through command against a linked server[/font]

{ EXEC |...

I also checked the UPDATE() function (you never know)... the one that checks per column... same disappointment...

DROP TABLE dbo.TriggerTest

GO

CREATE TABLE dbo.TriggerTest (ColA INT, ColB INT)

GO

CREATE TRIGGER MyTrigger

...

Wow... I just tried it...

CREATE TABLE dbo.TriggerTest (ColA INT, ColB INT)

GO

CREATE TRIGGER MyTrigger

ON dbo.TriggerTest

AFTER INSERT, UPDATE

AS

SELECT COLUMNS_UPDATED()

GO

INSERT INTO...

When you guys made the "new" TempDB, did you make sure it was still set to the "Simple" recovery mode?

Heh... loops... IF's... RBAR...

The hard part is figuring out how many of each character type is in the password and the following code figure that out nicely. You can...

See the following article for how to do the CSV concatenation along with some pitfalls to avoid...

http://www.sqlservercentral.com/articles/Test+Data/61572/

To help us give you a better/tested answer, take a look at the link...

Can you show what you've tried, so far?

UPDATE t5

SET UpdateField = CASE

...

timothyawiseman (11/13/2008)

---

Heh. Robert and Mohit have a point. Instead of triggers views could be used to let a legacy application interact with and change the data in the...

It's been a while since I've had to do such a thing, but that just doesn't seem right to...

Thanks, Goldie. Glad to "meet" you. I appreciate it. 🙂