Viewing 15 posts - 6,451 through 6,465 (of 7,429 total)
Great to hear you have a working possibility.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 10, 2002 at 6:05 pm
SQL loves memory, we have various servers with various memory, on our gig machine it site 70-80% RAM most of the time. It dynamically allocates the memory by default and...
April 10, 2002 at 6:03 pm
I agree with Andy, doesn't sound like the named pipes protocol. Are the database very large? If so it is most likely what ANdy states.
"Don't roll your eyes at me....
April 10, 2002 at 5:51 pm
Their default is defined in their login in SQL Server. When you say the first database, what exactly do you mean and when is it happening?
"Don't roll your eyes at...
April 10, 2002 at 5:49 pm
quote:
Also, how do you guys feel about separating the data and index files into separate filegroups for performance reasons? The production database...
April 10, 2002 at 11:46 am
SQLInstance.Login.SetPassword(OldPassword As String, NewPassword As String)
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 10, 2002 at 5:41 am
Could be related to your original problem see MS KB Article http://support.microsoft.com/default.aspx?scid=kb;en-us;Q254759 but the last ideas will not work with SQL 7 and ASP.
"Don't roll your eyes at me. I...
April 10, 2002 at 5:33 am
At this point I would ahve to say NIC as the errors are clearly networking related.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...
April 10, 2002 at 4:55 am
There is an available encryption in SQL but it is known that it can be circumvented and is hard to impliment. I suggest if you want a key based easy...
April 10, 2002 at 4:54 am
In SQL 7 drill to "Data Transformation Services"
Right click the folder and choose All Tasks then Open Package. This bring up a "Select Package" dialog to select and open the...
April 10, 2002 at 4:46 am
See MS KB Article "INFO: COM+ and MTS Always Use SERIALIZABLE Transaction Isolation Level (Q215520)" http://support.microsoft.com/default.aspx?scid=kb;en-us;Q215520
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...
April 10, 2002 at 4:32 am
I am afraid that yes that would be the only choice I can see. And would have to parse those on the Access side. I will see if there is...
April 9, 2002 at 5:37 pm
If you are setting up the connection via code the you can do a state check. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprostate.asp for more details.
"Don't roll your eyes at me. I will tape them...
April 9, 2002 at 5:35 pm
No, you have to declare the type explicitly, no function to do it like %type did for you.
"Don't roll your eyes at me. I will tape them in place." (Teacher...
April 9, 2002 at 5:19 pm
Set up multiple variables and set each to a section of code then do
EXEC (@SQLBase + @P1 + @P2)
You can have multiple 8000 character varchars at one time.
"Don't roll your...
April 9, 2002 at 5:13 pm
Viewing 15 posts - 6,451 through 6,465 (of 7,429 total)