Viewing 15 posts - 1,111 through 1,125 (of 1,478 total)
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 2, 2009 at 3:29 am
Yes it is. I've done it on a test machine.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 26, 2009 at 3:25 pm
One way of getting this information is using sp_helpdb procedure.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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? ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 22, 2009 at 8:05 am
I also enjoyed the fact that there was another answer that was the same as mine and came almost at the same time that my answer came. It feels...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 22, 2009 at 7:34 am
Viewing 15 posts - 1,111 through 1,125 (of 1,478 total)