to BACKUP db_owner is needed but to RESTORE you need to be part of dbcreator FIXED SERVER ROLE.

Rebuild indexes, update stats (with fullscan) and update usage are recommended right after the DB upgrade.

If you...

rjshupert (11/18/2008)

---

I have to columns that performs sums. However I want the specific data type to be decimal with two decimal places, and not numeric. I've tried to...

DECLARE @account int, @from datetime, @to datetime

select @account = 1 , @from ='20081112', @to ='20081115'

;with cte (ACCOUNT, DATE,LOCATION) as

(SELECT '1', cast('2008-11-17 00:00:00.000' AS datetime),'EAST'

UNION ALL

SELECT '1', '2008-11-02 00:00:00.000','WEST'

UNION ALL

SELECT...

Great post.

This reminds me of the good old days about .... "oops, I for got to highlight the 'where' clause"

If the initial snapshot is applied...

Make sure all replication Jobs in SQL Agent belonging to that publication are gone.

A little advice try to do the pivoting on the client-side.

IF you don't need to validate etc you should use format files to handle this kind of things

You can setup a logon trigger and do a rollback if the login is the one you need to avoid 😉

jbraun (11/10/2008)

---

Hi,

I need some help with some replication that I am attempting

I have transactional replication running between 2 dbs. The subscriber table has a check constraint that ensures only certain...

Glad it worked out!

For the Record SQL Server 2008 has Transparent Data Encription TDE which is supposed to be used in these cases for maximum security.

I would probably like to be in the receiving end of the pork chop launchers :D:D