you could use a union to do the same thing:

select tb1.Col1, tb2.Col2, tb2.Col3

from TB1

left outer join TB2 on tb2.Col1 = tb2.Col1

union

select tb1.Col1, tb2.Col2, tb2.Col3

from TB1

left outer join...

Can you make Server3 a subscriber too? If you don't want the entire publication you could subscribe to just the articles that you need.

I have not tried to make a...

Ed Wagner (11/5/2013)

---

Perry is right - use a netstat -n to find ports that are in use then simply pick a different one. I'd avoid the known standards like...

The first question is which recovery model makes sense for your environment. Basically the question comes down to how much data can you lose? If you can lose 24 hours...

You do not specify what to join D0 to S on. I think you need something like this:

WHERE S1.BoMID = @SourceID AND T1.BoMID = @TargetID) S on D0.BoMitemID =...

Did you recently restore this database to a new server? Sounds like you are missing the login, but have the user in the database. You will need to create a...

If this is a controlled environment you could use the following script (change database name):

SELECT file_id,

io_stall_write_ms,

io_stall,

num_of_writes

FROM sys.dm_io_virtual_file_stats(DB_ID('DATABASENAME'), 2);

http://technet.microsoft.com/en-us/library/ms190326.aspx

Run it before your transaction and then after...

So, lets get back to your issue. Which is you are experiencing blocking issues (I'm guessing) and you want to remove table locks to prevent blocking? You will still have...

Trying to understand your table structure. You have a single audit table that handles audit information for multiple tables? Do the base tables have a PK and/or clustered index? I...

Deletes do not automatically become table locks. What you are seeing is lock escalation. Locks go from row/page to partition (if enabled) to table. So with all of the activity...

Is this a homework assignment? The people here are usually not going to do your homework for you, but if you make an attempt at doing the work yourself and...

Is it possible to create an CLR stored procedure to do what you need it to do? CLR has more security safeguards then sp_OA. sp_OA used to have some serious...

You just need to create the temp table in the stored procedure and then use the output...into temp table. Like so:

create table #TempTable (same strucutre as postcodes?)

...

try this (make sure to change the InstanceName to your instance name:

USE [master]

GO

EXEC sp_configure filestream_access_level, 2

RECONFIGURE;

go

CREATE DATABASE [AdventureWorks2008] ON

( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.InstanceName\MSSQL\DATA\AdventureWorks2008_Data.mdf' ),

( FILENAME = N'C:\Program...

Make sure you are calling the function with a 2 part name dbo.GetActiveEventBackOrderUnitsCount