Viewing 15 posts - 5,416 through 5,430 (of 6,678 total)
The server you are running is 2000 - you can modify the agent jobs as needed. You should look at upgrading to SQL Server 2008, but that really depends...
April 13, 2009 at 11:59 am
Can you run SELECT @@VERSION to verify?
Or, look to the right of the server name and verify the server you are connected to has a version of 9.0.xxxx or greater...
April 13, 2009 at 11:49 am
Yes, your assumption is correct - the transaction log file will not shrink just because you back it up. To make the file smaller, you have to explicitly shrink...
April 13, 2009 at 11:44 am
Maintenance plans are only available on SQL Server 2005 and greater. Looks like you are connecting to a SQL Server 2000 system.
Try opening the Legacy folder and see if...
April 13, 2009 at 11:12 am
The error that you received is one of the known issues with using the NOLOCK hint on a query. The only real fix is to rewrite the query without...
April 13, 2009 at 10:48 am
What is the return code being returned from your perl script? If it is not a 0 for success, which is what SQL Server Agent expects, it is going...
April 13, 2009 at 10:40 am
trans54 (4/12/2009)
How i can convert the following string to the datetime type?
'20081228012320'
I am able to convert but only when i get date in...
April 12, 2009 at 6:23 pm
Paul White (4/12/2009)
It's also possible to read all possible data into XML and run an XQuery... :-D/P
Paul - I'd quit now while I still had the chance 😀
April 12, 2009 at 9:42 am
Be careful with the synonym approach - it can only work if all queries using the procedure will use the current month table. If some look to different months,...
April 12, 2009 at 8:19 am
I would take the discussion out of the religious war on the evils of using NULL and place it firmly in the area of data integrity.
It is not so much...
April 11, 2009 at 12:35 pm
Jack Corbett (4/10/2009)This is one of my favorite things. That and the accountants not locking their PC's when they go to meetings or lunch.
This is only a problem when...
April 10, 2009 at 9:40 pm
Boolean_z (4/10/2009)
same here...Its not going to hurt the server performance either.
Unless someone decides to run a query on the server and return millions of very large rows. I...
April 10, 2009 at 12:58 pm
There doesn't appear to be any issue to be fixed. As has been noted in several articles and forum posts, Task Manager on 32-bit systems does not accurately report...
April 10, 2009 at 12:56 pm
I have to agree with Gail on this one - this should be done in the report, and could be done easily at that.
April 10, 2009 at 12:40 pm
Viewing 15 posts - 5,416 through 5,430 (of 6,678 total)