I'd like to put in a plug for a new ebook that frequent contributor Brian Kelley just published:

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Andy

http://www.sqlservercentral.com/columnists/awarren/

I dont think its that bad. Been a while since I have seen it, drawing a blank. Did you try the sp_change I posted earlier to see if it found...

Agree with Antares. What kind of problems are you having?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Im curious how your consultant configured replication to end up with bad data?

Anyway, troubleshoot it like you would any timeout. You can add a setting to the distribution agent (-outputverboselevel...

Sorry, mis-read it. Just tried again to be sure, works fine with a sql login. Are you getting past the point where you pick the source and destination servers?

Andy

http://www.sqlservercentral.com/columnists/awarren/

I think this got cross posted and I replied to the other post, but just to be sure - you can execute a query using the executeimmedate (or its similar...

Pretty easily done. Try this:

Dim oPackage As DTS.Package

Set oPackage = New DTS.Package

oPackage.LoadFromStorageFile "C:\testpackage.dts", ""

oPackage.SaveToSQLServer "eg\one", , , DTSSQLStgFlag_UseTrustedConnection

Set oPackage = Nothing

Andy

http://www.sqlservercentral.com/columnists/awarren/

Usually caused by an index rebuild, or changes to a large table.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Shahgols,

Please be patient. We do a fairly high volume of posts these days and sometimes we fall behind and/or miss a few. All of us have full time jobs too,...

Can you send the email from Outlook on the server ok? Cannot resolve might mean it cant find the address list to check it, or it could be that there...

We left the temp tables we had in place. No reason to fix something not broken. If/when I have a performance issue I always keep the table type option open....

Agree, I've got one dependency left like that it and it truly sucks. Replication is the easiest way to resolve it, the downside is that changes to the source table...

I agree its better to separate the logs. Though to me its as much for the additional redundancy than anything. The theory behind the sequential writes to the log sounds...

Agree. Or you could do a transform and try to convert the text to a meaningful number or just convert it to 0. Or get the formatting straightened out in...

I think you have to decide before you start the backup whether to append or format/init. You could trap the error and then format if you determined it was full...