Had been busy with issues at work..

alan.nichol (12/2/2009)

---

As a newbie, I need help in looking at triggers and how they would work, if at all, with any change in the Autogrowth of one of my databases....

A tutorial on SSIS would be needed.

Look at the Books Online and under SSIS, you have How To topics look at them.

Look in SQL Server Configuration...

Let me ask this first, what is the edition that you are going to have on Production Servers?

Reason, if you are going to implement a Standard edition, I would suggest...

pdevadiga (12/2/2009)

---

Looks like this is going to be a nightmare:w00t:...so what would I do is simply place these different sized ndf files on seperate set of disks...at least I...

Is your SQL Instance named as Express?

Is SQL in mixed authentiication mode?

Are the named pipes enabled?

Check these out.

How are connecting from Excel...

Check in SQL Server Configuration Manager, under network settings. If Named Pipes are enabled.

I did implement the same solution (of course on one central SQL Server) in the current project during last month, and I am in the process of documenting it and...

I did implement the same solution (of course on one central SQL Server) in the current project during last month, and I am in the process of documenting it and...

Edited : The reply was double posted.

In the screen where you are creating the Login, in the left hand pane you have multiple pages, in that choose User Mappings.

It has the databases in your SQL...

You have already mentioned that the application is not compatible with SQL 2008 and Windows 2008.

It's better to have a word from the same application team about their view...

The DBCC SHRINKDATABASE Shrinks your Database, freeing up some space to the Operating System.

Read Books Online for a detailed information on...