Viewing 15 posts - 7,936 through 7,950 (of 9,715 total)
Are you sure they're hitting the correct instance? Because if there's both a named and a default on that server, they're no longer hitting the proper instance.
They may also need...
May 21, 2010 at 11:04 am
chaudharyabhijit (5/20/2010)
May 21, 2010 at 5:51 am
Greg Roberts-134214 (5/17/2010)
May 19, 2010 at 4:27 am
Log onto the server. Right-Click My Computer and go to Manage. Many file locks can be found under Shared Folders -> Shares or Shared FOlders -> Open Files. Sometimes, though,...
May 18, 2010 at 10:20 am
Unable to delete is different from unable to find.
Check the file locks.
May 18, 2010 at 4:28 am
It checks to see if Anna_User has a schema first. That is still a step that can be avoided if you use schema.object qualifications.
You may not notice the performance hit...
May 18, 2010 at 4:21 am
Jeff Moden (5/12/2010)
Joe Celko (5/12/2010)
I just wish that Microsoft has used the ISO/ANSI Standard CURRENT_TIMESTAMP and CURRENT_DATE instead of more dialect.
I haven't checked the other versions of SQL Server but...
May 18, 2010 at 4:15 am
Sorry, I was out of the office and didn't get to respond until now.
What version of client tools is the workstation using? And did you say that you logged directly...
May 18, 2010 at 4:10 am
This article doesn't actually say the server *will* recompile the proc. It says it might.
Best Practice
It is best to owner qualify stored procedure names when you execute a procedure. This...
May 12, 2010 at 12:40 pm
So far as I know, procs do NOT get recompiled just because you leave off the schema name in the EXEC statement, not even in 2000. I'd like to see...
May 12, 2010 at 11:39 am
I know of no way to only allow one connection via a login. Through the server properties, yes, but not on the login level.
However, you could give this person access...
May 12, 2010 at 11:31 am
Whisper9999 (5/12/2010)
May 12, 2010 at 11:28 am
Server-side profiler trace is your best option to get all the data you want and not miss any logins.
Make sure to include the TextData field to get the procs and...
May 12, 2010 at 11:21 am
You are not off base. I/O is basically reads & writes to the hard drive. If your disk controller went whooey recently or if there's another problem bottlenecking your I/O,...
May 12, 2010 at 11:17 am
If I'm not mistaken, Data Mirroring uses the Service Broker to transmit data over to the mirror. So everything is queued up as messages that are read into the mirror....
May 12, 2010 at 11:14 am
Viewing 15 posts - 7,936 through 7,950 (of 9,715 total)