Forum Replies Created
Viewing 15 posts - 16 through 30 (of 67 total)
-
RE: SQLAgentMail with Lotus Notes
I've never been able to get SQLMail to work successfully with Lotus Notes. Instead, I have had to resort to using VBScript and CDONTS to send mail.
-
RE: Separating data in table
Select servername, LEFT (alert, CHARINDEX(' on ', alert) ) as Alert, substring(alert,CHARINDEX(' on ', alert) +4,len(alert) - (CHARINDEX(' on ', alert)+3)) as AlertDate from tempTNG_Alerts -
RE: Disaster Recovery using SAN Replication
Perhaps I posted too soon ( or maybe my post removed the curse
). Our most recent test, completed this morning, worked successfully. ... -
RE: Slow UPDATE statement
any chance ARC_SG40MasterDelibere_DelibereApprovate has an INSTEAD OF trigger on it, causing seperate updates to occur?
-
RE: Converting Hexadecimal String Values to Alpha (ASCII) Strings
No loops, minimal dynamic sql
Create
table #HexToAlpha
(
recordid dec
(5,0) identity
-
RE: How To...
Check BOL for the GROUPING keyword for more details.
select
RM.fldEditedBy as 'User Login',
case Grouping(RM.fldPriorityCode)
when 0 then RM.fldPriorityCode
else 'Total' end as 'Priority',
count(datediff(day,RM.fldRequestDate,RM.fldComCanDate)) as 'Calls Resolved'
-
RE: How to update two or more table usin one Stored Procedure
create procedure usp_UpdateTables
@value varchar(50)
as
BEGIN
UPDATE table1
SET col1 = @value
UPDATE table2
SET colA = @value
END
-
RE: How To...
Try using WITH ROLLUP or WITH CUBE. That along with judicious use of the GROUPING function should produce exactly what you need.
A thorough reading of the BOL entries for the...
-
RE: Rollback SP on Error problems
The issue here is that since the view is not defined, executing the procedure results in a FATAL error. Fatal errors cause a procedure to abort processing. The definition of...
-
RE: Capacity planning script problem ....
The SQL for storing the results in a table is fairly simple; however, the implementation has some potential pitfalls.
Replace
exec (@sql) -- How to store the result of this request...
-
RE: Looking for Performance Monitoring Tools Recommendations
I've been using Spotlight on SQL Server from Quest Software for several months as my main monitoring tool. It provides some of the drill down capabilities that you are looking...
-
RE: Effects of encrypting stored procedures
Thanks for the responses.
By the way, the encryption was NOT my idea....they are vendor supplied procedures which the vendor has encrypted. (Not that it has stopped me from reading the...
-
RE: Tracking down re-compiles
The application is almost entirely sp based.
-
RE: How to Find the DTS Package Name from the Job Step GUID
the use of the Z option in the command line indicates that the command line is encrypted using SQL Server 2000 Encryption. That is why you cannot find the package...
-
RE: Implicit vs Explicit Transaction Performance
#1: For each insert with implicit transactions, the SQL Server engine creates a transaction; with explicit transactions, all inserts are wrapped in a single transaction. This can best be seen ...
Viewing 15 posts - 16 through 30 (of 67 total)