Create a practice database for yourself, and put in sample inventory of things around your house (item #, price, qty ....). Think about how it should be organized. Write some...

There are 2 basic options

1) In Place Upgrade - Using the existing database, it is upgraded to a new version directly and replaces the old version.

2) Side-by-Side Upgrade - The...

http://tinyurl.com/ykwyluj

Not at all.

A well asked question often leads...

Right click jobs -> New Job -> Steps -> New -> Type: CmdExec -> Command: c:\MyFolder\Program.exe

As I recall, when creating the publication, there is a setting something like:

1) Create snapshot now

2) Create snapshot later on demand

3) Use existing snapshot files or snapshot already exists.

I...

You can create a linked server, then

insert into Server_B.Database_B.dbo.Table_A

select * from Database_A.dbo.Table_A

"...when i first start the replication, the shapshot is copy to the subscriber. after that, the shapshot will not ever be used...."

Correct, but in your first post you...

murgocimark (11/18/2009)

My first question is that this approach is correct, than:

- i know than in a replication, its recommanded than dailly to perform a snapshot replication also, for that the...

If the job is failing, you should configure it to send you an email notification.

I think failed jobs would be in job history, not backup history.

To double check your current...

You could run this to look for unused index that might be candidates for deletion. Keep in mind that the info in sys.dm_db_index_usage_stats is only accurate since the last...

Since t-log backups...

Thanks ! That was it.

Interesting ! ...

I use this to search for character strings in stored procedures:

select name, create_date, substring(definition,CHARINDEX('CharacterString', definition)-25,150) as 'Code Snippet', definition as 'Entire Code'

from sys.sql_modules com

join sys.objects obj on com.object_id...