also, you may want to post in the correct forum section in future 😉

This should not be necessary unless the SQL Server instance is installed on a Vista machine!

what tool did you use to update the service account username and password?

Services snapin

SQL Server Config Manager

are there any errors in the Windows event log?

you will also need to issue a GO statement to signal the end of the batch and execute the statements 😎

you're welcome 😉

The 2 are vastly different. keeping it simple (forgetting...

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