Dec 24th, 2008
by Colin Stasiuk.
If you’re on the latest service packs for supported versions of SQL Server (SQL 2005 SP3 or SQL Server 2008) then this does not affect you. Seeing as how SP3 for 2005 was just officially released last week I’m sure it’s not applied in all environments yet. If you’re on SQL 2000 well… all the [...]
Dec 9th, 2008
by Colin Stasiuk.
What is SQLpermissions? Idera’s SQLpermissions is a freeware tool for copying or moving logins and permissions settings across SQLservers. SQLpermissions automates the time consuming job of configuring logins and permissions on one server to match another by generating a customizable TSQL script to do this for you. SQLpermissions also offers the flexibility to move one [...]
Nov 4th, 2008
by Colin Stasiuk.
When you restore a SQL Server database on a different server, SQL Login database users cannot access the database until you fix the permissions. The problem is that the user in the database is an “orphan”. This means that there is no login id or password associated with the user. This is true even if [...]
Nov 4th, 2008
by Colin Stasiuk.
ummm I dunno… why can’t you see the script behind the stored procedure? I can see it just fine…. then again I’m sysadmin so if I can’t see it then there is definitely a problem. Turns out… after all this time with working in SQL 2005 I still learn new things or at least things [...]
