Viewing 15 posts - 496 through 510 (of 1,222 total)
To tell you the truth, I have never really bothered to discover how SQL Server works out that it is the distribution agent that is inserting data. I assume...
April 12, 2011 at 7:43 am
Have a search for articles that talk about http.sys (e.g. http://www.sqlservercentral.com/Forums/Topic665336-146-1.aspx). This is what is used by IIS and Reporting Services.
April 10, 2011 at 9:03 pm
There is no workaround for this method - you cannot restore a database to any earlier version of SQL Server.
If you don't want to use a snapshot, you will need...
April 5, 2011 at 9:41 pm
If you are using a Snapshot Publication - then as aften as you need.
If you are using any other type of publication, you only need to run the snapshot agent...
April 4, 2011 at 9:27 pm
I saw this sort of issue a few weeks back...32 bit development then deployed to 64 bit server and error with unicode conversion. We had the DBA's install 32...
April 3, 2011 at 9:32 pm
This sort of script task is not rquired in SSIS. Doing this sort of thing with SSIS is, in fact, generally not possible.
Instead, SSIS gives you this logging functionality...
April 3, 2011 at 9:29 pm
You missed a bracket just before "as diff"
select SUM(totaldue) as totalofallorders
,SUM(distinct totaldue) as totalofdistincttotaldue
,(SUM(totaldue)- SUM(distinct totaldue) ) as dif
from sales.SalesOrderHeader;
April 3, 2011 at 9:22 pm
When the files grow, your users will experience delays because SQL Server will not be able to complete the transaction(s) that were in progress until the file growth has completed.
March 30, 2011 at 5:27 am
The snapshot is written to completely separate files to the original database. SQL Server uses Windows sparse files to manage the data in the files used for the snapshot....
March 29, 2011 at 8:28 pm
opc.three (3/22/2011)
GSquared (3/22/2011)
March 28, 2011 at 8:36 pm
I think you will need something like..
ISNULL ([COLUMN_B]) ? [COLUMN_B] : [COLUMN_A]
March 28, 2011 at 8:27 pm
sp_addarticle will add a table to a publication. sp_addsubscription will add a subscriber to a publication. You will also need to run the snapshot agent after running...
March 27, 2011 at 9:09 pm
imani_technology (3/25/2011)
March 27, 2011 at 9:07 pm
I don't think that you will be able to open the packages with BIDS 2005 that easily. One of the changes that will have been made is the XML...
March 25, 2011 at 5:50 am
Craig Farrell (3/24/2011)
March 25, 2011 at 3:46 am
Viewing 15 posts - 496 through 510 (of 1,222 total)