Keep in mind that this uses 1434 to find them and lots of routers are configured to block this after Slammer (it used this as well).

Finding instances can be hard....

Under the Logins tab, under security, you may have Windows groups listed. I.e., BUILTIN/Adminstrators is added by default as a login and given SysAdmin access. This means you don't need...

Thanks and I'll pass along.

New format coming Monday (1/1/07), so I'd love to hear comments.

Steve

Sorry and apologies for the issue. Not sure what's wrong, especially since the login and forums are all .NET code. We have had some session issues reading articles since that's...

Is this SQL Server 2000, Standard or Enterprise?

Please let us know which version and then what the issue is. If this is a performance issue, has it always been this...

Please clarify and include the type of application you're dealing with. .NET and OLEDB/ODBC apps would connect differently.

If you want to force people to move to procedures, you need to...

You can use the ROUND function to change things in a query or even convert to a char and then use SUBSTRING, but ninja is right. Do this in the...

You can do the alter through EM, then hit the script button and get the script. Then don't save your changes and you'll have the script.

Knowing what is inaccurate and what is accurate is critical. IF you look at the results, can you tell which section of the code is not working?

Follow ninja's advice above.

I stand corrected. Finish time looks to be the correct time.

First, I'll say that I've always been a good employee (from the employer's point of view) and usually they want me to stay, so I'm fairly up front when I...

Marc,

My understanding is the backup is valid when you start it. The reason is that as pages are grabbed through the backup process, they are marked as a part of...

Can't speak for SQL Server, but when we had backups on DB/2 and Oracle, they did do a copy/split of the disks on the SAN and there was a brief...

Very interesting and thanks for sharing.

And I'll see about writing the letter. Easier for me to say it than do it, though I've composed a few in my head. If...

Jeff,

Thanks, and I didn't check that page. You can send a note to MS from that page, which lets them know of an inaccuracy. Since I've written lots of junk...