Forum Replies Created
Viewing 15 posts - 37,936 through 37,950 (of 39,720 total)
-
RE: Ideal Set-Up
got some itchy fingers on the laptop today
.I tend to use RAID 1 for logs, RAID 5 for data as a general rule, but I'm budget...
-
RE: SQLServerAgent mail
Basically SQL Mail runs under the account that is setup for MSSQLServer in the control panel | services.
You can check here for some references:
http://www.sqlservercentral.com/columnists/sjones/sqlmailresources.asp
Steve Jones
-
RE: XACT_ABORT
Can you post some code. Is @@error not set for the caller of the transaction?
Steve Jones
-
RE: Help selecting rows based on a date value.
Try a where clause that does not return rows that are 6 pending when the time is greater than the time in table b (3rd responded)
Steve Jones
-
RE: DTS
It sounds like your installation is not correct. Has this ever worked? If so, what has changed on your machine?
Steve Jones
-
RE: Ideal Set-Up
Ideal? this is tough without knowing what you are trying to do. What is smooth? High Availability: try clustering. Data Integrity: Need a good design and good application programming. Good...
-
RE: Encrypting data in a column of a SQL Server 7 Appl
There are products that will do this. We have one in our "Products" section. If this is only needed for compare, like a password, you can use the encrypt() function...
-
RE: How do I get row 101-200 from a table?
is the top 100 ordered? If so, then add a where clause that is > than the value in row 100.
Steve Jones
-
RE: Data Cleansing
Glad I could help. Be interested to hear how it goes. You can post or email me (sjones@sqlservercentral.com)
Steve Jones
-
RE: Backing up to different server
The backup runs under the context of the server account. So only drives that are mapped for that account, not your acccount, will appear.
You should be able to use a...
-
RE: Data Cleansing
This is really hard to answer unless you can give us some idea of what type of cleansing you need to do.
I normally import things into SQL and then spend...
.Viewing 15 posts - 37,936 through 37,950 (of 39,720 total)