Grant Fritchey (8/23/2010)

---

The one thing that I see missing from this process is any hint that you're using some type of source control. As a matter of fact, I think...

rottensystem (8/23/2010)

---

PragmaSQL (CodeProject winner of 2010 on Best General Database Tool category)can handle script execution on multiple databases with a single click.

Please check out http://www.pragmasql.com for details. You...

clementhuge (8/23/2010)

---

Hello,

I might have read the article too quickly. So I apologize if I miss some information.

The methodology you are taking is very similar to the methodology in place at...

I just ran this:

ALTER SCHEMA sk TRANSFER dbo.Names

That ran without issue on a SQL 2008 system running build 2734 (SP1 CU6 I believe).

What is the owner of your schema? ...

Do a find/replace of YOURDBNAME in this script and that should give you what you are looking for. It's a modified version of the sp_help_revlogin for SQL Server 2005...

It sounds like a network connectivity issue with node 2. Unfortunately, it would be hard to guess at what the issue might be. It may be worth looping...

Sankar,

Thanks for the clarification. Apologies for any confusion all.

Steve

A few links were found:

http://www.sqlskills.com/blogs/paul/category/Page-Checksums.aspx

"In benchmarking tests with a TPCH workload during SQL Server 2005 development, we measured approx 2% performance degradation as a result of having checksums enabled. "

I...

This article speaks to the Windows Security that is needed to avoid adding the user to the Administrators group on the server:

http://msdn.microsoft.com/en-us/library/aa337083.aspx

You may want to look into the...

Good to know. That likely worked because the new account got a new SID.

Take care,

Steve

I'll try to comment here for you.

Do I need a specific version of Visual Studio to develop reports with SQL Server 2008 R2 Reporting Services? We use VS2005 currently to...

You may also want to schedule a failover test of the database to the mirror location, and then configure your maintenance plan during that window.

We use custom SSIS packages and...

My guess in your findings is that the bytes would be less for mirroring because the logs are compressed before shipping with SQL Server 2008 and SQL 2008 R2. ...

Those groups are needed if you are looking to configure the services with "least privileges"..

I would recommend checking out this link for some additional details:

http://technet.microsoft.com/en-us/library/ms143504.aspx

I don't have access...

Hi Marios,

Has the SQL Instance been restarted at all? My account was renamed, and instances that we haven't renamed yet still link my SID back to my old account.

I...