Arthur.Lorenzini (9/10/2008)

---

I found the table that is indicated in the objecid and it contains Text datatype. I know that this is a blob field and have read somewhere this could...

It's not directly possible. A database will always restore with the same number of files as it had when it was backed up.

Once you've restored you can move objects...

Perhaps something like this will work?

SELECT object_name(i.object_id) as TableName, name as IndexName, KeyCount FROM sys.indexes i inner join

(select COUNT(*) as KeyCount, object_id, index_id from sys.index_columns where is_included_column = 0 group...

Could you give us more info please? Maybe give a couple of the queries you want to combine, show what they return now and show what you want them to...

SELECT Object_name(1307971836)

That's the ID of the table and is given in the header of the page

Two things.

You need to run a checkDB. Until you do, you won't know if there's...

That's not in anyway related to the build number and cannot be derived from it. SQL 2005 RTM (for example) is build 9.00.1399 on dev,...

What do you mean by edition?

RTM, SP1, SP2, CU4, ...

or

Developer, Express, Standard, Enterprise

Steve's build list is very comprehensive, though it doesn't contain every single KB that MS has ever...

If you're asking for the edition (developer, enterprise, standard), that doesn't match with a version number at all. Steve's got a list here that matches versions with the build numbers...

Not really. The thing is, the SQL engine needs to be able to decrypt the procedure in order to compile and run it, so you can't use some third party...

A trigger's not the best way of doing archiving. Rather consider having a job that runs once a day (during a quiet time) or once a week or however often...

What format's the deadlock info? If it's the text deadlock graph from the error log, just put it into a post. Otherwise zip and attach and explain what's in the...

Suspended indicates that the query's waiting for a lock (or other resource). Query sys.dm_exec_requests, see if the query is blocked, see if it's waiting on a resource.

If it's blocked, check...

The log will continue to grow until a truncate is issued, at which point the space within the file will be available for reuse.

You say the DB's in full recovery...

You'll be surprised. Very surprised.

Do a google search and see how many sites...

You said before it was an insert trigger. Need to know a lot more about what the trigger's doing before I can say anything more than I have on the...