Trouble with dropping a PK, is that you will have to drop / create the FKs that relate to that PK (if any), and should look at indices as candidates...

Could it be that the service account that the sp is running under does not have permissions to the file? Try:

SET @mailattach = '\\DWAPP\InSight\Exports\Alerts\ISAlerts.csv'

DECLARE @rows int, @err int, @files int

--...

I would name the tables trx_MMYYYY as in trx_112005, we all know it is a tbl, depending on the number of rows you could also consider trx_QYYYY as in trx_42005. Easier...

Steve,

I agree The Matrix, got it as a freebee with a VHS order, ran out and bought a DVD player just to see it, best thing I have done for...

Are you using VS2003 for Enterprise Architect or VS 2005 for Enterprise Architect?

http://msdn2.microsoft.com/en-us/library/ms182014.aspx

I know it is confusing but for VS 2003, Visio is 2002 (barely supports SQL2K, no UDF, Default...

Change:

@wk1 VarChar (1), @powk1 VarChar (1)

To:

@wk1 int, @powk1 int

The error tells you that there is a datatype mismatch and from your query string these two values look numeric so...

Your issue is that you are requesting the @@IDENTITY which is not the UniqueIdentifier (NEWID()) so returns NULL, as you do not have a column in the table with an...

Actually all SQL datetime values are the same, it is the language setting or SET DATEFORMAT that changes the way it translates a datetime to/from text.

For comparison or assignment, always...

DECLARE @dt1 datetime, @dt2 datetime

SET @dt1='2004-11-28 19:30:00.917'

SET @dt2='2005-11-29 15:00:00.917'

PRINT 'With date'

SELECT @dt1, @dt2, CASE WHEN @dt1 >= @dt2 THEN 'True' ELSE 'False' END, 'Expression should be False as is not...

1) Snapshot existing data; ie. export all data from a list of defined tables

 Perform a backup of the database

 See: http://www.sqlservercentral.com/scripts/contributions/1419.asp

2) Delete all data in those tables

 DELETE or TRUNCATE all...

Thanks for the link, however RRAS on your SQL Server performing NAT, now that is a configuration I would have never attempted in the 1st place.

Andy

I am not sure what you expect, you state that you want to delete duplicate email addresses, so here you go:

IF OBJECT_ID(N'dup_emails') > 0

        DROP TABLE dbo.dup_emails

CREATE TABLE dbo.dup_emails (

username...

ISO is better:

SELECT CAST(YEAR(GETDATE()) AS varchar(4))+'0101'

Works for any SET DATEFORMAT or language setting on client or server.

Andy

I think that the fault is in REPLACE, I finally reverted to:

PRINT 'Fix leading CHAR(160)'

UPDATE MyTable

 SET Phone = NULLIF(RTRIM(LTRIM(RIGHT(Phone,LEN(Phone)-1))),'')

WHERE ASCII(Phone) = 160

I never got REPLACE to work with CHAR(160), it...

All you ever did not want to know:

http://support.microsoft.com/?LN=en-us&scid=gp%3B%5Bln%5D%3Blifecycle&x=15&y=12

Andy