Viewing 15 posts - 1 through 15 (of 85 total)
We have ActiveX scripts through out all our DTS packages. I am not sure your solution would help in this instance?
January 18, 2006 at 11:35 am
In my script below replace P with U this will give you user objects and the P will give you stored procedures.
January 18, 2006 at 10:01 am
You can write a script to produce the a script to execute.
Try somehting along the lines of this:
when xtype = 'P' then 'Truncate ['
+ o.name +...
January 18, 2006 at 9:58 am
I have applied the hot fix and it corrected my production issues, but I still see SPIDS Blocking themselves.
I never noticed this pre SP4. Should I still keep looking into...
June 22, 2005 at 2:24 pm
Can you post the hot fixes? I am desperate.
June 16, 2005 at 9:13 am
I have encountered this same error today, but I do not have over 200 columns I only have 19. I do not know what the root cause can be, I...
March 23, 2005 at 3:04 pm
Some questions on your article.
If you create a generic SQL ID for the developers, how do you know who changed what.
Now that they all have the same ID. It makes...
February 4, 2005 at 10:00 am
One great Tool!!!
January 13, 2005 at 1:01 pm
It is an ever changing world!
December 14, 2004 at 12:03 pm
This last time that is exaclty how it happend to me. I changed my domain password, and they were gone. I would figure it would be part of the profile,...
July 31, 2003 at 2:01 pm
I appreciate the code. I was looking for a way to do this for a large number of columns. I have over a hundred columns in the table and...
May 19, 2003 at 10:24 am
So the insert is a transaction and the SP notices the open tran and aborts?
Is the work around to edit the sp itself and modify the trancount value?
March 26, 2003 at 7:10 am
Thanks Brian! -jG
December 18, 2002 at 12:40 pm
It does perform the copy. And the file size is the same. Something is not being passed becaused I used the coiped bak file and it will not restore properly...
September 23, 2002 at 8:34 am
One other thing you can do is on the configuration of the database. SQL Server can do mulitprocessing if the data is located accross mulitple filegroups.
If the computer has multiple...
April 26, 2002 at 10:44 am