Viewing 15 posts - 556 through 570 (of 1,222 total)
If you subscribers already have the all of the data (which they may not since you imply that you have already renamed the server and replication is not operating), you...
December 7, 2010 at 8:24 pm
By default, the SQL Agent SSIS step type executes the 64 bit DTEXEC binary.
There may be other workarounds for this but the one that I am using the moment is...
November 24, 2010 at 8:50 pm
If there are trusts between the old and the new domain, the users from the old domain should be OK. Otherwise, you will need to add them again on...
November 14, 2010 at 8:41 pm
The BULK INSERT statement runs as the SQL Server service (not as you). The windows account that SQL Server is running as needs to have permissions on the share...
November 14, 2010 at 8:37 pm
The OP was asking whether something was possible which is what I answered. He wasn't after recommendations on particular products. Yes I did mention samba ("a product like...
November 9, 2010 at 2:45 am
Michael Ebaya (11/3/2010)
happycat59 (11/3/2010)
Not only is the original article of interest (and it is great to have someone prepared to write about their findings...thanks Terry)
Does no one actually care the...
November 5, 2010 at 2:09 am
How about one of the following, each of which have some degree of separation from the application that enables you to run the code that writes the fax file using...
November 4, 2010 at 6:06 pm
Thank you to all of you who have contributed to this discussion. I am kinda glad that I was too busy to read the article and the discussions until...
November 3, 2010 at 7:27 pm
All things being equal, you do not need to worry about the order that the servers are started etc. Replication is smart enough to re-try. At worst, you...
November 1, 2010 at 8:37 pm
It looks like you created the publication using the default "repldata" folder (something like c:\program files\Microsoft\Microsoft SQL Server\...Repldata\unc). When the snapshot is generated, the name actually used is written...
October 31, 2010 at 9:05 pm
I find that the easiest way to get started with XMLA is to look at examples and the easiest way to get some examples is to use Management Studio. ...
October 5, 2010 at 8:51 pm
Replicating from 2005 to 2000 will work OK. There is a general rule for replication that you need to use...the distributor needs to be the highest version/sp for all...
September 16, 2010 at 10:16 pm
Cross database ownership chaining can be turned on either at the server level or at the database level (have a read of http://technet.microsoft.com/en-us/library/ms188694.aspx). So, your concern about having to...
September 4, 2010 at 7:03 am
I would prefer that you gave a better answer/reason for the result of the first expression being 1 instead of 2. The reason is not simply because of the...
September 1, 2010 at 10:23 pm
The information you need is in the views INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS and INFORMATION_SCHEMA.KEY_COLUMN_USAGE.
September 1, 2010 at 10:12 pm
Viewing 15 posts - 556 through 570 (of 1,222 total)