Viewing 15 posts - 3,496 through 3,510 (of 6,216 total)
Its out of scope. You can use sp_executesql and do a bit of tricky code to return an output parameter (sample code somewhere here on the site!),or you can write...
August 12, 2002 at 5:10 pm
Havent used BizTalk. Looks interesting, but its a v1 product:-) DTS is...interesting. Im not an advanced DTS user myself, typically I'll build a package using the designer and then if...
August 12, 2002 at 7:17 am
Its worth doing, even if you just install on your workstation and dont have a full test environment. The more you test across more hardware/software combo's, less chance of a...
August 12, 2002 at 7:15 am
August 12, 2002 at 7:02 am
I'd look for instances where deny has been implemented. Probably have them in more than one role.
Andy
August 10, 2002 at 5:13 pm
Should work, no you don't need to create the files first. In this case looks like you've got the files in the wrong place...or in the right place and you...
August 10, 2002 at 6:12 am
There may be a way, I just don't know what it is. Let me know if you find out. One hack would be to convert the date to a varchar...
August 10, 2002 at 6:09 am
Dont use them often so I'd have to check to be sure, but I'd bet the problem lies with the recordset type. You're taking the defaults, which I "think" are...
August 10, 2002 at 5:58 am
How much load it puts on the system? I dont have numbers, but overall its pretty lightweight as long as you dont profile everything:-)
Andy
August 9, 2002 at 3:21 pm
August 9, 2002 at 3:20 pm
You could pattern match for any alpha char and punctuation. Not 100% coverage, but close. What do you do when you can't convert it?
Andy
August 9, 2002 at 12:32 pm
I agree 30 isnt a lot, but it can grow over time. I just use a naming convention, usp_tablename_whatdoes it do for access procs, usp_group_whatdoesitdo for specialized stuff. There is...
August 9, 2002 at 12:30 pm
Not easily done. You'd have to modify the system procs that handle it. Alternatively you could run a tool that tries to crack the password, if it does, make them...
August 9, 2002 at 12:28 pm
Profile while the report runs, see what its doing.
Andy
August 9, 2002 at 12:26 pm
That does. Deleting a row has a cost, every index (and pkey is really an index) adds to that. Just the nature of indexes. Unless you have a lot of...
August 9, 2002 at 10:07 am
Viewing 15 posts - 3,496 through 3,510 (of 6,216 total)