here's two different ways i can think of;

you have to lookm at the column size of the data for anything that could potentially be greater than ~8000 chars.

by looking at...

if @vSurveyMessage has the literal value of thiis:

@vSurveyMessage = 'Recently we invited you to participate in a survey to help ' + [@vfirstname]'

then you'll need to do a REPLACE...

the object_name() function has a second parameter to pass the database id; i think it got added ina Sp of 2005, and 2008 and above:

select

db_name(database_id) As DBName,

...

Nemachtiani (6/22/2011)

---

Hi all

Does anyone know what would cause data loss on tables after commit with no errors raised neither executed DELETEs?

Is this a symptom of database corruption?

I have...

i think if the procedure is doing dynamic SQL, the owner chaining rears it's head as well right? and the user needs access to the underlying objects being manipulated via...

i think because you are concatenating @ViewDefinition with @SQLCmd, they should both be NVARCHAR(max) definitions:

DECLARE

@FieldName VARCHAR(50)

...

there's only two ways i can think of:

1. use synonyms, and dynamically change the synonym defintion.

the problem with that is the synonym must point to an OBJECt, like a table...it...

- Win. (7/25/2011)

---

Hello Lowell..

Thanks for your help on auditing and for your query..

I tested that in my DEV environment, but its giving only MASTER database info alone.

I tried creating...

also, there's two places to look;

I believe if you have set up a proxy account, if you are sysadmin, it will use that account no matter what, and that account...

my answers:

Hi,

I am new to sql server administration. And I was asked this question in one of my interview.

You are unable to connect to sql server. Where do you...

take a look at Brent Ozar's Blitz! 60 Minute Server Takeovers , he's got a nice analysis script of stuff to look for when you walk into a new...

ahh...my...

here's a simple example in VB: if you're not familiar with programming , you might want to call upon a peer to do the deleting for you.

...

don't forget to script your logins from the old server to the new one with sp_help_revlogin

hmmm.. running a huge botnet like that ...i think you'd have to be an MCTS ...maybe a MCITP....youknow BSCS and OCA/OCP might be handly...hm....

who do i know that fits those...