Viewing 15 posts - 1,246 through 1,260 (of 2,356 total)
That...
January 21, 2019 at 11:52 am
Yes it was and a bit funny. I've had a few over the years where...
January 21, 2019 at 9:35 am
January 21, 2019 at 9:28 am
It was initially about a...
January 21, 2019 at 9:19 am
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...
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...
January 18, 2019 at 7:13 am
January 18, 2019 at 7:10 am
January 17, 2019 at 1:20 pm
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...
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...
January 16, 2019 at 5:18 pm
January 16, 2019 at 2:37 pm
1) shutdown sql service
2) copy mdf/ldf files somewhere so that you can come back...
January 16, 2019 at 2:34 pm
January 15, 2019 at 2:44 pm
Viewing 15 posts - 1,246 through 1,260 (of 2,356 total)