Viewing 15 posts - 376 through 390 (of 575 total)
1 way is to SET QUOTED_IDENTIFIER OFF
and then you can use double quotes for string variables.
Example; "2','3','4"
July 11, 2004 at 10:17 pm
You have to allow SYSTEM UPDATES to the System Tables. You enable this via the properties of the SQL Server. But I'm not sure that even that will allow you...
July 11, 2004 at 9:59 pm
If you are using SQL Server 2000, you can create Indexed Views. Have a look in BOL for further info.
July 11, 2004 at 6:02 pm
I believe that is a SQL Server Configuration Option.
You have to use sp_configure. Not sure which setting though. Have a look in BOL or do a sp_configure on the SQL...
July 11, 2004 at 5:51 pm
You may have to remove Replication and then try dropping the unnecassry tables and then setup Replication again.
July 11, 2004 at 5:40 pm
The NOT FOR REPLICATION Option needs to be there!
Can you give us some more info about the Identity Ranges on your Subscribers and your Replication Architecture?
July 11, 2004 at 5:38 pm
A good start would be in BOL. Have a read and give it a go in a test environment and if you get stuck we can help you.
July 9, 2004 at 1:20 am
You could either implement Replication or just create a DTS Package to copy and restore the Database periodically. With Replication, have a look in BOL on how to implement and...
July 9, 2004 at 1:18 am
In your Scenario, If ServerA does go down how will the Applications connect to the ServerB?
Replication is not normally used for Failover support. Not unless you can painlessly get your...
July 9, 2004 at 1:15 am
I'll give it a go.
I wasn't aware that you can Re-Publish an already Subscribed Database!
July 8, 2004 at 5:20 pm
Are you syaing that you are now using UniqueIdentifier columns as your Primary Key? If so, it would be benficial for you to read up on why this is a...
July 7, 2004 at 6:00 pm
Just remove the Database from the list of Published Databases. This will DROP all Subscriptions and DROP the Publication/s.
July 7, 2004 at 5:56 pm
Suspicion is mereley a suspicion! Please ascertain that you are absolutley certain that 2 or more users are using the stored procedure at the same time and are been returned...
July 7, 2004 at 5:51 pm
Kristen,
Please elaborate. How on earth can I help you when you give me short answers such as T-SQL?
If you would like me to further assist you, please show me the...
July 6, 2004 at 11:32 pm
July 6, 2004 at 10:41 pm
Viewing 15 posts - 376 through 390 (of 575 total)