Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic745523-359-1.aspx

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic745523-359-1.aspx

You can chance them as you like. A switch to simple takes effect immediately. A switch from simple to either full or bulk logged takes effect after the next full/diff...

Are you sure? I just ran it on my local server (admittedly SQL 2008) with just the SELECT ''?'' inside the IF and I got a list of all of...

Please read through this - Managing Transaction Logs[/url]

Yes, absolutely, and someone needs to review the results...

EXEC master..sp_MSForeachdb '

USE [?]

IF DB_ID() > 4

BEGIN

SELECT ''?''

ALTER DATABASE ? COLLATE XXXX

END'

Be careful if there's replication, as that will still affect the distribution...

ps (7/1/2009)

---

I also told them to notify such issues to the database team (for servers hosting databases) asap so that we can restore the db from a clean backup(if need...

Untested, but should do as you want.

CREATE PROCEDURE [dbo].[GetOverallStatus] @statusid int, @Rows int OUTPUT

AS

DECLARE

@tablename varchar(200),

@query nvarchar(1000)

BEGIN

SET NOCOUNT ON;

SELECT @tablename = Tablename FROM dbo.Status...

Valid T-SQL constructs. Should intellisense show that DATE is a...

Steve Jones - Editor (7/1/2009)

---

I think we'll be more database centric, and less instance centric in terms of how we deploy and manage the th databases. Beyond that, I'm not...

The damage was in the cluster. It could be that you got lucky and it was an empty page that hadn't yet been dropped from the index.

p.s. you need to...

Edit: redundant

That's an awfully small autogrow amount for a 4GB data file

I don't quite know what you want. Could you explain more.

Do you want single values...