Viewing 15 posts - 5,941 through 5,955 (of 7,429 total)
The easiest way I know of without holding a cursor open during the process (ADO implemented cursor) is to use an IDENTITY column or a unique value column that you...
May 13, 2002 at 5:38 am
Every process and sp need to create and run traces can only be Executed by the sysadmin fixed role. As stated here by DBCC TRACEON
May 13, 2002 at 4:49 am
Did you check the transformation to see what it is mapping to? Also have seen statements made when the column has other types of data inside it, are any other...
May 13, 2002 at 4:43 am
If you want SQL to send it then you can use xp_sendmail. If you will send via ASP page then do as a select to return the data from SP.
In...
May 13, 2002 at 4:41 am
Also to verify the trigger state this will help.
SELECT OBJECT_NAME(parent_obj) tablename, [name] triggername, (CASE WHEN (STATUS & 2048) = 2048 THEN 'Disabled' ELSE 'Enabled' END) state FROM sysobjects WHERE xtype...
May 12, 2002 at 7:32 pm
This has been asked about on two other occasions and this was what cam of that. See thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=2708&FORUM_ID=48&CAT_ID=1&Forum_Title=Service+Packs&Topic_Title=SQL+2000+SP+2+and+sendmail
"Don't roll your eyes at me. I will tape them in place."...
May 12, 2002 at 9:15 am
Not sure they have a problem with letting people know what they do as you can find a few not documented in BOL on the KB site. More likely they...
May 12, 2002 at 9:07 am
The only problem with Exists is the way exists works and the fact he wanted to may sure exists with each possible non just any one possibility. The reason MS...
May 11, 2002 at 7:33 pm
I understand, you may do this but I do suggest make sure you have a 7 EM running some where to check without version conflicts in the way when you...
May 11, 2002 at 7:24 pm
I got to say great pointing out the undocumented SP, will have to check it out a bit myself.
"Don't roll your eyes at me. I will tape them in place."...
May 11, 2002 at 7:19 pm
Andy does hit some great extra points there especially if you have multiple IIS and/or SQL server serving the data. Ultimately still boils done to the most convient way to...
May 11, 2002 at 7:14 pm
In that case it really would be up to you. Sorry no help there but this runs into how much trouble is it to do the DB store or should...
May 11, 2002 at 10:55 am
I would continue with the same statement I made before.
DB if App hitting DB direct and no IIS server involved with same data not in DB.
FileSystem if ASP based...
May 11, 2002 at 10:45 am
Any features that were not available in SQL 7 DTS that were added in 2000 will not execute on SQL 7. In addition I would personally not install the 2000...
May 11, 2002 at 10:39 am
Or use EM to make that step easier to see what to do. But learn the BACKUP DATABASE method just so you understand what is happening.
"Don't roll your eyes at...
May 11, 2002 at 10:35 am
Viewing 15 posts - 5,941 through 5,955 (of 7,429 total)