Once you save the maintenance plan, open it again by double clicking it. You will get a "toolbox" in the lower left.

The History Cleanup task deletes meta data in the...

How is it updating? Is it doing a transformation? Is it an Execute SQL task? You haven't really explained how it works.

If it's just using SQL, why not use a...

Don't think the above will move the mdf. Will get the data and objects out, but system tables, metadata, etc. are stuck until you detach/attach.

CAST is not a translater. Meaning if you have a Japanese kanji character in Unicode, SQL Server has no way to CAST that to varchar. You're asking to somehow translate...

You would need some application to query the database and then stream the image data and view it. These are just bits to SQL Server, it has no idea how...

Richard,

Nice editorial and that's a very interesting SQL product. There are lots of interesting applications for a product just like this and I wish Dr. Hipp the best of luck.

It...

You'd need to post more information about what you are doing or what the code is.

There could be any number of problems. If you run Profiler with your login credentials,...

It's a security issue with the accounts on Server 3. It could be your SPN isn't correct on that server or there's a timing issue (kerberos is used).

http://www.google.com/url?sa=t&ct=res&cd=1&url=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F811889&ei=tbtcR5GZG5TiiAGKn-z-Dw&usg=AFQjCNG2tTrJFOIYpo4EZa9v3b4WNAS_6w&sig2=514i745fU9eHOSD4kRnePw

http://www.google.com/url?sa=t&ct=res&cd=2&url=http%3A%2F%2Fwww.sqlservercentral.com%2Farticles%2FInstallation%2Fcannotgeneratesspicontext%2F929%2F&ei=tbtcR5GZG5TiiAGKn-z-Dw&usg=AFQjCNGps3wNFPmXQU-u9vxb-2ULrFnh7A&sig2=oCWspssnEe-b2WSKSogFFA

You need to read up on replication in books online to understand what it is and if it will meet your needs.

With snapshot replication, you'd move the entire database...

You can do a partitioned table or partitioned view that will help here. Look these up in books online and be sure you set the security the same on both...

Which database maintenance script? The maintenance plan wizard? The maintenance plan designer. There is a task (maintenance cleanup) to handle this.

Have you rebooted? I've seen this where the plan gets booted for some reason and then dies. I haven't seen a good way to fix this. Hints can help at...

Lowell has a good idea. You could do a backup /restore (with NORECOVERY), then copy logs, repeat until you're only 1 minute behind. Then backup the tail, restore, detach the...

I think you mean sp_who.

What does the DTS package do? More information would help.

This is a cross tab query.

You need to do something like.

select a.name

, b.name

, c.name

from Mytable a

inner join myTable b

inner...