Funny, we started working on this last week.  Our security admin rolled out some changes to the registry that disabled TLS 1 and RC4 to eliminate some vulnerabilities.  Here is...

See this article:

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/64585/

AndrewSQLDBA (7/29/2010)

---

That is not true, with SQL Server, I am able to store as many different connection strings in a single table, in a single database.

I am just not sure...

We use a SSIS package to poll servers and pull in information about those servers. We also pull a list of databases and maintain a list which controls backups....

You should be storing one environment on one server. When you move to a new server, you get the new values. In order to use different sets you'll...

The title RSS Scripter.

Should be chagned to RSScripter.

Enjoying the concept so far...

edwardelliott (4/17/2009)

---

I have gone ahead and raised a bug on connect about this:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=433382%5B/quote%5D

Nice! Thanks Edward! 😀

corsair1 (4/29/2009)

---

Have you tried using SSRS Report Builder for Ad-Hoc queries in place of Access? It has much better performance than Access, limits what they have access to, & is...

Gaby Abed (4/29/2009)

---

I strongly recommend, if this is to be a regular occurence, that you create a dedicated reporting server, and have the data from your production server replicated across,...

Let me clarify - we have 8 processors and one instance right now. We will add an additional instance and...

So if we have the extra instance and set that two use 2 processors of 8 using the affinity mask, can the other instance still use all processors?

Is the overhead of another instance limited?

We're just finishing up our migration of 170 dbs to 2005....

Stamey (4/28/2009)

---

My solution for this, in the many cases I have run into in the past, is to restore the nightly backup of said DB to another DB on the...

Ratheesh.K.Nair (4/28/2009)

---

Why can't you try installing an Express Edition and then restore your DB .

Since your DB is less than 4Gb you can use SQL Server Express Edition and Express...