Viewing 15 posts - 871 through 885 (of 7,429 total)
To the best of my knowledg there is no way within SQL to do as you request. You might coul use SQL-DMO in mayb VBScript to open/change and save the...
May 5, 2006 at 7:45 am
Before I suggest anything since I don't play with Progress, what happens to the string if a comment has a ; (semicolon) in it?
May 5, 2006 at 7:16 am
1) My opinion, the point of an SP is to protect the underlying table from direct access. Using dynamic SQL will require you to give select permssions on the table...
May 5, 2006 at 7:07 am
Got to thinkin earlier and remembered an odd case when we moved a database from SQL 7 to SQL 2000. Was this database moved such? In SQL 7 there was...
May 4, 2006 at 8:02 pm
If you solved by changing the username/password you were using to something not on the second machine it sounds to me like you have create a bad routing somewhere that...
May 4, 2006 at 2:37 pm
It depends, could just be a pooled connection. To see if you have a leak, run the process multiple times. If a new connection is created and left sleeping the...
May 4, 2006 at 10:45 am
Just occurred to me you said 3 drives. If you want any kind of fault tolerence you have two options (if supported)
1 RAID 5 - If you want complete fault...
May 4, 2006 at 10:39 am
No I think you missunderstood me. Hard work and loyalty are the greatest assets a person can have especially if they fit in with the team. My point (at least...
May 4, 2006 at 10:33 am
OK he might have a bit of a point if the person is young, but it is still your call. I find resumes to be the worst thing to try...
May 4, 2006 at 8:57 am
Have you tired using the server name instead of the ip 10.0.1.218 ?
May 4, 2006 at 8:53 am
Can you post an example of one of the SPs (simplest one doing this preferred).
May 4, 2006 at 8:49 am
You can always create the objects whith the owner schema set explicit.
CREATE FUNCTION dbo.GetGMT(...
But yes for you to use the function you will have to use the two part name
[schema...
May 4, 2006 at 8:43 am
You are always better creating seperate drive arrays. s before most peopl stick with mirroring for OS and Bootable partition as C, Applications an executable Binaries are still common to...
May 4, 2006 at 6:13 am
It also is used for large scale joins and other large set routines. tempDb is the system scratchpad for many actions.
May 4, 2006 at 6:05 am
Viewing 15 posts - 871 through 885 (of 7,429 total)