GilaMonster (4/22/2011)

---

Marco V (4/21/2011)

---

And it will not let you use SQL Server 2000 syntaxes (depcrecated in higer lvl) in comp mode 80 because this is SQL 2005. comp mode 70...

Short answer: No

In theory there can be if you go back from 90 to 80. check http://msdn.microsoft.com/en-us/library/bb510680.aspx you can see that Comparisons between numeric types on 90 can...

Charlotte Bentley (4/21/2011)

---

While it seems HP still has not made the official announcement, some of us have had conversations with HP representatives confirming that PolyServe for SQL Server is now...

its abit unclear what the status is of the cluster at this moment. But you should take a look at this command http://technet.microsoft.com/en-us/library/cc781812(WS.10).aspx

Yes you can

but MS...

Aspet Golestanian Namagerdi (4/21/2011)

---

Hi,

We have plan to migrate from SQL SERVER 2000 to SQL SERVER 2008.We want to set the compatibility mode to 80(to support our existing code).Will this...

think sp_msforeachtable and sp_msforeachdb will get you started

oke default maintenance plans it is i suppose then.

some entries in you SQL log after the "log was backupped" entry when the last log backup was made and the db's...

how do you backup? what kind of tool?

BenniePielaat (4/21/2011)

---

Hi,

Thanks for the fast reaction. We don't need a restore point at all. If needed I will recreate the development again (takes about 2 hours). We will refresh this...

assuming you sql server is configured kinda out of the box. There will be only only a default trace. that default trace does not log inserts/deletes ect only for example...

SET NOCOUNT ON

-- Get the name of all databases

DECLARE AllDatabases CURSOR FOR

SELECT name FROM master..sysdatabases

where name not in ('master','tempdb')

-- Open Cursor

OPEN AllDatabases

-- Define variables needed

DECLARE @DB NVARCHAR(128)

DECLARE...

If you setup "correctly" a trace you cant modify data without if not being logged.

dont know you re policies about restoring development databases. But i can understand its not needed to be point in time restore. Also depending on youre how often you do...

Ninja's_RGR'us (4/14/2011)

---

jremmc (4/14/2011)

---

Great article! (Unfortunately when I tried to rate the article I only got one star highlighted and then the system grabbed it, which is why I usually bypass...