Viewing 15 posts - 5,596 through 5,610 (of 7,429 total)
Back to your original question on TCP/IP when you get to the secound screen to setup authentication type there is a CLient Config button on the screen. Press it and...
June 4, 2002 at 5:01 pm
This is usually when I suggest stomp your vendor with the give me the details of what you are talking about. The current MDAC with XP supports fully connecting to...
June 4, 2002 at 4:52 pm
Right, unless I forgot some key element but I never get asked to login on the 1 site I have it setup thast way on.
"Don't roll your eyes at me....
June 4, 2002 at 3:05 pm
Is ID indexed, if not the do so, and if this is the most commonly use column for queries make clustered. Then see if that relieves the issue. However as...
June 4, 2002 at 3:03 pm
Too many variable to do this in TSQL as the column will have to be added and the old dropped to create a Column defined as IDENTITY(1,1) and PRIMARY KEY....
June 4, 2002 at 11:51 am
Take a look here http://www.asp101.com/articles/carvin/dts/default.asp should help.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 4, 2002 at 11:13 am
You should be able to add back but it may have some effect on the current data especially if the field has any nulls and the PK is clustered index....
June 4, 2002 at 10:36 am
You might try sp_updatestats and look at DBCC DBREINDEX (SQL 7) or DBCC INDEXDEFRAG (SQL2K) and DBCC UPDATEUSAGE. May have some maintainence issues.
"Don't roll your eyes at me. I will...
June 4, 2002 at 9:55 am
The method you are trying to use will not persist and use a trusted connection. When you use a trusted connection you will not need to pass the username or...
June 4, 2002 at 7:42 am
You can't without many variables and unions to join them when done or doing as I suggested with the temp table to summarize the data. I only suggest use a...
June 4, 2002 at 6:13 am
I would be curious to know if there is anything like this. However, I don't believe there is unless a third party company has found a way to hook the...
June 4, 2002 at 5:30 am
Try stoping and closing the trace
exec sp_trace_setstatus @TraceID, 0
exec sp_trace_setstatus @TraceID, 2
and see if the output doesn't dump then. I tested and code works fine for me. But I believe...
June 4, 2002 at 5:27 am
I am not sure you can do this thru ALTER TABLE and generally I do it thru EM as if their on constraints and permissions it will take care of...
June 4, 2002 at 5:07 am
But that is only if you have auto create statistics turned on in DB options. But I do agree you really shoul leave as is. They bennifit you in query...
June 4, 2002 at 4:54 am
The problem with this is how do you decide which way to slide. You have to lay a set of ground rules to say when to roll up or down...
June 3, 2002 at 8:13 pm
Viewing 15 posts - 5,596 through 5,610 (of 7,429 total)