Viewing 15 posts - 1,246 through 1,260 (of 2,356 total)
That...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 21, 2019 at 11:52 am
Yes it was and a bit funny. I've had a few over the years where...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 21, 2019 at 9:35 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 21, 2019 at 9:28 am
It was initially about a...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 21, 2019 at 9:19 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 18, 2019 at 9:02 am
Can you identify the rows that are different? I'm assuming that you are querying the same database that the report is running against.
Does the report have any grouping in...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 18, 2019 at 7:17 am
This should work.
DECLARE @command varchar(1000)
SELECT @command = '
SELECT db_name() as DBName, t.name as TableName, c.name as ColumnName
from sys.tables t
Join ?.sys.columns...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 18, 2019 at 7:13 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 18, 2019 at 7:10 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 17, 2019 at 1:20 pm
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 17, 2019 at 12:56 pm
I think your best bet is log shipping.
Set up the new 2016 AG, and set up log shipping from the 2014 to 2016 box.
When you need to...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 17, 2019 at 9:52 am
Run this to try to find the connected spid.
SELECT db_name(dbid), *
FROM sys.sysprocesses
WHERE db_name(dbid) = 'Your database Name'
You can attempt to issue...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 16, 2019 at 5:18 pm
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 16, 2019 at 2:37 pm
1) shutdown sql service
2) copy mdf/ldf files somewhere so that you can come back...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 16, 2019 at 2:34 pm
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 15, 2019 at 2:44 pm
Viewing 15 posts - 1,246 through 1,260 (of 2,356 total)