Viewing 15 posts - 181 through 195 (of 227 total)
The problem is -c, which is /character mode. BCP in /character mode expects to be passed a /format file (or it will interactively prompt you for the output's format, which...
November 7, 2015 at 4:20 pm
MS has two ways. They are documented in https://msdn.microsoft.com/en-us/library/hh270282.aspx as being contained databases or domain accounts. The difficulty is rooted in the different ways a SID can be...
November 7, 2015 at 4:05 pm
I am not up to date on the latest cluster stuff, but I don't think this aspect of Windows clustering has changed since 2008. So, the last I heard the...
November 7, 2015 at 3:34 pm
Right-click "local publications" and choose "Launch Replication Monitor".
Why was "Distributed Transaction Controller" circled?
The "distribution agent" that is mentioned in https://msdn.microsoft.com/en-us/library/ms151832.aspx does not mean DTC. Snapshot replication's "distribution...
November 7, 2015 at 2:50 pm
I kept receiving Username/PW errors from the Linked server dialogue.
What errors were they, and who is the authority for them? This being a SQL Server forum, you might be seeking...
November 7, 2015 at 2:31 pm
Follow https://support.microsoft.com/en-us/kb/307487
Another gotchya from it "A limitation of DBCC SHRINKFILE is that you cannot make the database smaller than the size of the model database."
November 7, 2015 at 1:37 pm
You are facing a referential integrity error, here:
sys.sql_expression_dependencies does not have a matching row [] in sys.objects.
There may be hacks that could 'poison the database ' (i.e make SQL Server's...
November 7, 2015 at 1:15 pm
-- Start of what helps us help you
create table #import (importcity nvarchar(128), title nvarchar(128))
create table #city (city nvarchar(128))
insert #import (importcity, title)
values
('SomthingElse', 'PRN - Concord'),
('SomthingElse', 'PRN - San Jose'),
('SomthingElse', 'SLP -...
November 7, 2015 at 12:10 pm
I recommend you do not use a CMDEXEC job step to issue a NET START, because doing so would require the SQL Server Agent startup account to gain elevated permissions.
...
November 7, 2015 at 10:52 am
A stored procedure is run by a session. You can have multiple sessions running the same stored procedure. Each session has a different spid (which is returned by SELECT @@SPID)....
November 7, 2015 at 10:16 am
Could the deadlock winner be replication or a scheduled job? Could be an intraparallelism deadlock or a session/spid/query window that has lost track of its @@trancount. The newest and least...
November 5, 2015 at 9:58 pm
How did you identify the above batch was the only code being run, without having collected a trace (or extended event)? Is the database single_user?
November 5, 2015 at 6:48 am
Privileges are gained by Windows accounts when the account logs in. A Windows service logs in before users are able to logon to the OS. If you want a service...
October 11, 2015 at 1:29 pm
SAN level replication should be creating a binary copy of the database files and log files. Which means all T-SQL should return the exact same results on the replica as...
October 11, 2015 at 8:05 am
You need to SET XACT_ABORT ON. See https://msdn.microsoft.com/en-us/library/ms191515.aspx
October 11, 2015 at 7:13 am
Viewing 15 posts - 181 through 195 (of 227 total)