Viewing 15 posts - 151 through 165 (of 317 total)
Are you using a 32-bit OLEDB provider on a 64-bit server?
If the above is not the problem, have you set the Ad Hoc Distributed to true?
sp_configure
GO
sp_configure...
February 23, 2011 at 12:17 pm
Did you review the article that Marco suggested? It has numerous scripts to run AND mentions even more in BOL
February 23, 2011 at 12:09 pm
There could be numerous reasons. Do you or someone use large INSERT statements?
A great article by Randy Dyess touches on index fragmentation - http://www.sql-server-performance.com/articles/per/index_fragmentation_p1.aspx
February 23, 2011 at 7:13 am
Lowell, I worked for a small software company that used SQL Server on the underside for a ton of small "mom and pop" operations (five to ten users). 90%...
February 22, 2011 at 10:22 am
Do you happen to have an audit trigger in your sysjobs of the msdb database? If not, then there is no way of knowing.
February 21, 2011 at 3:25 pm
You have two options, per CAL (client access license) or per processor. Per processor allows for infinite connections, but be aware of the cost. If you are working...
February 18, 2011 at 1:07 pm
Marco is spot on with the resolution and the specifics of needing a minimum of SP2 for SQL Server 2005. The biggest bug prior to this release was the...
February 17, 2011 at 10:00 am
Without SP2 (at a minimum) you will not be able to use the backup cleanup task in Maintenance Plans.
February 17, 2011 at 9:50 am
What size files were going across without any problem? Have you looked into increasing the FTP buffer window?
February 17, 2011 at 9:38 am
Since you have the transaction log backups scheduled to run on the hour, the forty minutes after the last log file is lost.
If management determines that 59 minutes of lost...
February 15, 2011 at 1:50 pm
Has any thought to look at the Terminal Services Remote Connection Timeout setting? If I am not mistaken it is set by default to 120 minutes.
February 15, 2011 at 1:24 pm
Even though Statistics are updated by the query optimizer, it is not a bad idea after a Index rebuild to run UPDATE STATISTICS
February 14, 2011 at 1:06 pm
I agree with bitbucket, if you can explain why, it may help us determine what you are trying to accomplish.
When you created the column, had you used SSMS you could...
February 11, 2011 at 3:20 pm
Can you supply the exact error message from the Log File Viewer?
February 11, 2011 at 3:12 pm
Unfortunately this is one of the many limitations of Maintenance Plans.
February 9, 2011 at 2:06 pm
Viewing 15 posts - 151 through 165 (of 317 total)