For example, the Agent runs a SSIS package, that executes a stored proc in the DB. These jobs do things like read files from a seperate machine that's a file...

Hi,

We are looking at purchasing "SQL Server 2008 Standard for Small Business", but need help to confirm if our systems will meet the restrictions of the “Small Business” version. http://www.microsoft.com/sqlserver/2008/en/us/small-business.aspx

Can...

Steve Irwin (11/20/2009)

---

I'm currently developing reports locally with the Report Builder application as well as in Visual Studio 2005. Unfortunately, our current server hosting plan with GoDaddy does not...

Must get round to writing this as an articel some time. [BigGrin]

This document assumes that the SERVER is at the correct collation and that the DATABASE is a different collation...

Dom Horton (11/20/2009)

---

Hello,

I'm currently running SQL Server 2005 SP2 Developer x64 on a Windows Vista Ultimate x64 machine and I'm looking at upgrading the OS to Windows 7 Ultimate.

Has anyone...

I used Vault in 2007 with...

Neal Sivley (11/19/2009)

---

I don't know this for sure, but I think you can only install Developer Edition, Workgroup Edition and Express Edition on a Workstation OS. 2000, XP,...

MattieMich7 (11/19/2009)

---

When I originally installed SQL Server 2005 Standard on my PC, I could not add the Reporting Services component because I had the Vista Home Premium OS (Vista Ultimate...

polo.csit (11/19/2009)

---

how to implement Unicode ...In a Database i m having a field with nvarchar (max) datatype when inserting a unicode string from the text box in to the database...

If we were using Exchange it could take the windows login and resolve it to your email address. As Lotus Notes isn't integrated in that way it takes the windows...

lokhande.deepali (11/18/2009)

---

--I am assuming you know the whole server require master rebuild

Yes , I know that to rebuid require when system databases collation has to be changed.

I want script which...

Seth Lynch (11/12/2009)

---

Hi

We have SSRS set up with Windows authentication - but out email uses Lotus Notes.

When you hit subscriptions in SSRS you can choose to get an email subscription...

5409045121009 (11/18/2009)

---

The following article explains how create a unique file name by using @Timestamp. See http://blogs.msdn.com/eugenebykov/archive/2009/10/05/including-time-stamp-in-subscription-report-file-name.aspx. My question is which other @Variables are available or where can I find more...

gmamata7 (11/18/2009)

---

I think we do not need to install the Visual studio 2005 on production server and it's only required on Developer machines right?

and also Books online and workstation components...

this is a known bug:

search "SSIS - SQL Server BIGINT doesn't map to INT64"

on https://connect.microsoft.com/default.aspx

workaround is to use STRING...