Try these:

http://www3.sympatico.ca/pthomsen/SMS/SMS.html

Maybe post in the MS forums?

Steve Jones

steve@dkranch.net

Wouldn't think it causes a problems, but it may. If there was some out of bounds value, then maybe the window can't be constructed completely.

I think this is an MS...

No single table restore. David is correct.

Alternatives:

If you use filegroups, you only have to restore the filegroup (somewhere). This may be helpful for large dbs.

If you made a mistake...

The server does a great job of managing resources, but it cannot rewrite the queries because it does not know the intention. There is still a need for developers to...

You can fail the package and this will a failed job message to the sqljob.

In the ActiveX script, there has to be a setting to mark the script as failed....

You always have to have a full backup as a starting point. Otherwise, how can you restore the "changes" from the log?

Haven't used it. Andy?

Steve Jones

steve@dkranch.net

I agree with Andy, use a table or other more permanent reference point.

Steve Jones

steve@dkranch.net

thanks

Steve Jones

steve@dkranch.net

What type of client? Is this a T-SQL that calls sp_start_job?

Is it DMO?

Steve Jones

steve@dkranch.net

Interesting article. You have some good ideas, but I'm not sure of their benefits. The large prefixes can create some confusion, especially with developers accessing the tables. For DBAs, I...

jgee, thanks and please feel free to use it. I'd be interested to see if it works.

phillcart - I looked at Change Manager a couple years ago at PASS and...

Not really brilliant, but this may work:

create table MyTest

(MyChar varchar( 10)

, MyChar2 varchar( 10)

, MyChar3 varchar( 10)

, MyChar4 varchar( 10)

)

go

insert MyTest select 'data1', 'data2', 'data3', 'data4'

insert MyTest select 'data1', 'data5',...

I'd use dts. you can quickly copy structures and limited data.

Steve Jones

steve@dkranch.net

I agree with Paul, however these won't help you detrmine how much more.

Steve Jones

steve@dkranch.net

You can also use profiler and get the "worst queries" by specifying those that take 2 sec, 3 sec, or whatever. This is a good place to start.

I've had decent...