Hi,

Use xp_cmdshell to run qwinsta. you will have to format the results.

More details here:

http://www.techtalkz.com/blog/tips-n-tricks/how-to-view-disconnect-remote-desktop-sessions-from-commandline.html

HTH,

Meir

mdowns (4/4/2008)

---

Prior to SQL Server 2005, if an agent failed for some reason, e.g. network loss, that was it. It was stopped. Therefore, I have had to develop a complete...

Great article, thanks!

Great article, thanks!

One comment, though, which can be useful:

You mentioned the problem when you want to manually init the subscriber. So you have to stop all users, init and then...

Hi,

Great article!

A few comments:

1. Regarding the custom stored procedures, you can eliminate the need of them by changing the article properties, and selecting not to use sp's instead of insert/update/delete...

If you want to create an "installation" CD for your users, you can try to use a ".bat" file which installs the MSDE and then run .sql scripts useing OSQL.

for...

This checkindex statment is a bit vage for me too, but i think that in SQL Server 6.5, when you execute DBCC CHECKINDEX, you can see in the profiler a...