Viewing 15 posts - 5,176 through 5,190 (of 7,429 total)
The auto industry is just as bad. But as for Microsoft, I personally do not full like or trust MS even thou I like a lot of the products produced...
July 18, 2002 at 6:06 am
I do not believe so.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 18, 2002 at 5:37 am
I have to find the example but when I say properly done I meant the way you initialize the COM object. Or you may have a COM object that is...
July 17, 2002 at 8:55 pm
DId you try sp_change_users_login with the auto_fix action? Or what did you do exactly?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 17, 2002 at 8:43 pm
This has been discussed in a few threads but them seemed to help most. Check out http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3538&FORUM_ID=5&CAT_ID=1&Topic_Title=Restored%20db%20still%20shows%20as
"Don't roll your eyes at me. I will tape them in place." (Teacher on...
July 17, 2002 at 8:40 pm
The key to views are their reusability and the simplification of maajor complex queries. However if a view does not represent a query that is reusuable for more than a...
July 17, 2002 at 8:32 pm
I will have to find the article but here is what I remember.
With TOP N all rows in the query are processed first and then only the first N...
July 17, 2002 at 4:04 pm
Can you post the query you run against AS400 and the SQL with Openquery? Also do you get a successfull completetion or an error message?
"Don't roll your eyes at me....
July 17, 2002 at 3:53 pm
It depends on where the other copies are. Remember if Windows does not find an item on the path called from it goes C:\, then C:\WinNT, then C:\WinNT\System32 and a...
July 17, 2002 at 3:51 pm
I beleivbe there is a RecordsAffected object in the ADO connector which if all you do is run an Update and it is not an SP with SET NOCOUNT ON...
July 17, 2002 at 3:48 pm
I beleive David is going for the dynamic SQL version of this which is common to do when you want to change items in the Query to the linked server.
Doing
declare...
July 17, 2002 at 3:35 pm
Also found the size was off when we tested a DB upgrade from 7 to 2000 in the way of indexes. They got larger on one of our test and...
July 17, 2002 at 3:28 pm
Usually for search sets I use ado cursors myself and set pages with 50 rows each. However Steve's suggestion will accomplish in round trips the same but memory load will...
July 17, 2002 at 1:37 pm
The only other time I have ever seens this is when restoring a database from backup or attaching a db. If this occurrs regularly at specific times then run Profiler...
July 17, 2002 at 11:28 am
AppName is not required, I personally choose to use it so I can identify what website or application is connecting. This gives me more detail when troubleshooting issues. As for...
July 17, 2002 at 11:19 am
Viewing 15 posts - 5,176 through 5,190 (of 7,429 total)