I've never done this before, but here is a suggestion: 

1. Create the job manually, then disabled it in EM.

2. Create another step in your Saturday DTS package so that if...

SuperSocket info: (SpnRegister) : Error 1355 is not an error.  It means that SQL Server could not register an SPN with Windows. This is very common because most people don't...

Sorry, I just updated my previous post, left out the part that handles 'CD'

Here's a test senario I ran that works for the test data you provided. I changed SERVERNAME to AB1234567890123\XX because this solution depends on the old server name characteristics being...

Do you know both the old server name (source of the backup) and the new server name (target server to which the database was restored)?

If so, will a simple REPALCE...

Francis, when using the CONVERT function, I suggest you always specify an appropriate length for varchar, i.e.  SELECT CONVERT (varchar(11), getdate(), 106). Using varchar by itself is just shorthand for varchar(30)....

No, you cannot fulltext index a view.

You could try to join the view with the FT table(s). Or use an EXISTS subquery, like this:

SELECT *

  FROM vMyView

 WHERE EXISTS (SELECT...

Yuri,

Sorry about that - you are correct, expressions are not allowed in WRITETEXT. It been quite a while since I've used WRITETEXT, I didn't test that first

WRITETEXT overwrites the target column with new data. If the source data is greather than 8000 bytes long, the only way you could use WRITETEXT wuold be to concatenate several...

Jurushia,

Some of the best minds at SSC are working on your problem. However, I'd like to make a couple of suggestions. You've posted a query that references...

After using sp_addserver, you'll have to stop, then restart, SQL Server.

EXEC sp_dropserver 'yourServerName'

EXEC sp_addserver 'yourServerName', 'local'

Stop SQL Server.

Restart SQL Server.

Also, try either or both of these:

EXEC...

Maybe bmssa (I read this as BMS sa, an alternate sa account) is a server admin. In EM, double click the login id to get the properties window, then check...

Walter, are all the values more than 4 digits? If not, then you will get an error with the conversion. To be safe, you could use one of the following...

No.

"Compress pages and then truncate free space from the file" is equivalent to  dbcc shrinkfile('log_file').

dbcc shrinkfile('log_file', truncateonly) is equivalent to "Truncate free space from end of file".  No log data...

Are you using the -w switch with OSQL? The default column width is around 72 characters per column.  Try using -w 2000 (or some other number you determine is large...