Viewing 12 posts - 76 through 87 (of 87 total)
Thanks alot for th replys.
I guess I found the answer.Please refer to the link
http://technet.microsoft.com/en-us/library/ms180068.aspx
but How can I give this permission(Connecting to intigration Services) to a user
October 26, 2009 at 1:31 pm
Thx for reply,But the SQL Server is on "SQL SERVER and Windows Authentication mode",but still I can chnage it during connecting to Integration Services.
October 26, 2009 at 9:13 am
well,base on my research it seems that sql server 2000,use autoval field for keeping Identity Increment & Identity Seed information.Unfortunetly I can not find proper value for this field, and...
December 31, 2008 at 1:23 pm
I am working in SQL SERVER 2000,Because we do not have access to system tables,so I thought I have put in wrong forum,causer of that I add it here
December 31, 2008 at 1:04 pm
we want to take out the Identity property in a large table for a project,which we do not have any problem with that.The problem is that,in case that we need...
December 31, 2008 at 12:35 pm
No,My question was that,when you create an identity field in a table,How SQL SERVER handles it?Where does it keep the latest value for that field?Does SQL SERVER only use...
December 31, 2008 at 10:31 am
but the problem is that,the speed is very important for my operation.if I use a new table and then transfer the data,it takes a long time cause of large amount...
December 29, 2008 at 1:06 pm
I am using SQL SERVER 2000,Which it seems that it does not have "Top" feature in Delete and UpDate operation.
Thanks
November 6, 2008 at 10:01 am
Thanks for the reply,
But when I try to run the query it said:
Msg 156, Level 15, State 1, Line 14
Incorrect syntax near the keyword 'top'.
It seems that I can not...
November 5, 2008 at 1:11 pm
No,
when I did DBCC showConfig,
This was the result:
DBCC SHOWCONTIG scanning 'TimeAndSale' table...
Table: 'TimeAndSale' (1842105603); index ID: 1, database ID: 6
TABLE level scan performed.
- Pages Scanned................................: 78514854
- Extents Scanned..............................: 9912016
- Extent...
November 4, 2008 at 4:38 pm
and also I have to add that the table has 1bilion records
November 4, 2008 at 9:08 am
Actually,It is trying to return only one record.my table has clustered index and by checking the execution plan,it is using Clustered-Index-Seek for its operation.But as I said when I run...
November 4, 2008 at 9:08 am
Viewing 12 posts - 76 through 87 (of 87 total)