Viewing 15 posts - 166 through 180 (of 190 total)
Refreshed after done??
Or, since you can check from EM, why not remove from EM directly?
June 12, 2008 at 9:25 am
In msdb, there is a view "sysjobs_view". You can modify it to let others check the jobs. (Or, you can create one.)
June 12, 2008 at 9:22 am
How about move data into DB1 first, then get'em on DB3?
June 12, 2008 at 9:12 am
Jo Pattyn (6/11/2008)
Is the update being done with .Update (can be slow) or with an update-sql statement?
Does it matter?
During recovery (or reboot), I don't think SQL will let you...
June 11, 2008 at 11:51 am
Shark Energy (6/10/2008)
And then as best practise when that dev creates their object they should specify dbo so that their user doesn't become the object owner?
Yes, you got it.
June 11, 2008 at 11:41 am
We already have a thread. Please check here: www.sqlservercentral.com/Forums/FindPost514019.aspx
June 11, 2008 at 11:29 am
Ankit Mathur (6/10/2008)
FROM OPENDATASOURCE(
'SQLOLEDB','Data Source=1.1.1.2;User ID=vUser;Password=getdata;'
)[1.1.1.3].RadiusDB.dbo.Sessions WHERE IDentifier='ankit' GROUP BY IDentifier
First of all, your syntax is wrong.
Please check Books Online.
June 11, 2008 at 11:03 am
John Rowan (6/11/2008)
June 11, 2008 at 10:54 am
It seems your COMPANY table schema as:
CompanyID CompanyName
1 abc
2 ...
June 11, 2008 at 10:33 am
The "logical read 7071" is the initial read for your query. And, when you ran your query again without DROPCLEANBUFFERS, those data pages are in your cache already, and no...
June 11, 2008 at 10:27 am
Seems not many peoples know Chinese here:)
Maybe you need faster harddrive? or CPU?
June 11, 2008 at 10:14 am
Can you stop the MSSQLSERVER from Service?
June 11, 2008 at 10:03 am
GilaMonster (6/9/2008)
The spid is listed in the nonyielding message
Process 77:0 (720) UMS Context 0x0A2477A0 appears to...
June 11, 2008 at 9:41 am
Steve Jones - Editor (6/10/2008)
You could script out the jobs from both instances and compare the scripts.
I second that. This is the EZist way to rule out the cause (assuming...
June 10, 2008 at 2:41 pm
I developed a sproc to check all the jobs' status on a box. And, grant exec to developers.:P
June 10, 2008 at 1:55 pm
Viewing 15 posts - 166 through 180 (of 190 total)