Viewing 7 posts - 1 through 7 (of 7 total)
For proper/full functionality for sqlserver 2000 you must update sqlserver sp3 to work with win2003.
Shamshad Ali.
October 13, 2003 at 4:59 am
I have a same situation, I am using my home pc for sending mail alerts, It is working fine without any problem, I have SQL Professional, win2k professional with Office...
September 25, 2003 at 11:56 pm
Two special tables are used in trigger statements: the deleted table and the inserted table. SQL Server automatically creates and manages these tables. You can use these temporary, memory-resident tables...
June 25, 2003 at 12:55 am
Run the following while you are in ur recovered database.
sp_change_users_login 'auto_fix',user
Try this.
Shamshad Ali.
June 22, 2003 at 11:21 pm
create proc shortHTMLemails
as
CREATE TABLE [dbo].[tblHTML] (field1 int IDENTITY (1, 1) NOT NULL ,txt varchar(8000) )
DBCC CHECKIDENT (tblHTML, RESEED, 1)
insert into tblHTML values('<html><head></head><body><table border=0 cellspacing=1 width=800><tr><td bgcolor=#DDDDFF><div align=center><table...
April 22, 2003 at 6:42 am
I got the same problem and afterall i got this as my own solution of that problem.
Create a temp table and put one column in it with varchar 8000,...
April 21, 2003 at 6:14 am
Viewing 7 posts - 1 through 7 (of 7 total)