No it is not always possible to avoid a cursor and sometimes that solution does work best. As for looping you also have the WHILE loop option. The best thing...

hlx you are correct, except there are ways with SQL7 and 2000 to shirnk the log below original size and the db. 6.5- are not able to be done.

"Don't roll...

When using DTS to import or with a Excel file the DTS wizard only scans the first x number of records (sorry I forget that number but is somewhere on...

Actually the local @@ERROR should be set. Did you try it?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Steven is righ, to my knowledge CR does not support app roles and no plans to change that. We use sql accounts to provide access to the data, which you...

CHAR defines the field as fixed length. If you do not fill the columns full length spaces are generated automatically. When retriving the data you may need to perform a...

If you are trying to execute all this in the connection you cannot as only one execution can be defined. However consider using a stored procedure as you execution statement....

With SQL 2000 this is the syntax

ALTER DATABASE <dbname> MODIFY FILE (NAME = <oldlogicalfilename>, NEWNAME = <newname>)

with SQL 7 I don't recall there being a way.

"Don't roll your eyes at...

Usually if you know the data is going to be moved thru then use ADO with a server side cursor and setup into pages using the proper syntax (a bit...

To the best of my knowledge you cannot script these.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Just a note, if you want an easy reference to any command line that outputs info in a cmd window do like:

osql /? > c:\osql_help.txt

This way you have a document...

For the transaction log I would consider 20mb on a 100MB database as bare min. Now depending on how often you perform full backups I would measure 3 times the...

quote:

---

Antares, I have sometimes seen recommendations to use TOP instead of SET ROWCOUNT because the optimizer doesn't work very well with SET...

When you call the Parameters collection without calling refersh first ADO automatically does it then, or when you explicitly call Refresh. It never occurrs on Execute.

"Don't roll your eyes at...

Could be Memory issues with the number of transactions taking place. It could be hard drive contention (rarer these days but depending on cofiguration it still does happen). Could be...