I had the same problem but I am using SQL Server 2008 R2 SP1 with a service broker, but there is no information on internet about this problem.

Did you solve...

After I had this issue too, I changed the DV name from UPPERCASE to LOWERCASE:

sys.dm_db_index_usage_stats

It worked for me.

dbcc showcontig in fact shows you the table fragmentation, but dbcc indexdefrag defrags the index, not the table, so the question is.. How do I defrag a table?

I am looking...

Hi, yo must set your SQL Server service account as a local adminsitrator of Windows

Hi,

I am having the same issue with my sql server, but nobody has answered the topic, did you solve this problem?

Hi, you must to intall Microsoft SQL Server 2005 Backward Compatibility Components, you can download it here:

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

After this, exec this in the run command:

regsvr32 "C:\Program Files\Microsoft SQL...

Hello, this error is stressing me a lot, I can´t find a good answer in all the web. Pls Help

Hi, I don't know if you understand what i tried to say, but if your tempdb database is too big, you want to reduce it's size, so, the only way...

Ok, here is my answers:

1. One way is to add new datafiles to the database, but first look how many processor do you have, be sure that all files have...

Hi friends, greetings from Colombia,

I'm afraid you can't make a backup to a different server mapping a drive, this is just possible if the disk is from a SAN device.

I've...

I had the same problem with one of my database and I restarted the service of SQL Server and it worked, I think it is not a problem of the...

Dear friend,

add de user that you are using for execute the job to the msdb database , add it to the targetServerRole role in the msdb database