Viewing 15 posts - 1,711 through 1,725 (of 7,429 total)
In testing did you test on a server machine that is seperate from any domain controller, is not the machine you are testing from, and does not have a user/password...
June 28, 2004 at 3:09 pm
Please be carefull not to cross post or duplicate. Addiitonal comments http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=123292#bm123397
June 28, 2004 at 3:05 pm
However you could be running an instance of SQL 7 and SQL 2000 on the same box. How do you want to determine the correct file to compare with? Keep...
June 28, 2004 at 10:02 am
When you say maintaining state, exactly what are you doing. Storing variables for use in connection for retaining when session expires? Or exactly what. I have used several methods myself...
June 28, 2004 at 9:52 am
If you are using SQL 2000 or can get a SQL 2000 EM you could open the package and save as VIsual Basic file then do a search for sa...
June 28, 2004 at 9:50 am
Keep in mind that every time a match between a and b occurr you get a row for the match. SO for instance if I have data like this
A
James
Fred
Bill
B
James 1
James...
June 28, 2004 at 9:45 am
Look in the index under subqueries or search for "Subquery Fundamentals"
June 28, 2004 at 9:42 am
Don't have anything I can test with but I am assuming these are Windows Accounts not SQL accounts that are doing this. You can remove the rights to start/stop services...
June 28, 2004 at 9:40 am
Everything I have tried and seen this is the basic way of getting it done like you have it. The only thing I have seen otherwise is to build the...
June 28, 2004 at 9:34 am
The only way I know for sure of is using SQL-DMO. However I don't have an example getting that much detail at one time. Can provide a sample for scripting...
June 28, 2004 at 6:56 am
I once found a connection not visible on my DTS package sheet using "Disconnected Edit..." which is under the Package menu. Just look thru all the connections there and see...
June 28, 2004 at 6:53 am
RAND is a very poor randomizer. NEWID does a much better job using GUIDS but with regards to first 5 digits being the random value this may make a bit...
June 28, 2004 at 6:51 am
DO you get an error message? ANd have you tried connecting with QA to DB while in the DB in EM to see if it gives you issues querying the...
June 28, 2004 at 6:43 am
Overall I do believe ASP .NET has the best performance. But depends of what languages you currently are familiar with.
If VB the ASP using Server Side VBScipt
If C++ then...
June 28, 2004 at 6:24 am
Viewing 15 posts - 1,711 through 1,725 (of 7,429 total)