Viewing 15 posts - 5,431 through 5,445 (of 6,105 total)
Previously, AFTER triggers couldn't touch text, ntext, and image columns for inserted or deleted. That behavior hasn't changed.
Since the INSTEAD OF trigger interrupts a normal operation, I...
May 24, 2002 at 8:48 am
dtproperties is a problem child because of how EM treats it. Typically, I select it out.
use newdb
select o.name as "Table Name",i.rowcnt as "Row Count"
from sysobjects...
May 24, 2002 at 8:45 am
sp_recompile toggles a stored procedure or trigger to be recompiled the next time it is run, but it won't actually do the recompile. Since the indexes are rebuilt, that...
May 23, 2002 at 7:49 am
This reminds me of my Citadel days when one of the legal responses was, "Sir, no excuse, sir." There have been thousands of infections according to various sources, which...
May 23, 2002 at 7:38 am
The service shouldn't need to interact with the desktop. Question: are the binaries for SQL Server stored on a drive local to the computer?
K. Brian Kelley
May 8, 2002 at 8:42 am
Please don't cross post. Most of us surfing the forums read all the topics. Check my reply at:
K. Brian Kelley
May 6, 2002 at 10:34 pm
Can you map a drive to the colocation server by using the net use command (from the Command Prompt)? For instance:
net use j: \\<ip address>\Share
K....
May 6, 2002 at 10:32 pm
I'm sure you've already done this, but just in case, check the Excel spreadsheet is in the same path on the server as you have it configured on your local...
May 6, 2002 at 10:28 pm
If the files are on the local machine, the local administrator account should work without issue. Check the security permissions on the directory and the files, because it's entirely...
May 6, 2002 at 10:25 pm
Typically we see this error when a double hop has occurred in an NT 4 domain but usually with respect to distributed queries, but I would think this should occur...
May 6, 2002 at 10:22 pm
There is a knowledge base article for SQL Server 2000 about dtsrun.exe hanging.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q290077
dtsrun.exe may be hanging in your case as well but may not be for the reasons outlined in...
May 6, 2002 at 10:10 pm
Enterprise Edition has some performance enhancements for read-aheads and queries doing table scans on the same table concurrently, but with the load you've stated I don't know if it'll do...
May 6, 2002 at 9:59 pm
Enterprise Manager uses mmc.exe (Microsoft Management Console) which is at C:\WinNT\System32 for a default install. You'll find Enterprise Manager's .msc at C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.msc in...
May 6, 2002 at 9:54 pm
Try taking a look at the following Microsoft Knowledge Base article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q268343
It suggests monitoring private bytes for the given process. You'll want to capture Process:Private Bytes for the sqlservr instance....
May 6, 2002 at 9:48 pm
Viewing 15 posts - 5,431 through 5,445 (of 6,105 total)