Viewing 15 posts - 3,226 through 3,240 (of 7,429 total)
It would help to know the table structure to see if anything else can a better choice. Also what items are common for selections and I do agree your fill...
March 12, 2003 at 5:25 pm
The rest of the message should read like this
Could not locate file 'jvlk_0100Log' in sysfiles.
Verify you spelled the name right by running
select [name] from sysfiles
March 12, 2003 at 4:22 am
What error are you receiving? And have you made sure the IIS 5 server is up to date with the proper MDAC?
March 12, 2003 at 4:12 am
Also, take into consideration storage size. INT is 8 bytes where Uniqueidentifier is 16 so makes indexes and references bigger in size.
March 11, 2003 at 10:10 am
To the best of my knowledge I have not come across sql function to do so.
What specifically is your goal however as there may be some option I have not...
March 11, 2003 at 4:14 am
In this situation the answer is No. You could try exporting to a flat file and use bcp to bulk copy the data in, it produces less transactions but may...
March 11, 2003 at 4:09 am
quote:
Regarding this discussion, anyone have any comments on my thoughts regarding this not being a performance issue, but rather an issue of...
March 10, 2003 at 4:29 am
What I would do and have been doing is store the string in encypted text using 3DES with CAPICOM.dll from MS which is free. The reason for not storing easy...
March 10, 2003 at 4:21 am
I would suggest from a backup standpoint give a look to SQLZip (http://www.sqlzip.com/) or SQLLiteSpeed (http://www.sqllitespeed.com/slsdefault.asp). The compressed backup so you can have local is great. And SQLLiteSpeed offers backup...
March 10, 2003 at 3:58 am
Can you be more descriptive of what you want to know and where we can find spt_values?
March 10, 2003 at 3:48 am
It is a date value that is updated when the password is changed. Where did you find this out Andy as I must have missed that thread and I know...
March 10, 2003 at 3:46 am
Grasch can you please walk us thru the logic and what the data layout will look like so we can get a better idea of your vision.
March 8, 2003 at 7:06 pm
Depedns on the amount of data that would be stored and any specific limitations that MSDE would impose that would be a problem. If MSDE suits your needs then why...
March 8, 2003 at 7:04 pm
Did you make any changes to the server recently. Account permission for the account SQL is running under if not System Account, or maybe IP address change something unusual?
March 7, 2003 at 6:11 pm
Yep sounds like something has already opened Port 1433 on the server. Do you have multiple instances of SQL installed. There is a way to see
open a command prompt...
March 7, 2003 at 2:55 pm
Viewing 15 posts - 3,226 through 3,240 (of 7,429 total)