Viewing 15 posts - 691 through 705 (of 1,790 total)
Hopefully he was referring to using SSMS and not Transact SQL.
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!
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:
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...
March 12, 2009 at 12:34 pm
JKSQL - Glad you got it working.
Mohit - Can you explain what you mean by that?
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...
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...
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....
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...
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...
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....
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...
March 11, 2009 at 9:26 am
Jeff Moden (3/10/2009)
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...
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...
March 10, 2009 at 12:44 pm
Viewing 15 posts - 691 through 705 (of 1,790 total)