If this is not an ongoing thing, or if you want the user to be able to do this, don't forget about using package configurations which can actually pass values...

I'm assuming you are using this as a variable. If so, in your properties section, there is a EvaluateAsExpression option for which the default is false. Set it...

I actually use SSIS because it does have version control and it's free with SQL Server. It's a pain in the butt to get used to, but it serves...

There is also a very good video at the following link. B Knight is one of the founders of this site and is well known in the SQL Server...

Connect the shared storage buses and assign drive letters

Updated: January 21, 2005

To connect the shared storage buses and assign drive letters

1.

Install Windows Server 2003, Enterprise Edition or...

Steve

I definately agree with you. Raid 5 is a bad choice, If an organization wants to persue a data warehouse then they must know that the hardware must be...

Also

If you have enough drives, seperate your TEMPDB to a drive by itself, preferably raid 0 (it's rebuilt every time you start SQL server).

Raid 5 can be used in a...

The virtual IP used should be provided by the sys admins. Tell them you need at least one IP for each NIC of the SQL Server, don't forget about...

Did you set the credentials and proxy for the SQL Server agent. if so, check to ensure they have the proper rights. Backup/w network issues can be a...

Bobby

Are these database files? If so, you probably shouldn't delete the files, unless they belong to a database that is no longer needed (then you would delete the database...

Lynn

Sorry, I was too lazy to convert my code to ansi standard, and yes I know it should be. That's what I get for being lazy.

yes yours is cleaner

Thanks

Try this. It uses a derived tables which are one of the powers of 2005.

UPDATE CLIENT

SET PRODUCT_CODE = b.NEW_CODE

FROM CLIENT, (SELECT OLD_CODE, NEW_CODE FROM PRODUCTS_CODE, CLIENT WHERE OLD_CODE =...

Kishore

Dead on advice, exactly the procedure I used in a similar situation. This can also be used for your offsite storage as well.

Gail

Good advice on the use of DBCC in the production environment. Right on point, far to often I have seen the busy server turn dead and the DBA looking...

Debbie

The wrapper proc is the top level stored proc you are talking about. The only thing you need to do is create the top level stored proc and ensure...