Tagged Questions
1
vote
1answer
46 views
Get the list of all Tables, Views, Stored procedures that are not added in a publication for replication
How do i get the list of all Tables, Views, Stored procedures that are NOT added in a publication for replication?Can you help me to make the stored Proc for that?I am new to Replication....Thanks
0
votes
0answers
28 views
How can i configure sql server 2012 to use multiple nic? [duplicate]
I've a server with 4 nics.
I want to use 2 nics to query db and 2 nics to retrieve results from db
I want they work in load balancing and still continue to work if one nick is down.
It is possible?
...
0
votes
1answer
141 views
FETCH API_CURSOR causing open transaction in tempDB
A select statement run from Oracle 11gR1 to SQL Server 2005 using Gateway leaves an open transaction in tempdb. The user is a datareader in Database XYZ. Not sure why the open tran is in tempDB when ...
1
vote
1answer
51 views
Unique Non Clustered Column in Partitioned table
We have partitioned one of our SQL Server tables on a Clustered Index datetime column, we have a Primary key Non-clustered index column with Identity data type and this column is setup as a ...
5
votes
1answer
348 views
SQL Server 2008 R2 DMV Question
I have a query to retrieve the Top 10 queries based on total logical reads from the dm_exec_query_stats DMV.
SELECT TOP 10
SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
((CASE ...
-3
votes
1answer
54 views
What is Better SQL Server Configuration? [closed]
First think : MDF and LDF separate on raid 1
Second think : All in one raid5.
1
vote
1answer
56 views
System test Database user management
We are in development stage and to be able to give the developers an integration test environment, we need to give them access to the database, they can share and test their code in the system ...
0
votes
2answers
2k views
How to print out the query SQL text of a transaction by querying the “fn_dblog” or DBCC LOG('DataBaseName')?
At some point in the last 24 hours some changes were made to a customer SQL server 2008 (v 9.0 SP4) by one of a couple if possible applications that use the DB.
Its not particular critical, but it ...
0
votes
0answers
289 views
Update Statistics Maintenance Plan - Ambiguous column name error
Microsoft SQL Server 2008 R2 Web Edition (RTM) - 10.50.1600.1 (Intel X86)
Windows 2003 R2 SP2
I am in the process of setting up a maintenance plan to update statistics on a daily basis for all user ...
1
vote
2answers
253 views
Oracle Linked Server query error
We have a problem with a query from a SQL Server 2008R2 - 64bit
to an Oracle Linked Server.
We use the Oracle 64-bit driver for Windows.
When we query a certain table we get the following error:
...
2
votes
1answer
106 views
Aborted restoring from back up Sql Server 2008
I started restoring from backup using (WITH REPLACE, RESTORE WITH RECOVERY)
and realized that it was a mistake, so I stopped restoring.
Now this db is unavailable and has a 'Restoring' status.
Can ...
7
votes
2answers
213 views
Mirroring the Distributor
Has anyone had success with mirroring the distribution database? We have a dedicated server as a Distributor. It handles all our push replication from prod to reporting. We'd like to build an ...
0
votes
3answers
902 views
Figuring out database timezone
Does anybody know of a way to alter a time zone on a SQL database? Is there any tool that could find the objects using the date and time?
