Vicki I'm pretty sure the issue is that the same object_id exists in multiple databases....

that view returns multiple database results, not just results from a single database.

change that query to...

i think what you want is a schedule job that runs every day.

that job updates rows meeting your criteria for being delinquent.

when i read this requirement:

i see that as saying a suite of constraints like...

that post from Paul exactly encapsulates that portion of his presentation Chris, yes.

» Dmitri Korotkevitch's web site, now...

Danzz (8/16/2011)

---

I am trying to add NOT NULL column to existing table.

when I try to add it throws an error.

Msg 4901, Level 16, State 1, Line 1

ALTER TABLE only...

I googled and didn't find anything definitive that said you had to upgrade to SP4 prior to upgrading to 2008...where did you see that?

my recommendation would be only if it...

Gail, would disconnecting every connection, as an attempt to clear whatever is blocking that rollback, be helpful at all?

you'd need to call a either a third party dll like we used to have to in SQL2000 (via cmdshell and sp_oaCreate)

I used to use a dll from AspEmail a...

i just sat in on a SQLSaturday #79 in Davie(Fort Lauderdale) presentation on how to improve performance in exactly this situation;

the Presenter was Dimitri, and he had a great example...

much easier to comprehend...that whole pseudo code to abstract the logic actually made it harder to understand.

the rules you pasted are actually multiple separate and distinct check constraints....all of...

http://www.quest.com/litespeed-for-sql-server/

SQL LightSpeed is a third party applicaiton that creates backups for SQL server; it's faster than native backups and also compresses the backups to a smaller size.

you'd have to have...

zozilany (8/15/2011)

---

I am trying to create a Linked Server to an MS Access database on a computer other than where SQL Server resides. I can create the linked server if...

Sachin Nandanwar (8/14/2011)

---

Just because you define it as a "Best Practice" and it gives me an overhead in maintenance then surely I am better off in not using those "Best...

don't you have to explicitly state you are inserting nvarchar? otherwise there is an implicit conversion wich is incserting the question marks

this may help a little;

this gets all the directories in a given directory.

from there, you can cursor thru to build what i had hard coded to 4 specific directories:

--some variables

declare...