It should be;

SELECT 'EXEC sp_grantlogin [' + REPLACE(name, 'old domain ', 'new domain') + ']'

FROM syslogins

where isntname = 1

AND name LIKE 'old domain%'

I tried to use tags and...

He's talking about matching up SIDs domain-to-domain, not at the SQL Server level.

As to how to get the logins switched over, step 1, backup your master database. From there...

No offense, but I think Google and LiveJournal would disagree with you on whether or not MySQL is a real database platform. I remember when LiveJournal recovered from database crashes...

I'll give the standard answer: it really depends on the position.

With that said, there are inherent differences between the two RDBMSes. Some of your knowledge from SQL Server is...

The fact that there is a mismatch is worrisome. It means the service pack applied correctly to one side but not the other. With these kinds of issues, your better...

Right there...

True, but once a person has...

Probably best then to open up a case with support. If it's a legitimate bug, you shouldn't be charged.

It appears to have to do with SQL Server registering with MS DTC. However, the cases I've found where Microsoft has documented it has to do with fail-over clusters where...

Sounds like a problem registering the counters. Is there anything in the application event log indicating an issue with the counters in question?

You can use the ReportViewer control. See the following topic in Books Online:

Integrating Reporting Services Using the ReportViewer Controls

Michael Hotek (former SQL Server MVP) wrote an article about naming conventions on his site. Many moons ago we applied it to our organization (it was written in the SQL...

I'm not aware of any way of customizing that interface. However, if you're running SSMS w/ SP2 applied, you do have the option of building custom reports. Therefore, you should...

SQL Server only compiles/recompiles stored procedures during their execution. Therefore, it needs to be able to resolve the objects at that time. Or I may be completely misunderstanding your question....

The solution Ramesh suggests, to use one of the SQL Server command-line clients, is the one I'd go with. Because it's command-line, you can put in a batch, meaning you...