|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, October 21, 2009 11:35 AM
Points: 1,185,
Visits: 2,513
|
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, June 04, 2008 8:16 AM
Points: 2,
Visits: 8
|
|
Hi Ken,
got a little problem running your first script.
I got the error: "Type SYSNAME is not a defined system type."
Any idea why this could be?
Thanks in advance
Steffen
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Thursday, November 05, 2009 6:34 AM
Points: 324,
Visits: 741
|
|
Looks like your database server is case sensitive (like mine.)
change SYSNAME to sysname and you should be ok.
Also sp_msforeachdb will have to become sp_MSforeachdb
Regards,
David.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, June 04, 2008 8:16 AM
Points: 2,
Visits: 8
|
|
Hi,
that's it!!!
Thanks a lot!
Steffen
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, November 05, 2009 12:05 PM
Points: 129,
Visits: 371
|
|
Very good scripts.
Ken, you made my task so much easier.
I am on migration project. This article was very useful to sync up the logins.
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, November 05, 2009 2:19 AM
Points: 87,
Visits: 155
|
|
Hi Ken,
Tried this against a couple of our dev servers + it picked up a couple of rogue logins on the SQL 2005 box but it failed with "Line 7: Incorrect syntax near 'Collate'." on SQL 2000. Does the 2000 version of sp_msforeachdb not like "Collate"?
Thanks for the article.
Mark
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Monday, November 02, 2009 9:26 AM
Points: 3,280,
Visits: 962
|
|
Nice article .............
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, November 03, 2009 7:47 AM
Points: 3,
Visits: 30
|
|
Ken,
This is the type of script that I have wanted forever! Thanks. One problem, I am not able to get it to work. I copied and pasted as is and I get the following...
Line 35: Incorrect syntax near 'sp_msforeachdb'.
I am assuming that the Set @SQL statement is the problem (as it is all in red).
Any help would be great.
BTW, my environment is SQL 2005 SP2 Std.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, October 27, 2009 6:22 AM
Points: 5,
Visits: 70
|
|
Hey Ken, speaking of Syncs...guess what we're finally rewriting...we're going with SQL CE...
SQL Babe
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Thursday, November 05, 2009 7:19 AM
Points: 20,
Visits: 85
|
|
I copied and pasted as is and I get the following...
Line 35: Incorrect syntax near 'sp_msforeachdb'.
my environment is SQL 2005 SP2.
|
|
|
|
