Did you check to see if Network Service has permissions in the new instance?

USE Master

GO

select left(name,25) name, type, type_desc

from sys.server_principals AS log

WHERE (log.type in ('U', 'G',...

Ok... I was finally able to jump back on this problem and get it resolved:

1) Did a full backup this AM.

2) Detached the database.

3) Renamed the LDF...

Gail,

Thanks for the response! I am worried that a restore may be in order, but that usually takes 2-3 days, due to the size of the database (853 GB...

LOL. Sorry... problem with being at work with a cold? Not enough coffee yet? Actually, I ran both DBCC CheckDB (last week) and CHKDSK (today), no errors with either.

I...

Even though this is an older post, some (like me) researching this might find this useful:

Apparently, setting the "Tablix properties" is only good for a Matrix and not a...

I had a similar issue (tried to install Replication after the initial install/patch of SP). Trying to run via the Media (Setup.exe) and adding replication failed (version issue error messages)....

That said, if you are fortunate enough to have a complete lineage-impact matrix of your entire solution and can accommodate all downstream dependencies, a suitable script would be a valuable...

Thanks for that link. 🙂

We reviewed...

Unfortunately, since the the Stored Procedure pegs the CPU at 100% (and this is a Production system), the Execution plan cannot be viewed as it appears to stop running at...

Gianluca Sartori (3/14/2012)

---

If you have enough space in the tempdb drive, you could use SORT_IN_TEMPDB.

Another option is adding temporarily a new data file in the same filegroup in a different...

Thanks for the updates/inputs! 🙂

Everything we do (queries) is very "date-centric" so Date is almost always a part of the clustered indexes on our tables, FYI.... date of a...

Thanks Gail!

I should have known that but I guess my mind was not fully in gear today! 😉

That is why I love this site... always other people with different perspectives and different ways to tackle a problem.

Thanks Ken!

Unfortunately, I cannot modify the dbo.PCList table but my...

This definitely took long enough to figure out. Apparently, the cliconfg settings for a Windows 7 64-bit or Windows 2008 64-bit system is located in two places:

C:\Windows\System32\ ---- 32-bit...

I read a number of the posts, and I guess I would approach the use of SQL Monitor and the iPad from a different standpoint?

First, when I was hired...