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...

Rajat Jaiswal-337252 (8/16/2010)

---

Hi Thanks Jeffery,

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...

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...

mphilippopoulos (8/16/2010)

---

Perry Whittle (8/16/2010)

---

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...

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!

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...

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!

mikes84 (8/16/2010)

---

Hi, I have a scenario that I'm not sure will fully work, but I'm hoping to get some of your feedback to see if it's realistic.

We have a piece...

gmamata7 (8/16/2010)

---

While installing sql server 2008 using setup.exe, do we need to provide the virtual server name & sql server instance name again?

please advice how that works?

and also what need...

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...

your welcome.

uninstalling is fairly straight forward via the wizard, provided you don't hit any problems!

launch the installer from add\remove programs.

select the clustered database engine...

Thats the whole point of a...

TheSQLGuru (8/10/2010)

---

I still refer to numerous 2005 features as "new". When you have been using the product since 6.5 first came out . . . 🙂

In any case, BOL...

As I said the virtual network name, like a computername must be unique in the...