Lowell (11/13/2012)

---

it's just something i saved in my notes...i think it has more to...

Thanks, good point. We are migrating from two different servers into one (consolidation) -- SQL 2000 and SQL...

Lowell (11/13/2012)

---

side by side migration, or an in place upgrade?

there's not a lot of difference in the preperation, as compared to a full on disaster recovery plan....if the new server...

Steve Jones - SSC Editor (11/2/2012)

---

Check that the Windows groups have logins assigned in SQL Server.

Check any other Windows groups that have logins for DENY permissions. NOTE that I hate...

Thank you so much for this script. Is there any equivalent script compatible with SQL Server 2000?

Thanks for any help.

- webrunner

GSquared (8/27/2012)

---

I don't think you can do so. Per http://msdn.microsoft.com/en-us/library/aa258841(v=SQL.80).aspx:

DROP TABLE permissions default to the table owner, and are not transferable. However, members of the sysadmin fixed server role...

Perry Whittle (7/2/2012)

---

webrunner (7/2/2012)

---

Hi everyone,

From a security perspective, is it advised or discouraged for non-DBA users to have owner (db_owner or equivalent permissions) to some or all databases on a...

Hi Steve,

Thanks for the tip! That's a great idea.

- webrunner

Thanks, everyone, for your replies. Especially for the information about GO, which I didn't know.

I guess for now, I will make this a longer-term task with a checklist for modifying...

andrew gothard (4/23/2012)

---

The issue with this is as well as asking for you to breech your terms and conditions and compromise your own confidentiality, they are also asking you to...

Hi,

I would like to make use of defragmentation because it sounds like it will help, but my question at this point is, is it really as simple as running Disk...

I wish I had a little Script button for my real life -- oh wait, I think that is called "memory," something I used to have more of. 😛

- webrunner

Thanks for your reply. I am doing the restore from the SSMS 2008 application on my desktop computer. However, the delay is still quite noticeable (5-10 seconds) when I use...

Thanks, Steve, for the thought-provoking question. I think rumors of the death of computer science probably mask the fact that most of the world is probably getting by on the...

OK, thanks again. I will test...