That won't be a good idea if you have 25 columns in the table and you need 24 of them selected. I will rather drop the column I do not...

Thanks. The execute did work.

Thanks. Will consider that.

Thanks. I inherited a script which I decided to put into a stored proc so it can be called from a scheduled job.

At the end of the script, the...

What are your reservations? i need to know before doing this to a production system.

Thanks

The problem I am trying to resolve is that when I run:

==============================

alter table customers add column sname varchar(50)

====================================

in the stored procedure, if I later run a select...

I think the issue here is for me to find a way to run query in batches inside the stored procedure. I can not use the GO batch commmand available...

Thanks all. The BEGIN...END worked.

The challenge now is to run the stored proc from a job and get the output into a csv file.

Don't forget to check the report file produced by the upsizing wizard. It will contain a lot of information on what it failed to do, such as queries that failed...

Hi,

The queries run successfully together in QA but when the stored proc is run, only the first select is executed. The output is sent to a text file.

I will try...

The GetCurrentusername will only get you the name used to login into Windows and not to the SQL Server unless both are the same. The ADP stores connection string to...

Thanks to you all. It is clear that I can not do the update after using the instead of trigger. it is much easier to handle an instead of insert.

An...

I am logging changes to all columns and the text columns make it necessary for me to use instead of trigger. If a user updates jsut one column out of...

I once had a similar problem using MS Access. I solved the problem by reading what the BOL had to say about triggers and identity column. I am sure you...

The procedure calls sp_password.