Viewing 15 posts - 1 through 15 (of 21 total)
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
September 5, 2012 at 7:50 pm
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,...
September 5, 2012 at 7:48 pm
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...
April 4, 2010 at 5:21 pm
Henrik
Send me aur email, I'll send u an app I use to change collation.
Regards
IT
March 3, 2010 at 10:07 pm
Henry..
Check my post out.. I write this script specially for this purpose.
http://www.sqlservercentral.com/scripts/Database+growth/69634/
Regards
IT
March 3, 2010 at 8:17 pm
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...
February 22, 2010 at 3:47 pm
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...
February 22, 2010 at 3:35 pm
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,...
July 30, 2009 at 5:28 pm
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...
July 30, 2009 at 5:23 pm
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...
July 30, 2009 at 5:15 pm
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...
July 29, 2009 at 10:00 pm
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...
July 29, 2009 at 6:07 pm
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...
July 29, 2009 at 6:03 pm
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...
July 29, 2009 at 5:45 pm
Hi Yogesh
Try this with sqlcmd:
sqlcmd -d master -U sa -P mypassword
and then:
alter login sa with default_database = master
IT
July 29, 2009 at 5:27 pm
Viewing 15 posts - 1 through 15 (of 21 total)