Viewing 15 posts - 136 through 150 (of 158 total)
Hi,
Are you modifying the SP's via EM? If so drop and create the SP with QA it will work if you set the ANSI settings there.
If it aint broke don't...
November 25, 2003 at 2:23 am
Hi,
Can you describe the Oracle Table or send me the data types of the columns.
If it aint broke don't fix it!
November 24, 2003 at 6:31 am
Hey Jonathan - You beat me to it! - Anyway yours is better - less code!
If it aint broke don't fix it!
November 24, 2003 at 6:07 am
Try this
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'CREDIT_CHECK' AND type = 'TR')
DROP TRIGGER CREDIT_CHECK
GO
CREATE TRIGGER CREDIT_CHECK
ON Customers
FOR INSERT, UPDATE
AS
BEGIN...
November 24, 2003 at 6:04 am
Hi,
Have you had any luck yet? Sometimes changing the query to openquery helps.
If it aint broke don't fix it!
November 24, 2003 at 5:11 am
Hi
RTM = Shipping version of SQL Server with no service packs.
You should load Service pack 3a.
If it aint broke don't fix it!
November 19, 2003 at 4:04 am
Hi,
I have had this problem before and the solution was to create the procedure from QA not EM.
Do you have to create the proc from DTS? Could you not call...
November 19, 2003 at 3:51 am
Och! Aye!
I wish ur a verra mickel SQL gura!
If it aint broke don't fix it!
November 17, 2003 at 10:46 pm
Hi,
My method of automating the moving of SQL 2K DTS packages might not be the best way but it works for me. I inherited servers where the developers used hundreds...
November 10, 2003 at 11:43 pm
Hi,
I had this problem as well and the solution was simple. Set the ANSI settings and create the proc from Query Analyser not from EM.
If it aint broke don't fix...
November 10, 2003 at 6:01 am
Hi,
I dont' know is this is a good idea but what about creating a trigger on the sysdatabases table in the Master Database...
If it aint broke don't fix it!
November 10, 2003 at 5:30 am
and whatever you do make sure that you monitor over the month end. Sometimes a proc lays dormant until the new month.
If it aint broke don't fix it!
October 31, 2003 at 1:05 am
You are correct. I must have been smoking my socks....
If it aint broke don't fix it!
October 31, 2003 at 12:53 am
Here is my humble offering
The connection string must contain pooling = true and min connections and max connections
Does the connection string explicitly state these properties as pooling is set as...
October 27, 2003 at 3:22 am
Look up on BOL for
sp_resetstatus & DBCC DBRECOVER (database)
If it aint broke don't fix it!
October 26, 2003 at 10:58 pm
Viewing 15 posts - 136 through 150 (of 158 total)