Viewing 15 posts - 7,156 through 7,170 (of 7,429 total)
Ok I know what causes this and am working on a quick fix plus reporting to Microsoft. Will post today the fix.
February 21, 2002 at 5:47 am
Ok when you execute and it gives the error does it tell you which column it was. If so look at the output data from AS400 as someone may have...
February 21, 2002 at 5:01 am
First msgbox is a bad way to output a message, I suggest using a file object and writting out to text file. The reason is a scheduled process runs in...
February 21, 2002 at 4:59 am
Another method you could use to save having a job run unnecessarily is to create a job to run your script but disable it. Then in your trigger you can...
February 21, 2002 at 4:51 am
Just a note but memory is not the only way to hang a server. The most other common problem I see is CPU utilization for extended periods of 100% usually...
February 21, 2002 at 4:27 am
Ok I will give it a wirl tomorrow and let you know what I come up with.
February 20, 2002 at 7:25 pm
I find no details on this and why it occurrs. Can you post the table CREATE statement so I can test it in my environment to see if I can...
February 20, 2002 at 6:05 pm
Ok then try. Open Enterprise Manager and and drill down thru Security and Linked Servers then right click on indy22a ADN look at it's propeties. And on the security tab...
February 20, 2002 at 5:56 pm
What is the error number. I went looking and thhe only information I find similar is for error 7355 which was taken care of with SP2 for 2k. I will...
February 20, 2002 at 5:29 pm
Unfortunately I don't have a EM here, but that I know is a schedualed package, that for some reason microsoft decided it would be best to encrypt the parameters. I...
February 20, 2002 at 3:08 pm
Actually Steve I usually get the type mismatch statement. This I usually get when I do a query of the data to smooth the data out for import and if...
February 20, 2002 at 10:32 am
Make sure the column is of the type money or smallmoney. When I do this I get output with .0000 which is standard. To get #,#00.00 I use CONVERT(VARCHAR,fldName,1) in...
February 20, 2002 at 10:26 am
Without going back to the user account beforehand we will never know. Could have been a mistake was made and revoked here account, thus when you removed and added back...
February 20, 2002 at 10:19 am
See if this doesn't do the trick. From SQL BOL:
sp_restoredbreplication
Removes replication settings if restoring a database to the non-originating server, database, or system that is otherwise not capable of running...
February 20, 2002 at 10:07 am
Another is that each instance will fight to gt the maximum memory it can and try not to give it up, unless you set a fixed amount for it to...
February 20, 2002 at 4:15 am
Viewing 15 posts - 7,156 through 7,170 (of 7,429 total)