Viewing 15 posts - 7,786 through 7,800 (of 9,241 total)
are there any errors in the Windows event log?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2010 at 12:05 pm
you will also need to issue a GO statement to signal the end of the batch and execute the statements 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2010 at 12:01 pm
mikes84 (8/17/2010)
Thanks for the response Perry!
you're welcome 😉
mikes84 (8/17/2010)
I'm not sure I understand the difference between transactional replication and database mirroring,
The 2 are vastly different. keeping it simple (forgetting...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2010 at 10:43 am
Hi John
this would be a lot better
DECLARE @NewSchema varchar(15)
SELECT @NewSchema = 'pez'
SELECT 'SELECT * INTO [' + @NewSchema + '].[' + t.[name] + '] FROM dbo.[' + t.[name] + ']'
FROM...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2010 at 9:04 am
Rajat Jaiswal-337252 (8/16/2010)
I just want to reduce log file size because there is size issue on my production database drive.
and the log become 20 GB to 30 GB...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2010 at 6:44 am
vamshikrishnaeee (8/17/2010)
3.shrink file -------------
This should be a one time operation, don't make a routine of it!
If your files continuously grow to these sizes maybe you should increase your disk space...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2010 at 6:39 am
mphilippopoulos (8/16/2010)
Perry Whittle (8/16/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2010 at 12:40 am
You'd be better off making the DNS entries CNAME records pointing to the actual computername as this will not change whereas IP addresses can quite easily!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2010 at 12:37 am
to copy table definitions (no indexes or PK's ,etc though) and data use
select * into schema.newtable from dbo.oldtable
for just the table definitions use
select * into schema.newtable from dbo.oldtable where 0...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2010 at 4:18 pm
Correct, SQL Server setup inspects the server locale during install and selects a collation based on the regional settings. It is important to set these correctly during OS deployment!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2010 at 4:09 pm
mikes84 (8/16/2010)
We have a piece...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2010 at 4:00 pm
gmamata7 (8/16/2010)
please advice how that works?
and also what need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2010 at 3:43 pm
the service account should be low permisson. Setup grants all necessary permissions to the account (logon as service, etc) during install hence why you need to execute setup with admin...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2010 at 11:17 am
your welcome.
uninstalling is fairly straight forward via the wizard, provided you don't hit any problems!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2010 at 1:59 am
throneofmight (8/11/2010)
Any ideas on what is required to uninstall a SQL2005 instance that is running in a clustered set of servers?
launch the installer from add\remove programs.
select the clustered database engine...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 11, 2010 at 10:37 am
Viewing 15 posts - 7,786 through 7,800 (of 9,241 total)