Yes,

Transactions starting from Subscriber are applied at the Publisher.

Additional Info @

In the UK at anytime this year guys?

Would love to attend the course, but I dont think I could justify a business to travel to the US.

Why dont you set up a small test in your staging evironment???

Show this "so called" dba that the likes of @Gail (extremely well respected in the SQL community!) say...

On the AskSSC forum @Fatherjack has added some additional notes with regards to the ordering of the ID's (in relation to indexes).

Reindexing DEFINATELY doesnt not change the seed...

Yeah, know what you mean...

😀

Lynn, I answered the same thing on ASK....

Double posting.

To transer the jobs/ssis you can use SSIS itself to copy the jobs.

With regards to the data there are a number of option..

I would go with automated backup/restore as there...

Are print screen would be nice. Have you installed the BIDS help tools?

http://www.codeplex.com/bidshelper

Are you within the SSAS explorer?

Only thing to is follow the article..

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86983&SearchTerms=Recover,SA,password

If you use the web interface to assign "you" permissions then it shou,ld give you access.

You will need to add your user name to \Users Folders\Username\My Reports.

Just tested myself and...

Are the user folders created under the "NT AUTHORITY\SYSTEM" account?

Only way I have been about to get these is to extract the report using SSRS Scripter..

http://www.sqldbatips.com/showarticle.asp?ID=62

I have a few questions...

- What is the spec of node A? COU/Mem/Disk setup, using x86 or x64

- Out of the available memory how much is allocated to SQL

- Are...

You have added the post to SQL 2005... Not there in SQL2k

Try ..

SELECT * FROM syslogins

From my memory i think there is a is_disabled column

Within SSMS you will see a "red" down arrow.