Robert,

Your msdb database holds the jobs.

You will not be able to right-click and open table on the system table you will need to do the delete from query window

Do a...

The wizard doesn't show the raw scripting, Not sure how familar with Visual Studio but I found a step by step procedure in creating a scripting package

http://www.sqlteam.com/article/scripting-database-objects-using-smo-updated

If you have SSIS up and running do a Source Connection and look at the drop down...it should have an OLE or ODBC connection, any DB then should be able...

this is what some of the suggestions I am thinking about when I read this:

1. When a new user/password is added to the SA db, then that same user/password needs...

So the script you want isn't a generic bcp format with its possible parameters

Like this

bcp AdventureWorks.Sales.Currency out "Currency Types.dat" -T -c

You want a generic select...from...where so you can then put...

Paul,

Easier than VB script...

1. Open Studio Manager

2. Highlight the Database

3. Right-click Tasks/Generate Scripts

4. The Generate Scripts wizard will appear, hit next

5. Choose the 'generate all objects' box

Continue through the wizard

Unbelievable and yet unable to find these simple steps anywhere...

Thanks!!!!

If you do not have the rights to the binaries in the Binn directory you need to talk with your Network admin to give you permissions to that directory tier.

IF...

The bare minimum rights you are going to need is access to the Microsoft SQL Server/MSSQL.1 folder. In this folder contains the SQL Server, SQL Server Agent, etc... executables.

Once...

Cool...ok then I will do that I was concerned about the expression field and simply entering just PC wouldn't work.

Here is your problem...

http://support.microsoft.com/kb/909036

I hear what you are saying but I think the Word doc analogy is comparing apples and oranges.

A .sql file is just that a file. It is not a...

Curtis,

You have four left outer joins. So all rows on the left table are brought back regardless if they match the right table

ps_tkt_hist_tax is left joining ps_tkt_hist on tkt_no...

Curtis,

This is a shot in the dark.

1. Can your run the select in query analyzer in both environments no problem? If the answer is yes, then I wonder...

sg2000,

I think you are going against the grain of how microsoft intended the modify action to be.

When you right-click and choose 'modify' it brings up the existing stored procedure which...