Microsoft SQL Server Replication: Exception Stack Dump

*******************************************************

Computer type is AT/AT COMPATIBLE.

Current local time is Mon Sep 13 19:32:07 2004

4 Intel x86 level 15, 2389 Mhz processor(s).

Windows NT 5.0 Build 2195...

Hi Rookie,

Pls tell us what is the exact error message when you try to shrink the database. Do you restart the whole sql server after the moving?

Hi,

If the rows size is longer than 8060 bytes, update and insert will be failed, either with warning or without warning!

If the programmer...

Hi Mithrandir,

Do you debug the DTS with the message box (VBScript) to check what is the portion the DTS halted.

Don't make it complex, make sure you remove any user...

Bex,

One question. Do you declare your column datatype as varchar or datetime? If datatype is datetime, then there are definately no problem! If the answer is NO, then you need...

I am not quite agree with GilaMonster. With my method, I only convert once to varchar, but

July 22, 2004 at 4:59 am

#515635

I had shrunk the database after the delete but take no effect. As long as I know, shrink database only can be done when the the free spaces more than...

Dear Rebecca Starr,

Very easy!

Inside the instead of insert trigger, put this lines inside:

SET @DATE = CONVERT(VARCHAR(8), getdate(), 112)

Insert the date with value...

Hi Loi Tan Vo,

Try to use bcp (bulk copy). Refer to BOL for the syntacs and options (including in CSV or other...

myself,

If you really can't avoid in using variable to query, i suggest to use sp_executesql instead of direct query. Ian is correct. When you are using variable in the select...

For maintainable purpose, you can separate the action to three "class", such as insert, update and delete called by a "super-class". For example,

CREATE...

Easy and clean cut. Just modify a bit of your query like below:

SELECT CONVERT(VARCHAR, mydate, 105) AS MYNEWDATE FROM TBL1

May I know what is logical file name? Is it used to point to the physical file path as alias.

Only users with sysAdmin rights can execute xp_cmdshell from the database or job. Another method is create a windows ID and register it as a domain user and then use...

Thank you. I prefer David Burrows method - neat!