Viewing 15 posts - 7,786 through 7,800 (of 9,244 total)
also, you may want to post in the correct forum section in future 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2010 at 12:27 pm
onlo (8/16/2010)
(2)The last step was failed : The provisional tool for Windows Vista client.
This should not be necessary unless the SQL Server instance is installed on a Vista machine!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2010 at 12:11 pm
- Win. (8/17/2010)
And we updated the domain account and password
what tool did you use to update the service account username and password?
Services snapin
SQL Server Config Manager
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2010 at 12:08 pm
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
Viewing 15 posts - 7,786 through 7,800 (of 9,244 total)