Viewing 15 posts - 691 through 705 (of 1,790 total)
Hopefully he was referring to using SSMS and not Transact SQL.
http://msdn.microsoft.com/en-us/library/ms179401.aspx
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 12, 2009 at 2:47 pm
No problem. I think his situation is a bit different as the current user was going to be executing the bat file which is why I asked the question. Thanks!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 12, 2009 at 12:56 pm
Ok, I was obviously way to distracted in answering that. Very sorry, thinking you were looking at Backups. Not sure why though... :Whistling: :blush:
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 12, 2009 at 12:48 pm
Does this get you what you are looking for?
select @@servername as ServerName
, b.name as DatabaseName
, isnull(str(abs(datediff(HH, getdate(), max(backup_finish_date)))), 999) as HoursSinceLastBackup
, isnull(convert(char(10), max(backup_finish_date), 101), '01/01/1901') as LastBackupDate
from
master.dbo.sysdatabases b...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 12, 2009 at 12:34 pm
JKSQL - Glad you got it working.
Mohit - Can you explain what you mean by that?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 12, 2009 at 12:21 pm
Assuming that the permissions are set for whoever is running the bat file to access the .bak file and to restore the database then I would say that yes, it...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 12, 2009 at 11:53 am
Did you use the a standard merge agent with this configuration? If so, you should be able to configure that at the subscriber to run in continuous mode BUT, I...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 12, 2009 at 11:37 am
Not using the Web Synchronization so, the information that I gave you might not apply. I will try to poke around a bit and let you know what I find....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 12, 2009 at 10:44 am
Yes, you would need to do that and you would need to change the job schedule to "Start Automatically when SQL Server Agent Starts" in the Schedule Type dropdown at...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 12, 2009 at 10:21 am
Where are you looking in Replication Monitor?
When you look at the details of the merge publication (right click > view details) and then select Action > Merge Agent...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 12, 2009 at 9:34 am
Alvin Ramard (3/11/2009)
Roy,Given where you're from and where you are nobody will expect you to understand Arkansian on your first exposure.
🙂
I'm from upstate NY and needed Bob's explanation as well....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 11, 2009 at 11:15 am
Mike,
You appear to have installed this as a named instance. I believe you will have to uninstall / reinstall in order to get the default named instance that you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 11, 2009 at 9:26 am
Jeff Moden (3/10/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 8:57 pm
The table scan itself may not be bad if it is small but these aren't really table scans but rather multiple executions of that function. Hard to say if that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 5:54 pm
Nice link Grant!
Gaganks - Wondering if you would be willing to edit your original post and remove the really long script that is in there and just reference the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 12:44 pm
Viewing 15 posts - 691 through 705 (of 1,790 total)