NewID() seeds from a combination of the network card identification number (unique) and a number derived from the CPU clock. While there's no such thing as "truly random" in...

You want to place the files in the locations you intend to use them, then use the Attach Database command from Enterprise Manager/Management Studio or look into using the CREATE...

I'd always recommend your first line of your trigger is to check @@ROWCOUNT to see if any data was actually affected.

IF @@ROWCOUNT=0 RETURN;

I'd recommend that.

Well in the context of your EXEC(), the variable @WorkQueue is not declared. If you've declared it earlier you'll need to either parse it in or pass it in...

Then I'd go with Anita's technique above which will produce similar results.

If you're using SQL Server 2005 I'd consider using database snapshots. I've been experimenting with scheduled created database snapshots for reporting purposes and have found they work surprisingly well.

If you want to parse in single-quotes, use two of them in your string:

select * from employeedetails where edescription='employee name is ''john jackson'' and state is ''ca'''

SSIS is a little more detatched in my opinion than DTS was, being its own service now. You can connect to the SSIS instance via Management Studio by changing...

Kathi-

One thing you can do is go through the Reporting Services Configuration tool in 2005 and rebuild the RS databases in another name. That could help you check for...

This seems like a problemmatic approach.

For starters, you have to trust the validity of these insert/update statements to perform what they say they're going to perform. You wouldn't know...

Your first bet might be to ask the users if they really need 10 million x (however many tables there are) records. I've never run into a situation where...

In SQL Server 2005 you can use EXECUTE AS.

Your version number there indicates you're not using SP1. You are for Windows but you must also patch SQL Server 2005 up to its service pack 1 to access...

SELECTLEFT(value, CHARINDEX('/', value) - 1)

FROM table

That should do it...

I assume you're working in 2005. If you're working with SP1 you should be able to set a checkbox within the Maintenance Cleanup Task for "Include first-level subfolders" and...