Viewing 15 posts - 1 through 15 (of 182 total)
Can you correlate the errors to any events on your firewalls, DNS, or WINS?
December 14, 2010 at 6:58 pm
I trust the host being used is the cluster name not a node, correct?
December 14, 2010 at 8:15 am
Yes, when the defualt port is being used SQL Browser is not used as it looks directly for port 1433.
December 14, 2010 at 8:14 am
Also when the issue occurs capture the netstat output to see what is using port 1434.
December 14, 2010 at 6:04 am
Is the data server on a cluster?
What version of sql server are you running?
Try to use <host>, <port> in the client connection to remove the sql browsing service as a...
December 14, 2010 at 6:00 am
You could try to set the sql server to do the following:
exec sp_configure 'scan for startup procs', '1';
exec sp_procoption '<procedure>, 'startup', 'on'
Have the startup proceduer execute xp_cmdshell with the program...
December 13, 2010 at 5:57 pm
Is the SQL Server on a cluster?
Is the client conection to the server using a port or \\<host>\<dataserver>?
December 13, 2010 at 5:41 pm
Is your environment 32 or 64 bit?
December 11, 2010 at 7:16 pm
You may also want to add a config file for the packages that can be updated appropriatley for each environment.
December 11, 2010 at 7:13 pm
Add a counter that increments every time the function is called and then display the value to check if it is indeed being called more than once.
December 2, 2010 at 8:45 pm
The input string is probably null.
December 2, 2010 at 8:19 pm
Please provide the output from the entry in sysservers and the tnsnames.ora entry.
June 29, 2007 at 6:34 am
while @i <= LEN(@String1) begin
This is executed every pass so set the length once and evaluate the length variable for performance.
Set @len = Len(@string1)
While @i <= @len etc....
Small things add...
June 28, 2007 at 7:13 pm
I connect from sql server 2000 to 10G daily and is supported. Please provide the error and sql that produces the error. Are you using linked or remote servers?
June 28, 2007 at 7:06 pm
Post proc as something may be in the proc that forces a recompile and subsequently introduces the elevated CPU util.
June 28, 2007 at 6:51 pm