Viewing 15 posts - 5,206 through 5,220 (of 6,676 total)
Shawn Therrien (5/11/2009)
I do apologize. I didn't realize that VPN software didn't work with a 64bit OS and was stranded away from my work materials.
Not sure what VPN software you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 11, 2009 at 2:17 pm
The property you are trying to get to does not exist. Use $srv.VersionMajor instead of $srv.Information.MajorVersion.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 11, 2009 at 2:10 pm
If you need to do something like this with any frequency - I would suggest that you invest in the great tools from our sponsors. SQL Compare and SQL...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 10, 2009 at 2:42 pm
Right - so, to get around the issue with the view designer - open a new query window and write the create statement yourself. You won't get the error...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 8, 2009 at 8:04 pm
Did you try creating the view by issuing the CREATE VIEW statement? Or are you using the view designer?
Also, you should know that the TOP (100) PERCENT and ORDER...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 8, 2009 at 5:23 pm
If you really cannot use dynamic SQL - the other options are to force the stored procedure to recompile each time it is called, or you can force the statement...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 8, 2009 at 5:18 pm
Steve Park (5/7/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 7, 2009 at 2:29 pm
Setting the retention period for the backup does not remove old backups. To actually remove old backup files you need to add the maintenance cleanup task and configure it...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 7, 2009 at 2:18 pm
When those databases were removed, was the maintenance plan modified to remove the old databases?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 7, 2009 at 2:13 pm
AFAIK - that option was made available in SQL Server 2005 when using the ALTER INDEX syntax. It is not available, even in 2005 using DBREINDEX.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 7, 2009 at 2:08 pm
How are you being notified that the recovery model has changed? Do your backups start failing 'all of a sudden'?
If the following command is executed, then you will not...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 7, 2009 at 1:42 pm
The min setting here is less important than the max setting. Without setting the max memory - both instances are trying to use memory that the other instance is...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 7, 2009 at 1:36 pm
As others have stated - no it is not possible. The real question is what problem are you trying to resolve? What data exists in tempdb that you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 7, 2009 at 1:31 pm
"Logic bug"? Heh... what's that?
I'm with Gus... if you do it right, it won't matter one way or the other. Using one or the other to make up for,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 7, 2009 at 9:20 am
No - the 32bit version of SQL has the same limitations that it would have on a 32bit OS. There is no reason to install the 32bit version on...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 6, 2009 at 11:31 am
Viewing 15 posts - 5,206 through 5,220 (of 6,676 total)