I ran this query on about 10 randomly chosen servers in our shop, and I got 218 records in a result set.

SELECT s.name ,

...

Hmm... indeed. I also found that all type, description columns in sys... views have Latin1_General_CI_AS_KS_WS collation. I don't understand why Microsoft did it, to complicate our queries.

Very raw script. No explanations what I must pass in @path and @BACKUPPARH parameters. And what if I have multiple data files with .ndf?

Do you have 'with recovery'?

24 hours? Your database must be well over 1 TB or your hardware is very outdated.

If you compress backup, try to estimate its size + 20%, make sure that you...

What is data type, length, and number of columns?

How intensively it is used - from sys.dm_db_index_usage_stats ?

Active Service Pages

Application Service Provider

Also googled:

Appalachia Service Project

Association of Software Professionals

Advanced Sterilization Products

Advanced Study Program

Associate...

Ah, if I understand right, you are in US army deployed in Afghanistan?

And the local agencies they are local to Afghanistan or to your home state in US?

And just...

It will make sense if the files belonging to these FGs are placed on separate physical drives and you have a lot of queries between fact tables. In this case...

Lynn, what happens if your job has finished/end of contract and you are starting another search, but none of four agencies in your circle have any SQL Server openings at...

Try this:

select name, data_source

from sys.servers

where server_id = 0

Are both columns equal to each other and equal to @@servername?

Thanks Jason, that's good article. I was able to add a table to replication even though my subscription was initially synchronized from a backup, not snapshot.

Thanks all.

Just another question. I initialize replication with backup/restore. After restoring to subscriber, should I change subscription database to Simple recovery?

Yes I tried TRY/CATCH:

BEGIN TRY

< ...my code...>

END TRY

...

Loner:

Do you remember the question? Can you post it here? Each of us will try to solve it and see how many minutes it took. Maybe for some even 60.

Try to pass 1 (not equal) instead of 7 (not like)