Viewing 15 posts - 151 through 165 (of 318 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...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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%...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
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...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 11, 2011 at 3:20 pm
Can you supply the exact error message from the Log File Viewer?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 11, 2011 at 3:12 pm
Unfortunately this is one of the many limitations of Maintenance Plans.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 9, 2011 at 2:06 pm
Viewing 15 posts - 151 through 165 (of 318 total)