Viewing 15 posts - 1,111 through 1,125 (of 1,479 total)
Sp_help TableName gives you lots of information about the table, and this information includes data about the indexes. If you only want to see information about the indexes then...
March 4, 2009 at 10:34 pm
If you can’t use SSIS, then you can insert the file into a table that has only one column. After that you can read each row from your temporary...
March 4, 2009 at 10:16 pm
If I remember correctly if the index has less then 8 pages, it uses a mixed extent. My guess is that this is the reason that it won’t rebuild...
March 4, 2009 at 3:17 pm
Well to be fair about it, Goerge also was correct. I just typed it faster then he did:-). In any case I’m glad that both posts solved your...
March 4, 2009 at 2:30 pm
I agree with what Greg wrote. I recommend that you’ll read the fallowing article which gives a very good explanation about scheduling DTS packages and the problems - http://support.microsoft.com/kb/269074
Adi
March 3, 2009 at 3:18 pm
If you’ll recover the secondary database in order to modify anything in it, you’ll have to rebuild the log shipping and you’ll end up in the same situation as you...
March 3, 2009 at 3:13 pm
I’m not aware of any bug the sends the wrong scope_identity to the client, so I don’t think that the problem has to do with the scope_identity function. Also...
March 2, 2009 at 10:10 pm
Most chances are that you see it as varbinary. See what happens if you use convert function to convert it to varchar of if you use single_clob instead of...
March 2, 2009 at 3:29 am
Yes it is. I've done it on a test machine.
Adi
March 2, 2009 at 2:23 am
Sorry, but DDL triggers don’t exist in SQL Server 2000 because it was introduced in SQL Server 2005. By the way next time please post questions regarding SQL Server...
March 1, 2009 at 10:21 pm
Maybe he has some deny permission or he is a part of a role that has some deny permission? If a user has grant and deny permissions of the...
February 26, 2009 at 3:25 pm
One way of getting this information is using sp_helpdb procedure.
Adi
February 24, 2009 at 3:49 am
Are the query plan on both servers identical? When you run both procedures using the same parameters with the recompile option, do they have difference in the execution? ...
February 23, 2009 at 4:32 am
I don’t have SQL Server CE edition, so I can’t check it, but why do you think that you need to use begin end block? Can’t you just use...
February 23, 2009 at 3:50 am
The function OPENROWSET with the provider bulk, returns to the client one column only. If I’m not mistaken the name of this column is BulkColumn. In any case...
February 22, 2009 at 8:05 am
Viewing 15 posts - 1,111 through 1,125 (of 1,479 total)