AVB (5/7/2008)

---

If an Update occurs and the data is deemed "bad" I can just update the table with the values from the "Deleted" Table.

If an Insert occurs I'm not...

Depends what it is. The database backend for my blog and personal web site. Hosted. The databases for a major bank. Own data center with own staff.

If you're hosting, make...

Hints in general should be avoided unless you really know what you're doing and have a very, very good reason to use them.

Badly applied locking hints can cause major problems....

The top's in the wrong place

SELECT TOP 1 @ID = OrderVal FROM qryCust

WHERE OrderNo = '000663' AND DiscountGroup = 'XXND' AND CustID = 3

Views are just saved select statements. UDFs, especially the multi-statement table valued function, can have complex logic, conditional statements, loops, etc

At time of execution, the defnition of a view it...

User databases or system databases?

User databases are easy. Detach, copy the files, reattach. The system ones are a lot more tricky and the method is different for each one.

There's probably...

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to the following

http://www.sqlservercentral.com/Forums/Topic496050-147-1.aspx

Should be possible, though I've never tried.

The hex value given (9701bf0d0dea) is a hash of the index keys. If you know what hashing algorithm is used to generate that (maybe...

Can you change the password? Not perfect, but should suffice.

Looks like a partition ID. Your KB article is SQL 7/2000

Try querying sys.partitions where partition_ID = 72057594386382848

You should be able to get the objectID and index ID from that

Do not update the system tables. It can have nasty side effects and is extremely risky.

Windows or SQL login?

Thanks

Yup, looks like a permissions problem. Just note, it's the SQL Server Service account that needs rights to that directory. Not the account that you are logged in as.

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to the following

http://www.sqlservercentral.com/Forums/Topic495651-291-1.aspx

Except that he's got nothing to do any ordering by, and nothing in the data that defines which the 'first' row is. Hence the necessity of the 'numbers' column in...

I said that the fact that the table's a heap may have something to do with how the optimiser costs the seek vs the scan. Your query pulls 0.06% of...