Scott Beckstead (10/20/2005)

---

synchronous, asynchronous...

I was expecting something related to time. An asynchronous process is one that is not timed to a particular event. A synchronous process is locked to...

Interesting.

So the difference between synchronous and asynchronous is not that the one oeperates synchronously (it returns a row for each input row, and returns it before it gets the next...

Why on earth assume that SQL logins exist on that server. It contains my accounting database, for goodness sake!

It is good practise to use a strong password for distributor_admin...

Good question. Not a good explanation, I needed to read all the comments before I understood where I was going wrong.

I think I agree with the suggestion that this...

Although the script task has to be in VB, if you want to write in a different language you can develop a custom package in any .net language and just...

I think this question and answer are conflating db_owner and permissions on the dbo schema. They are not the same thing in SQL 2008 onwards, and I don't think...

I suppose it depends on how one interprets "upgrade". An SQL Server 2000 Enterprise edition could not be upgraded in situ to SQL Server 2005 Standard Edition. That's...

It would have been better to reference the BoL page (http://msdn.microsoft.com/en-us/library/ms191152%28v=sql.90%29.aspx (or rather, given the date, it would have been that url but without "(v=sql.90)") than the reference provided, which...

I got this right, but I think the question and explanation are bad, they contain a false assumption. At least it's a false assumption for 2008 and I don't...

I too agree with Yelena, in the circumstances I would want to see not only who is logged in riqght now using sql...

I don't know what the original wording was, because it was corrected nearly 7 years before I saw it. With the current wording, it is quite a difficult task...

Jan Van der Eecken (8/11/2012)

---

Yes, that's the link. Thanks Tom. I still don't see the issue. Maybe I'm just not privy enough as to what's going on in terms of...

I didn't like the misleading topic, but otherwise thought it was a very good question. Of course a topic like "scope and dynamic sql" would have made it too...

Nice easy question to start the week with (2 days early).

I wonder if the 100% correct rate will continue when everyone sees it and starts answering on Monday. 😀

This is a nice straightforward question, especially now that the typo has been corrected. The stackover reference is not a very good one though, since as Ron points out...