If I remember correctly they should eventually time out when the sessions expire. If they are not then are you creating the at the application scope of IIS or the...

This tool is free and very usefull and fairly simple to read the output.

Microsoft Network Security Hotfix Checker (Hfnetchk.exe) Tool Is Available

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303215

"Don't roll your eyes at me. I will tape...

To save yourself a lot of trouble there is a built in Procedure that can run a single piece of code against all databases.

sp_MSForEachDB SQLTASKHEREWITH?FORDBPOSITION

So something like this should work...

Ok I understand now.

It may be an ASCII character like CHAR(10) or CHAR(13) which can can do a replace on REPLACE(COLNAME,CHAR(10),'') and should care for but the trick is finding...

Yes all datetime datatypes store the time. If you don't want the time to interfere with specific queries you can also do CONVERT(CHAR,COLNAME,101) in your query or on the INSERT...

Not sure what the best way is but when you say special character are you talking about the space. If so then RTRIM will remove spaces on the end. Now...

I don't see where you are setting your output variable? Have you tested it in QA to make sure you are getting the return you expect? Can you explain what...

Technically you should be fine with 2 CPU licenses as long as server is specifically configured to use only 2. However MS loves to argue the point on this so...

Sorry, forgot what month we are in, busy this morning. The beta has not officially started, it should be sometime this week but they have already provided some prilimary testing...

Now you will yes be growing the amount of data on the tape but as I stated you do overwirte for the first databse backup then append for 2 and...

The problem is it comes from multiple output recordset not a singe. You may be able to write a DTS package with Active Script to do what you want using...

Usually I do something similar to what you have and be basic about it at the header of the SP. Then on each section and sometimes lines I make more...

Note sure of anything in QA but ISQL and OSQL support output files and can be > to txt. These are of course command line products included with SQL Server.

"Don't...

Thanks for the unpdate an info on what happens during intial snapshot. Does it follow what I stated with beyond that point.

Brendon. MSDE I am pretty sure does support SQLXML...

Also, if you want to make part of the table it is better not to create seperate fields if just for output. You can make expression based columns on the...