Cortec,

"Log Shipping" log backups are the same as normal log backups, therefore if you re-enable your normal log backups you are depriving log shipping of backed up data that it...

This is a very annoying thing about DTS. It's tripped me up so many times.

I don't think you've done anything wrong, except assume - like I have - that...

How about an Oracle Architecture book?

Cheers,

- Mark

I'm not quite sure of your requirement, but here's code I would use:

 

set quoted_identifier off

exec sp_msForeachdb "

use  print '?'

if '?'...

0x634D206B72614D0A0D2C736472616765520A0D0A0D2

16461657268742073696874206E692065746170696369

74726170206F7420676E696F6720746F6E206D2749202

C4F4E206F73202C7372756F7920666F207373656E6973

7562206F6E2073690A0D20737261657920303220726F6

6207964616C20796C65766F6C2061206F742064656972

72616D206E656562206576616820646E6120726574686

775616420312065766168202C3534206D274920746168

742074636166206568540A0D0A0D2C6B6E61724620726

16544

Cheers,

- Mark

Steve: sorry to edit your code, but a few complaints on the formatting.

Namshub,

You can try this:

 

declare @teststr varchar(100) 

set @teststr ='ABCDEFGHIJKLMNOPQRSTUVWXYZ!@#$abcdefghijklmnopqrstuvwxyz%^&*()+=|.{[}]<>?/:"-~'';'

print @teststr

PRINT CHARINDEX(CONVERT(VARBINARY(100), 'k'), CONVERT(VARBINARY(100), @teststr))

-- To test it for all values in your string, try:

Manny,

When looking for slow performance, what I often do in the trace (DURING the slow performance period) is:

a) events: monitor just rpc complete and batch complete.

b) columns: maybe add...

Might be different fonts for Query Analyser and Enterprise Manager.

Cheers,

- Mark

You need to specify the @language parameter as being OUTPUT. In turn, when calling the procedure you have to specify OUTPUT again. No need to provide any value...

c) both

(disclaimer: either right can be nullified by any "denied" privileges, at either the group/role or user level)

Cheers,

- Mark

I would use SQL Profiler. If the front-end app is running by itself, then simply trace everything, otherwise you may need some filtering to isolate that app's actions from...

If you're thinking about retaining the PUBLIC privileges then I hope you don't still have a guest user defined in those databases.

Cheers,

- Mark

You need to pass the value 262144 (SQLDMOScript_OwnerQualify) in scripttype. See "Script Method (Table Object)" in BOL.

A T-SQL example is:

 

DECLARE @ScriptType BIGINT

SET @ScriptType...

Are you talking about Full Text Index incremental updates?

Cheers,

- Mark

sysadmin authority should be enough.

who is the owner of the backup job/s?

If you execute the backup t-sql under your own id (and/or a sysadmin id) from QA, does it run...