This is a good reason to have an NTP server. Using tools from the resource kit, NT4 servers can access NTP servers. All others can get their time...

A question that should be asked is were there any issues with the amount of memory SQL Server was using or was there simply a concern?

One thing to...

We do this very task, and we've got some files that come across the mainframe that are quite large. What we poll for isn't the large file but a...

Take a look at the following:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_7eb8.asp

Basically, the counter value has to be set manually. Perfmon will report the value set until it's changed, so if you do the following:

We have a fairly large server farm and we'd considered using it, but there isn't a lot of material out on it and there were other more pressing issues. ...

I think there is also the case where a person would post a topic but never checks back. Perhaps the person finds an answer elsewhere or it simply becomes...

Hi Lou,

I have not. I am in the process of trying to research it. A friend of mine is also having issues (chad) and we're trying to nail...

Compaq has sizers for their servers. If you're not using Compaq, you'll get comparable answers.

http://activeanswers.compaq.com

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

It is an internal stored procedure. It's what the Transact-SQL Debugger uses in SQL 2K to allow for debugging.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

In Books Online, under CREATE TABLE or ALTER TABLE. Here are some links:

CREATE TABLE:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_8g9x.asp

ALTER TABLE:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_3ied.asp

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

The readme files for the latest service packs contain this information.

SQL Server 2000:

http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Fservicepacks%2Fsql%2F2000%2Fsp2readme%2Easp

SQL Server 7:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q274798

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Haven't tried it, and I'm sure Microsoft would have fits about the whole thing.

One thing to consider with the trigger, though, is that it will fire per the operation specified,...

Yes, that's the article I was speaking about by you, Steve. And I still will agree to disagree with Neil on his. It goes back to that inherent trust...

I did a quick netmon trace and here's what I saw...

After specifying the IP address in Query Analyzer (2K), the first thing that the client did was make a call...

I've done a file of this size once using ActiveX scripting, ADO, and the File Scripting Object. However, it's basically like writing a mini VB program in DTS.

K. Brian...