the issue is that the user [ssrsuser] on one server does not have the exact same sid as the same named user [ssrsuser] on the other server where you restore.

if...

a connection without a port assumes the default port of 1433, OR that a SQL Browser service exists on port 1434, which in turn redirects the connection to the "right"...

the union logic, assuming you have indexes on each of the Pend columns would be the best solution.

the OR would work, but perform horribly on big tables.

do you have indexes...

search for the DelimitedSplit8K function, and understand the article.

then it's just a matter of chopping up the strings:

/*--Results

jmaPartShortDescriptionItemItemItemItemItemItem

5.625X11.25-2.875x8.5 5.625X11.252.875x8.5 5.62511.252.8758.5

5.625X35.25-2.875x32.5 5.625X35.252.875x32.5 5.62535.252.87532.5

22.5X9.75-9.5x19 22.5X9.759.5x19 22.59.759.519

28.5X9.75-9.5x25 28.5X9.759.5x25 28.59.759.525

40.125X9.75-9.5x36.625...

wouldn't that just require a bigger WHERE statement?

WHERE Pend1=@param

OR Pend2=@param

OR Pend3=@param

OR Pend4=@param

OR Pend5=@param

t think...

you cannot detect the end user's domain account directly.

maybe you could loosely infer it.

because your application is using a "common" login, only the application knows who it is;

if you can...

on my servers, i have a few emails that failed and still sent; i think it has a lot to do with your mail server.

try this query out for size:

SELECT...

i believe the defaults for DbMail, since it's asyncronous, is to try to resend a message one extra time if it fails, but it's configurable; i once inherited a system...

if you create table in tempdb, without the # or ##, it will stick around until the server is stopped and started:

IF OBJECT_ID('[tempdb].[dbo].[Facility]') IS NOT NULL

DROP TABLE [tempdb].[dbo].Facility

Create...

if your table had a row number or primary key, then it could be displayed.

does your real table have it?

so isntead of this:

create table #isin_code

(

code varchar(5),

code_desc Nvarchar(510)

)

it's really this?

create table...

create a table with a known name, and then rename it.

declare @newname varchar(30) = 'ACRC_427_' + CONVERT(CHAR(10), GETDATE(), 112 )

IF object_id('stagingtmp' ) IS NOT NULL

EXEC('DROP...

yes that will work,...

that just copies logins featuring their hashed password, and not their associated roles.

grab this version, which is enhanced to do exactly that:

http://www.tinyint.com/index.php/2009/07/08/sp_help_revlogin-cleaned-up-and-revised-with-roles/

actfio is one of those applications like the retired Redgate SQL VirtualRestore, or Ideras Virtual Database and others that allow you to load an existing backup and immediately treat it...

what is a data model to you?

there's tons of example scripts of database documentation,scripting out object definitions, basic counts and stats, how to create diagrams, etc, but "data model"...