I run a similar process and I use an automated process that uses bcp out, bcp in, using records in a table (SourceServer varchar(100), SourceDatabase sysname, SourceTable sysname, DestinationServer varchar(100),...

If you're always using all of the index fields in your filtering, it's customary to use the field that has less options first.

i.e if I have a table with LoginLogout...

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=747

A very nice and helpful script I found here. Posted by aceandy.

Sorry Chetana, but that's all I have now. I'm just finishing the book I wrote about myself.

But, since my company pays for all of my books and exams I've took...

I have pretty much the same background as you have and I recently decided I should know more about BI.

I recommend a book called "Practical Business Intelligence with SQL Server...

I'd use this one:

declare @GroupByMinutes int

set @GroupByMinutes = 30

select UserCode, dateadd(second, -(datepart(minute, [Time])%@GroupByMinutes*60 + datepart(second, [Time])), [Time]) [Time], count(*) [Accounts_Viewed]

from (your table name)

group by UserCode, dateadd(second, -(datepart(minute, [Time])%@GroupByMinutes*60 + datepart(second,...

You have to make sure that the service user of the sql agent has permissions to run DTSrun (access to the file) and that it can connect to the local...

This procedure will let you know whether an expression/name appears anywhere on your server. Just feed it the column name you need to find.

create Proc usp_Objects_Search

 @I_String_To_Search nvarchar(4000),

 @I_Include_Script bit =...

Are the domains trusted. If the are and you still can't connect you might need to use an IP instead of computer name (you can create an alias as well).

If...

One way is to script both databases (all objects) from the SSMS and use windiff in order to spot the differences.

Adi

Having a domain user for the agent is the best practice. Just make sure it sin't a local/domain admin as you don't want people to create harmful jobs with unlimited...

Try running a regular backup log command and post the error you get.

Syntax:

backup log [your db name]

to disk = 'your backup file path'

with init, format

Adi

If you're working with sql server 2005, you might want to consider switching to sqlcmd. It's a little bit nicer then osql, but the syntax remains the same.

This exam isn't too hard for a person with a "deep knowledge in sql server 2000."

So basically, all you need to do is browse through the "What's New in SQL...