Viewing 15 posts - 1,531 through 1,545 (of 6,105 total)
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...
November 5, 2007 at 7:04 pm
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...
November 5, 2007 at 7:02 pm
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...
November 5, 2007 at 6:39 pm
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...
November 3, 2007 at 7:22 am
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...
October 27, 2007 at 8:35 pm
Bob Fazio (10/26/2007)
End Users should not have access to direct SQL. PERIOD! If it is a reporting system some visual tool yes, but not SSMS.
Right there...
October 26, 2007 at 11:29 am
Matt Miller (10/26/2007)
In other words - be careful that a short term "opportunity" doesn't turn into a long-term S***ing opportunity of you by the organization....
True, but once a person has...
October 26, 2007 at 10:12 am
Probably best then to open up a case with support. If it's a legitimate bug, you shouldn't be charged.
October 26, 2007 at 10:10 am
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...
October 26, 2007 at 2:04 am
Sounds like a problem registering the counters. Is there anything in the application event log indicating an issue with the counters in question?
October 25, 2007 at 9:33 pm
You can use the ReportViewer control. See the following topic in Books Online:
Integrating Reporting Services Using the ReportViewer Controls
October 25, 2007 at 9:29 pm
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...
October 25, 2007 at 9:25 pm
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...
October 25, 2007 at 9:17 pm
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....
October 25, 2007 at 9:14 pm
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...
October 25, 2007 at 9:12 pm
Viewing 15 posts - 1,531 through 1,545 (of 6,105 total)