Viewing 15 posts - 7,261 through 7,275 (of 7,428 total)
I don't know of a way to get this from an ADO object but you can query a SQL database this way as far as 7 and 2000 go.
This will...
February 12, 2002 at 5:49 am
This will do it a hair faster and with less conversions and function calls which saves on CPU cycles.
CONVERT(VARCHAR,GETDATE(),112) + REPLACE(CONVERT(VARCHAR,GETDATE(),108),':','')
February 12, 2002 at 4:56 am
In regards to awe and if enabled what is the impact on other instances of SQL Server 2K. Here it is from books online.
It is strongly recommended that you set...
February 12, 2002 at 4:47 am
Hey bryan99y I noticed we still never actually answered your question so here it is straight from SQL Books Online.
awe enabled Option
In Microsoft® SQL Server™ 2000, you can use the...
February 12, 2002 at 4:42 am
What have you done so far and what are you trying to actually do?
February 11, 2002 at 5:18 pm
What type of connection are you setting up. NT Auth or SQL Auth?
February 11, 2002 at 5:17 pm
A good place to look thou is the MSDN website and dig thru the online MSDN library. http://msdn.microsoft.com/
February 11, 2002 at 5:08 pm
JUst a hint then as this looks like you are trying to solve on your own. Conditional testing is best done in CASE statements in SQL.
Example:
CASE
WHEN Object=This THEN OuputThisValue
WHEN Object=That...
February 11, 2002 at 5:04 pm
In regards to what Robert said.
quote:
In our database all users by default have read permissions so for us this is...
February 11, 2002 at 7:23 am
Not as detailed as I would like. Usefull but needs to be broadened a bit.
February 11, 2002 at 7:16 am
I have used both static and dynamic queries in Stored Procedures for a long time now. I tend to try to avoid dynamic since I found out tht was the...
February 11, 2002 at 6:59 am
Now from my understanding you cannot do this inside DTS but you could write a VB app to recreate the package if you needed. However even if you could or...
February 11, 2002 at 4:58 am
I would also make sure you get the fastest and largest stick per slot you can to ensure the best performance and overall upgradability if you don't plan to use...
February 11, 2002 at 4:49 am
I have found this usefull already and have been using it a while. Good article on the subject.
February 11, 2002 at 4:37 am
I found the article informative and quite helpfull. I have long been curious about the size but had no time to test this myself. Good piece of work.
February 11, 2002 at 4:29 am
Viewing 15 posts - 7,261 through 7,275 (of 7,428 total)