Viewing 15 posts - 7,936 through 7,950 (of 9,720 total)
Is this a one time thing or something you'll be doing more than once?
If more than once, I suggest using SSIS to create a package that you can kick off...
June 1, 2010 at 8:45 am
It sounds to me that you're going about this the wrong way. You're focused on a single solution to the problem (i.e., that it was indexes) without actually checking the...
June 1, 2010 at 8:43 am
Sorry it took so long for me to reply. Been busy at work.
On that screen shot you took, you forgot to check a box right above the path information you're...
June 1, 2010 at 8:37 am
Sorry, my company blocks that site. Can you attach the image to your next post?
May 25, 2010 at 4:21 am
pobeda (5/22/2010)
Updated sql server to SP 3, did not help. So, Management studio on my PC older then on the server right now.
This is why we asked about versions. Workstation...
May 24, 2010 at 4:17 am
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
Viewing 15 posts - 7,936 through 7,950 (of 9,720 total)