Nita,

Cross-database ownership chaining refers to dependant objects in separate databases being owned by the same login account (not the same database user).  It can be set after an installation or...

Here's what you can do if you ever want DTS to create a table before importing:  

After selecting the source table, click the Transform elipse to get to Column Mappings and...

Hi Evelyn,

Assuming your backups are run by scheduled jobs, the msdb.sysjobhistory table stores the information you want in it's status and run_date columns.  msdb.sp_help_jobhistory queries the table.  See 'sysjobhistory' and...

Off the top of my head, there's SQL Server's C2 auditing, SQL profiler tracing, and products for purchase like Lumigent's Entegra. 

Greg

Building on what Frank said about recovery model, if it's "Full", you can do a log backup now, restore last week's full backup with NORECOVERY, then restore the log backup with...

Hi Shoaib,

You might try using a Transform Data Task instead of an SQL Task.  You can use the same SELECT statement in the Source tab. Then on the Options tab,...

Oh yeah.  I forgot that each export is going to a different Excel file.  In that case, the easiest thing to do is create copies of the connections as I...

How about this?

--create a table with one name column and insert data

create table oldname

(name varchar (20))

insert into oldname values ('Jones,Larry/Dee')

insert into oldname values ('Smith,Gene/Wilma') 

select *...

You can use the same connections since you want your tasks to execute serially.  If you had tasks that you wanted to execute in parallel, you would use seperate connections.

To...

Tom,

The correct syntax is BACKUP LOG <dbname> WITH TRUNCATE_ONLY

Greg

sp_helprolemember will list the members of a particular role or, if you omit the role parameter, all roles in a database.  See BOL.

Greg

Sridhar,

I think rossc and I are trying to describe the same thing.  I wish I could copy an image into the message forum.  Let's try this:

Transform Task1  ---->  SQL...

Select IDENT_CURRENT will return the last identity value generated for a specific table.  I agree with Frank that you should show the newly generated ID right after the row is inserted.

Greg

Hi Sridhar,

Create a package in DTS Designer.  Add Connection objects for each source and destination to the workspace.  Add Transform Data Task between each pair of source and destination Connections. ...

You can certainly use both tasks in a single package.  Do you want to loop back and execute the same tasks again or will each Transform Data task and Execute SQL...