Viewing 15 posts - 31 through 45 (of 568 total)
Hello,
Would it be possible to create a Login just for the application i.e. do not grant any access to the SQL Server to the “real” user accounts?
From what I understand...
July 2, 2009 at 4:32 am
Hello,
You could also consider using DateDiff (Please see below). How accurate do you need the comparison to be e.g. to the nearest minute, and are you storing Milliseconds in the...
July 2, 2009 at 3:31 am
Hello,
You can create a Unique Constraint across multiple columns i.e. you can do this to the two Underlying Table Columns rather than a Computed Column.
Please see the Books Online Topic...
July 2, 2009 at 2:14 am
Hello,
Could you please check the SQL Server Log for a corresponding error and post it? In particular you should get a more meaningful value for “State”.
Regards,
John Marsh
July 2, 2009 at 1:36 am
If the SP is missing then I would personally be considering reinstalling the Replication Components. If this is a Live Server and you have an MS support contract, you might...
July 2, 2009 at 12:53 am
Hello Sourav,
assuming ur original database's name is db1, you need to delete that table from db1 and import this table from db2
I would not recommend deleting and recreating the table...
July 2, 2009 at 12:38 am
Hmm, interesting ... which Edition of SQL Server do you have?
Regards,
John Marsh
July 2, 2009 at 12:19 am
Hello again,
Well, that should rule out permission issues then.
Does the SP exist in your Master DB i.e. somebody hasn’t accidentally (or possibly even deliberately) deleted it?
Regards,
John Marsh
July 2, 2009 at 12:04 am
Hello,
Are you using a Login with SysAdmin privileges to configure Replication?
Regards,
John Marsh
July 1, 2009 at 11:38 pm
Hello Sourav,
Does your friend not have a backup that he can recover from? Alternatively, does a DB Snapshot exist?
Regards,
John Marsh
July 1, 2009 at 10:51 pm
Hello,
Can you post the full Error Message, including Error Number and State? (With a bit of luck it will be in the Event Log, if nowhere else).
Regards,
John Marsh
June 27, 2009 at 10:11 pm
Hello,
Have all the SQL Servers involved in the replication been upgraded to 2005?
Are you unable to generate a new Snapshot, or can you generate the Snapshot, but not reinitialise the...
June 27, 2009 at 10:04 pm
Hello Paul,
I suspect it is the way the Security is set-up for your Linked Server(s).
Possibly they are configured as (Login will) “Be made without using a security context”?
If so, could...
June 19, 2009 at 3:05 am
Viewing 15 posts - 31 through 45 (of 568 total)