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...

Fill a QOD slot?

Not sure myself, but probably better programmers that I have some use for it. Or maybe it's just the math PhD in Redmond wanted to get the...

I'd have thought AWE would be needed for this. Did you set AWE on in SQL Server?

Did you change the account usinig Enterprise Manager/Config manager? If not, you could be missing permissions.

Thanks for the update