Forum Replies Created
Viewing 15 posts - 37,666 through 37,680 (of 39,456 total)
-
RE: Point in Time Restore in SQL Server 2K
Haven't tried this, but since you have a partial log, I'd doubt you can do this.
Steve Jones
-
RE: orphaned spids
Are you sure these are orphaned? Are there still sessions running on Citrix? You can disconnect and your session on Citrix wouls stay open, so your connection would be open....
-
RE: Cursors or not
Great information above and some good points. Something else to consider, there are some business processes that are better not performed in SQL. The server is a limited resource and...
-
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...
.Viewing 15 posts - 37,666 through 37,680 (of 39,456 total)