Mike Levan (11/3/2008)

---

we have db's with same schema in the same instance, and this query is ran in all the db's and they run very gud except this db. what...

terryj30 (11/4/2008)

---

try this

1) dbcc opentran(dbname) - this will show the oldest open transaction

2) Kill this process

3) backup log dbname with no_log

4) use dbname

5) dbcc...

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

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic595934-338-1.aspx

And expects it to be sent to him at the author's...

Your index is very, very slightly fragmented (logical scan fragmentation. Lower is better) and the pages are 90% full (Avg. Page Density. Close to 100% is usually better)

All in all,...

It's a good idea. What...

Which permissions?

SQL's permissions work at 2 levels. There are the database-level permissions which are related...

Top 1 not necessary in an exists. Exists just checks if there's any rows or not, it doesn't care how many rows. Remove the top 1 and the behaviour will...

Surprise surprise (not). Is it sharing drives with...

mduffy (11/3/2008)

---

Problem - for the dbm app to work, their sql server login must have the sysadmin role, which gives them power-of-god over all other databases including their own. ...

2GB is tiny for a database. I've mirrored a 600GB one without issues (on a LAN). If you're planning to do it over a WAN, watch out. Other thing to...

muhammed_annaggar (11/3/2008)

---

OK, thanks a lot Karl

Do you know what is happen internally in the server when a user attaches a database, i.e. is there any procedures called or any thing...

To get the latest 100 rows, you need some column that stores the date that the row was inserted, or you need an identity column (or a uniquidentifier with a...

Please don't start a new thread for an existing problem. People who encounter it without reading the original won't have a clue what's going on.

What's the setup, what's the...

Consider Transparent Database Encryption in SQL 2008. It's not username/password, but it will prevent a database from been attached/restored unless the appropriate certificate is on the destination server.

Now, if someone...