wouldn't it be four-part naming convention?

i.e. SET @from = N'.database_name.schema_name.table_name Where criteria'

Hmmm, runs fine on my server (again, SQL 2000). Maybe something lost in the copy paste, it's happened to me before. A single quote(') comes across as a different single...

It definitely does log all the backup information. This may be overkill but if you look at user_name, you can tell who ran the backup and decipher which is netbackup...

What does that mean?

I run the following once a week to "monitor" my metrics (not sure where I found the script but I'm guessing here!). I can then get a baseline of each...

Just my 2 cents....From time to time, when I run a query via QA, the transaction remains open and I will sometimes block other processes until I close my widnow,...

If you have issues, post the exact sytax you're trying to run and you'll get plenty of help.

Vinay (4/13/2009)

---

When we study on the question and give answer and found that the answer is wrong we feel bad... so if we answer correct we should get the responce...

Or something like the following, which may be faster depending on the amount of data you are deleting:

--this saves the data you want to retain

select * into NEWhugetable from hugetable...

That's the beauty of these forums. A little nudge in the right direction and things come into...

I started to do that. The table has 660K rows of data. After about 10 or 15 minutes, I finally canceled the query. I don't deem the number of rows...

The combination of all your key fields needs to be unique:

DATAAREAID],

[CONFIGID],

[INVENTSIZEID],

[INVENTCOLORID],

[INVENTLOCATIONID],

[INVENTBATCHID],

[WMSLOCATIONID],

[WMSPALLETID],

[INVENTSERIALID]

Can you view the logs of the job for Saturday and Sunday? It looks like you only do weekdays. Right-click on the job and view job history (or double click...

Vijaya Kadiyala (4/8/2009)

---

??? rtrim and ltrim don't count?