It is not stored in the database, it is stored in the registry. It also appears in the errorlog file.

You might look at:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQLServer\SuperSocketNetLib\Tcp\IPAll

Or around there for the...

Agreed, I think SQL 2005 was the transition version. SQL 2000 was like 99% 32-bit, 2005 50/50?, 2008R1/R2 80+%.. Sounds about right to me..

CEWII

In 2005 when this article was written 64-bit hardware was expensive and not easy to come by so not many people were uing it. Nowadays it is considered commodit...

Per books online there should be a spot to enter it when you go to the configurations tab. I am verifying on a SQL 2008 box.

It asks when I...

In the properties of that provider is the Allow inprocess option checked?

CEWII

Lets see, perf mon counters to look at..

Output Queue Length (on the nic interface) near 0

Page Life Expectancy (SQL: Buffer Manager) I don't like seeing any number under 600,...

Is there a SQLNCLI in the providers list? I don't have a 2005 available at the moment so I can't answer it myself. but look at my questions...

Well, if your scripts contain all the drop/create logic and end in a GO statement followed by a CR/LF you can use a command like

COPY *.sql ..\combined.sql

The file combined.sql...

In my view a trigger is out, cross server triggers are an accident waiting to happen, if for any reason the update doesn't occur it rolls back. You already...

Under linked servers|Providers, if you get the properties of SQLNCLI10, is the "All inprocess" box checked?

If not, check it, you might have to restart SQL to get it to work...

By "my conection doesn´t let me to save my password." I assume you mean that you are not running the SSIS package as your domain user?

If that is true then...

Grant Fritchey (12/20/2010)

---

ALZDBA (12/20/2010)

---

just my 2ct.

With regards to a log shipped db, connections will have to be modified at switch time !

With regards to a mirrored db solution, you...

CirquedeSQLeil (12/20/2010)

---

We use a two-op approach but don't use tape backup anymore. We backup to disk and then those backups are retrieved into an appliance that is disk based....

If any user anywhere has it open you will get this message. Do you have it open in Excel on your desktop? Had it happen many times..

CEWII

The first response is the right track. I would caution you on how you use linked servers. Do not do large table joins, query for discrete recordsets. ...