Viewing 15 posts - 196 through 210 (of 227 total)
Compre the DDL of the identified table, between the publication and subscription. The subscription's columns must be able to accept any data from the publication's columns.
If above inspection did...
October 11, 2015 at 6:48 am
The following will fail for databases within which your account is not a db_datareader.
-- https://msdn.microsoft.com/en-us/library/ms174397.aspx
create table #results
(
[server] sysname,
[database] sysname,
type_desc nvarchar(60),
[physical_name] nvarchar(260),
[size_MB] int
)
declare @dbname...
September 22, 2015 at 12:29 pm
@Donnie
Depends upon what you mean by "snapshot". Dm_exec_query_stats shows the metrics accumulated for a cached plan. If a plan was just cached and it is being run for the first...
September 21, 2015 at 8:24 pm
Use regmon in https://technet.microsoft.com/en-us/sysinternals/bb896645, and lock down the box :).
August 6, 2015 at 11:52 pm
This is the wrong forum for that question :). There are many potential answers on MSDN: https://social.msdn.microsoft.com/Search/en-US?query=Cannot%20Promote%20the%20transaction%20to%20a%20distributed%20transaction%20because%20there%20is%20an%20active%20save%20point%20in%20this%20transaction.&emptyWatermark=true&ac=5
August 6, 2015 at 11:40 pm
CHECKDB has been improved since SQL Server 2005. It might uncover errors that 2005's CHECKDB cannot. When CHECKDB reports errors, you should avoid using NO_INFOMSGS. CHECKDB usually reports a repair...
August 6, 2015 at 11:19 pm
If you have run the same DDL on the same hardware and received the same result, do you receive the same message when you run the same DDL upon completely...
August 6, 2015 at 10:04 pm
Just for some color.
Let's imagine a harangued writer in SQL Server's documentation ("user education") team, one who cannot write about the new features until *after* the feature is finalized...
August 4, 2015 at 11:53 am
Running a setup repair is the safest bet - who knows what other files went AWOL.
You could try Method 1 in http://support.microsoft.com/kb/811008, but that is a rather...
October 28, 2014 at 7:10 pm
Start with the first reference that is returned by https://social.msdn.microsoft.com/Search/en-US?query=dtexec%20%22Exception%20has%20been%20thrown%20by%20the%20target%20of%20an%20invocation%22&emptyWatermark=true&ac=4 . Attempt to emulate the security context of SSIS by logging onto Windows as its startup account, and...
October 28, 2014 at 7:52 am
Already fairly obvious from the error, but you can run calc.exe in Programmer mode, and convert decimal 2147746132 to hex. The result will be 80040154. Search msdn for 80040154 and...
October 28, 2014 at 7:34 am
You are asking SQL Server experts how to programmatically solve a math problem. I think you would be better served by asking mathematicians and programmers of procedural languages.
Outside of SQL,...
September 9, 2014 at 12:30 am
You are asking SQL Server experts how to programmatically solve a math problem. I think you would be better served by asking mathematicians and programmers of procedural languages.
Outside of SQL,...
September 9, 2014 at 12:29 am
The error handling has to be done both at the remote server and at the local server. From MSDTC's perspective, the two or more servers (involved in a distributed transaction)...
September 8, 2014 at 12:41 am
Glad to see setup completed. However, you still need to perform a root cause analysis. The dates on your parallel MSDN post go back to 7/3. The date on the...
August 21, 2014 at 8:09 am
Viewing 15 posts - 196 through 210 (of 227 total)