redgate

Technical Article

RE: Backup Coming From Secret Location

  • Reply

There's a possibility that the job may have been started remotely by someone with backup rights.  The next time the job runs, you could try running sp_who2 to see where the BACKUP command originates from.

2004-09-21

Technical Article

RE: SQLXMLBulkLoad C# Issue on Insert :: URGENT HELP!

  • Reply

Yep,  that's what i got too.  The XML schema created from the ado.net dataset is not compatable with what SQLXMLBulkLoad expects.  Hard to believe that two things from microsoft would not be compatable.  A couple of things need to be yanked from the dataset schema to make it compatable.  (there was an example on some […]

You rated this post out of 5. Change rating

2004-09-16

Technical Article

RE: DTS SQL Task Trauma

  • Reply

Change your statement to  INSERT into tbl1 select * from tbl2 where export_id = @GlobalParameterVariable Then click on parameters button.   If that doesn't work, (it works on my machine), you might need to get the latest service pack.

2004-09-08

Technical Article

RE: Removing unused indexes according to execution plans

  • Reply

You could run a trace through SQL Profiler. Remember this will add overhead to the server, so do not do it on production. It might be easier to break your application into modules and create a trace on each one. Then you would have verification of what is being used. You could then run it […]

2004-08-31

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers