Running .NET IDE is quite memory intensive. We are running it on our 'old' 256MB laptops and it runs fine, but not really fast.

If you have the chance to upgrade...

sp_help <table name>

Returns more information like indexes, foreign keys, ... in a nice format in QA.

Declare your cursor as follows

USE PUBS

DECLARE @lName varchar(40)



DECLARE crsMyCursor CURSOR FOR

   SELECT au_lname FROM AUTHORS



OPEN crsMyCursor



FETCH NEXT FROM crsMyCursor INTO @lName



UPDATE Authors SET au_lname...

Did you check permissions of the user running the Maintenance Plan job? This is by default the user that created the maintenance plan, and maybe that user does not have...

There is no easy way to do this in a single operation. What possibilities exist?

1. Use a trigger on the table. If you have cascaded triggers, you are sure to...

Agree with Andy. It is better to rely on a hardcoded parameterNAME than on an ordinal.

After all, you would not write an order by clause using ordinals, would you?

After...

There is an MDX expression 'Level' as in <Member>.Level.

This gives you the level of the member of the Dimension.

My point wasn't as much which query the app passes in, but the method it uses to pass it in. Does it call a stored procedure using the ADOCommand object...

Can you post a sample of what the App sends to the database? That might clear things up for us...

Can you give the format of the file? Maybe upload a small sample, and I will try to do some testing...

Oops. Apparently there is no easy way to read a binary file using VBScripting. Maybe using JScript it gets easier?

An alternative solution could be to write your own object to...

Can you please explain more clearly what you want to achieve?

Do you want to have a syntax checking done before inserting the SQL String?

Give some examples. My solution I posted...

Obviously, that example won't work. What I was describing is a way to do this using any front end.

To escape a single quote, you should put two single quotes.

Your example...

Should be possible.

You should be able to create the logic for reading the binary file from an ActiveX task.

Insert the record ids (primary keys) inside a staging table and 'synchronise'...

It is quite logical that it does not work. How should SQLServer know which row you want to display for each unique hometel?

You could try the following...