- Talk to the application support contact person.

- DRI may indeed actually NOT be desired at all.

- Keep in mind, this will need the data feed process to be revised...

experience .... ehum gut feeling :w00t:

Invalid "non printable" characters in your script .....

Copy / paste it into e.g. Word and replace the found non-printable characters by a space.

e.g. SQL2000 EM allowed char(13) to be used...

Did you have a look at http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2e047054-d816-4798-98aa-82eb9678dde4/

Gail published a very nice article on managing transaction logs ...

http://www.sqlservercentral.com/articles/64582/

In general we use the same methode as Brad described in his reply.

Can you provide version info regarding the sqlserver you are trying to connect to ?

- Sql2005 / 2008 ?

- Editon ?

- build no ?

- Can you ping the servername (without...

you need to stop/start the instance to activate TCP\IP.

So first enable the setting in config manager, then stop and start the sqlinstance.

Did you try putting it in a udf ?

Been there ..... done that ...:hehe:

Learn to play .... play to learn:w00t:

If they doubt it the db is still in use ??? So far for performance 😉

- You execute the @SQL1. This runs by its own batch and doesn't know your variable.

- IMO you should just change your Set @SQL1 so it uses

......

And there are off course "cumulative hotfixes" = a set of hotfixes, but not as tested a you would expect for a service pack

If this is to figure out if a db is still being used, just alter your db option "AUTO_CLOSE" to ON.

This way, you will find a "database opened" message in...

- Read the according KB ref for the hotfix !!

- Test it on a DBA test server to prepare yourself for the production rollout (timing, expected problems,..)

- Is this a...

Your Set SQL1 is using @fiscal_month_nm in the sting itself !

That's causing the "must declare varriable" error