I use SQL projects and a single solution. I then load them all into source control.

Not really true. You will not...

Worth noting that, I'm assuming there are no changes going on in the data at the time of migration. Else you will need to do some data validation/comparisons etc.

That's likely the key.

By default, generate scripts will create a script for subscriptions as they were initially setup...

I perform regular migrations like this without issue.

How did you script the publication did you make any modifications?

Are they push/pull subscribers?

Did you drop replication prior to backing up/restoring?...

Good guess on my part since its extremely unlikely that it'd be a professional question like that.

Assuming you already know the basics of database design from...

Jigneshal (7/2/2012)

---

Hi,

I want to create a database for hospital management system.

but i dont have much idea to design db. Can anyone help creating db for hospital management.

It will be a...

User information is not logged in the database transaction log.

You will need to create an audit process and/or add a column to the tables to store the last modified user.

gary.morey (6/15/2012)

---

I am the only user that does inserts / updates/ deletes to the table.

All of the other users can only do SELECTs against the table....so this means that I...

You've answered your own question right here. Date, Invoice Number

Although, a date dimension doesn't normally include...

gary.morey (6/15/2012)

---

So if I am the owner of the table, can I drop it even if users are trying to query against it?

If I can't drop it in this case,...

You will want to find out exactly the procedure they took and what occurred. If its been renamed as they've changed the domain then security is likely the...

I'm guessing you want to add the feature to the already existing instance.

Even if it didn't require a service restart I wouldn't risk it. Arrange to do it during...

select sa.name, CASE sa.pre_creation_cmd WHEN 0 THEN 'None'

WHEN 1 THEN 'Drop'

WHEN 2 THEN 'Delete'

WHEN 3 THEN 'Truncate'

END

from sysarticles sa with(nolock) where sa.name = 'Table'

See this article.

http://msdn.microsoft.com/en-us/library/ms174970.aspx

Filtering is simple in replication using a where clause.

You can only use dynamic filtering in merge replication. For example

servername = hostname()