Hi

You need to make sure that the storage is made available to the new node.

You can set this up in the Failover cluster administration under storage area.

Regards

IT

Hi

looks like you are wanting to keep track of DDL audit, if this is the case you need to use database triggers and this needs to be setup per-db,...

Hi Ed

Thanks for letting me know, I guess when I wrote the script it is purely to ensure that I know when my databases are running out of space, as...

Henrik

Send me aur email, I'll send u an app I use to change collation.

Regards

IT

Henry..

Check my post out.. I write this script specially for this purpose.

http://www.sqlservercentral.com/scripts/Database+growth/69634/

Regards

IT

Try this out

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

DECLARE @dbname VARCHAR(200),

@sql VARCHAR(8000)

SET @sql = ''

SET @dbname = ''

CREATE TABLE #TMP_ServerDrive(

[DriveName] VARCHAR(5) PRIMARY KEY,

[FreeDriveSpace] BIGINT)

INSERT INTO #TMP_ServerDrive

EXEC master..xp_fixeddrives

CREATE TABLE #TMP_LogSpace...

Hi

The issue with the db name is when you have a space in the database name or '.' character.. I noticed this after I post the script, so a bit...

Hi

Be mindfull that if u r using SQL Server Management Studio 2008, you will not be able to connect to SSIS 2005.

Check which version of SSMS that u r running,...

I don't believe u can, cause inital sql server setup will check for version of the same sql server.

You can run 2000 and 2005 on the same server, but not...

Wade

I am using AD domain account to run my SSIS package, it uses the SQL Server Agent Security.

Just make sure that the SQL Server Agent AD Domain Account has access...

Hi Jeff

If u believe u have completely uninstall the SQL Server, you can try to delete the following folder completely C:\Program Files\Microsoft SQL Server.

Once u've delete the folder, try to...

Hi

Firstly SSIS is a 32bit application, if you are setting up 64-bit sql server, I would highly recommend that you install the SSIS on a separate server.

SSIS doesn't have to...

Hi

Obviously Partition Table will help with the fast loading of the data into your table.

In terms of how u design it, it all comes back to how you design your...

Hi

You can try to utilise databaserole security in SQL Server.

By creating DatabaseRole, e.g. app_operator then you can add the user regardles whether it is SQLusername or ADUsername as a member...

Hi Yogesh

Try this with sqlcmd:

sqlcmd -d master -U sa -P mypassword

and then:

alter login sa with default_database = master

IT