a log file can only shrink up to the last virtual log file it has in use.

This script will write dummy data to the log file, until it's first VLF...

Can you check it restrictions apply to the number of user connections ?

/* "user connections" is an advanced config setting

enable show advanced options */

exec sp_configure 'show advanced...

Feedback:

I've upgraded the dev servers to SP3 and got the approval to re-test it in cooperation with one of our biztalk devs.

After I activated the "old" logon trigger again, the...

Did you read:

-SQL2005 http://msdn.microsoft.com/en-us/library/ms188706(SQL.90).aspx

-SQL2008 http://msdn.microsoft.com/en-us/library/ms188706.aspx

-WP: http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

- http://www.sqlservercentral.com/articles/SQL+Server+2005/61765/

- http://www.sqlservercentral.com/articles/Development/3144/

- http://msdn.microsoft.com/en-us/library/ms345146.aspx

- http://www.sqlservercentral.com/Forums/Topic414210-338-1.aspx

- http://www.sqlservercentral.com/Forums/Topic623669-360-1.aspx

also keep in mind, if partitioning an existing table, you may still end up with DOWN TIME for your application(s)...

As always, play it safe and start with a full backup scenario of ALL your databases (including systems databases !)

If all backups completed successfully, only then start the sp3 exe.

Read...

did you log grow over night to 17 Gb ?

or is it due to the fact you do not make log-backups ?

In full recovery mode, you need to make log-backups...

you should be able to update directly to SP3.

There is a CU1 for sp3, but you'll have to check it the items fixed would match your usage environment.

Indeed, a word of caution should be said.

Undocumented surely means the behaviour may change with every hotfix/cumulative update/service pack/new version.

They may even be removed without any notification or alternative !

Thank you for the confirmation 🙂

There are some more special characters you need to double up when using them in T-sql or in a dynamic sql string.

If you use variables from you calling application (vb.net,..)...

Books online has good info.

"create event notivication" and further...

Be sure to use the most recent one (dec.2008)

- figure out how many times the application calls the sproc in a single application run. (or how many times it executes the cmd-object)

it must be a loop of some...

Best is to run your code on a box where you have a sql2005 client installed.

If you need to run the code locally on a box, best is you...

Nicholas Cain (1/10/2009)

---

If you had mentioned that this was only an issue through the app and not when run manually, which was what everybody thought, this could have been resolved...

SQL Noob (1/9/2009)

---

we put it in QA on a server with SP2 and no CU's. In a week or so we are putting it on a QA server with SP2...