Forum Replies Created
Viewing 15 posts - 37,171 through 37,185 (of 39,818 total)
-
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
-
RE: Counting the number of columns in a row
Load into a dummy table and then move it for rows that have enough non-NULL values?
Steve Jones
-
RE: DTS Function
You could using VB or C++, but sure it's more efficient.
2 thoughts. Parse the file first and "fix" the data, or load it and fix it using SQL.
Steve Jones
-
RE: SQLMail
Not a cluster person, but I know there are issues with SQLMail on clusters. If no one responds here, I suspect you will need to call MS.
Steve Jones
-
RE: Net-Libraries
These are the connection "types" that SQL Server uses. They are DLLs and are "loaded" by SQL Server if you have enabled them. So if your client software is set...
-
RE: UnKillable Locks
Not sure that will help. Is the database in 2k mode or 65 mode?
I suspect that the application is doing something funny. Can you trace it and replay the trace...
-
RE: The DBA Dot Com Bust
Those are mostly administrative tasks for a DBA. You should be controlling the server, patching it with MS patches( after testing), as well as what you mentioned.
Performance tuning can be...
-
RE: The Dot Com Bust - Part 2
Thanks for the comments and interesting stories. Hopefully things will turn around all over soon.
As far as DBA v Developer/Programmer. In my experience, most developers are ignorant about good database...
Viewing 15 posts - 37,171 through 37,185 (of 39,818 total)