Forum Replies Created
Viewing 15 posts - 37,066 through 37,080 (of 39,720 total)
-
RE: Archiving tables
Not sure BCP is much faster or it's worth testing. If are are archiving, this is a one time event, correct? Does the time matter that much?
Steve Jones
-
RE: NOCOUNT
Haven't quanitified it. Not sure it is significant, but I could be wrong.
Steve Jones
-
RE: Insert Into w/ indentity col
Nothing easier. Need to include the columns.
Steve Jones
-
RE: DTS strips primary keys
What is the package? Haven't heard of anything like this.
Steve Jones
-
RE: update trigger
create trigger mytrigger for update on Mytable as
if update (columnA)
begin
update TableB
set x = y
...
-
RE: Hash encryption
Pls don't cross post
Steve Jones
-
RE: Hash encryption
Yes there are one way hashes. MD5 is well known and here are some implementaitons. No SQL yet
http://userpages.umbc.edu/~mabzug1/cs/md5/md5.html
Steve Jones
-
RE: SQL7\NT Auth and Agent Jobs
Haven't seen this.
Have had some issues with BMC Patrol and it reporting sysadmin problems when the account is a system admin. No resolution as of yet.
Steve Jones
-
RE: Start up MSSQLServer
Also check the Event Viewer for the server.
Steve Jones
-
RE: Need Info for a presentation
What type of information do you need? Usually diagrams are better for showing relationships.
With Visio you can reverse engineer and then add labels. Helps to have a plotter to use.
Steve...
-
RE: Hash encryption
don't have a solution here. You could implement it using any algorithm, but the key management will be the weak link. You'd have to store it somewhere.
Check Google, or...
-
RE: How to post a pic?
When you hit the button above, you should get "
". In here you need the URL to the image. If it's not on another web server, then email...
-
RE: UnKillable Locks
Crazy. Got a couple bad bugs here myself. Not sure what to tell you. IS the issue an insert/update/delete or a select?
Steve Jones
-
RE: Timeout
Is VB redialing the modem? Sounds like more of a network than a SQL issue or am I missing something?
Steve Jones
Viewing 15 posts - 37,066 through 37,080 (of 39,720 total)