Viewing 15 posts - 7,801 through 7,815 (of 9,253 total)
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...
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...
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...
August 17, 2010 at 6:39 am
mphilippopoulos (8/16/2010)
Perry Whittle (8/16/2010)
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!
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...
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!
August 16, 2010 at 4:09 pm
mikes84 (8/16/2010)
We have a piece...
August 16, 2010 at 4:00 pm
gmamata7 (8/16/2010)
please advice how that works?
and also what need...
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...
August 15, 2010 at 11:17 am
your welcome.
uninstalling is fairly straight forward via the wizard, provided you don't hit any problems!
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...
August 11, 2010 at 10:37 am
Sam -480699 (8/10/2010)
Is it possible to create a 2 node (active / passive) cluster where the SQL databases are not using shared storage.
Thats the whole point of a...
August 10, 2010 at 9:55 am
TheSQLGuru (8/10/2010)
In any case, BOL...
August 10, 2010 at 9:49 am
gmamata7 (8/9/2010)
to see whether we can keep the same Virtual server name and SQL Server instance
As I said the virtual network name, like a computername must be unique in the...
August 10, 2010 at 1:11 am
Viewing 15 posts - 7,801 through 7,815 (of 9,253 total)