View Complete Post
I am not able to replicate few tables of a database using snapshot replication.Both publisher and subscriber are in different network and domain.Although I am able to replicate 950 tables but facing problem in some 30 tables.I am using push replication and
I can telnet 1433 port from A server to B server but vice versa not happening.When I am replicating few records of that few tables it is replicating properly but not able to replicate complete table. I tried Verbose history too but I didn't get complete error.
Please help me out.....
DELETE Users, meet, tour FROM Users, meet, tour WHERE Users.uid=meet.desg AND meet.desg=tour.desg AND Users.uid='CCC';
i have try this command to to delete record from three table
i want to delete all the record of uid from user ,tour and meet at once.
Users table having a key uid which is common to all table.
in table Users, uid is primery key
and meet table having desg and tour having desg common field value
i.e. Users.uid=meet.desg=tour.desg are same desg in both table is foreign key
so how could i delete uid from Users table ,desg from tour and meet at once and all the record from these 3 tables
I have a SQL Server host running SQL 2005 9.00.4294 x86 Standard Edition running on Windows build 2195 SP4. My client workstation is running only SQL Server 2005 workstaion components. When a user of the host who has db_owner access attempts
to view the properties of a table by right-clicking the table and then clicking Properties, the following error mesage is displayed:
"The EXECUTE permission was denied on the object "xp_instance_regread", database 'mssqlsystemresource', schema 'sys'
For security purposes, I do not want to grant execute on xp_instance_regread to these users. Does anyone know of a workaround that will allow members of db_owner to access table properties using the abovementioned method and does not
require execute access to be granted?
I have setup a user account that has limited rights to execute certain stored procedures. I can execute these procedures but when I login into SSMS with this user I can't see these sprocs in the object explorer list. Is there a special permission
this user needs to be able to enumerate available sprocs?
I'm running SQL Server 2008 R2 x64.
I've tried and looked on many sites with different solutions for which non of them resolved my issue. I've a blank Sharepoint site and want to view data from an SQL DB. It says that a Server Error occurred and that the Data Retrieval Service didn't worked
out while listing the DB's.
I tried using the 3 methods... using the also the connection string in different ways... when I do it using VB, Office and Java... I can see the data from that DB... why on Sharepoint Designer it doesn't? It supposed to be more easier than other tools.
I'm really desperate. Any help is very welcome.
I would like to identifying the source & destination tables of the data flow or the transformation task.
I need to create a custom component which i can put into existing packages which can do some validation.
Please suggest ways i can accomplish this.
Does anybody know if it is possible to hide databases in the object explorer which the user doesn' t have access too
I currently connect to a shared hosting solution and can see all of the databases on the server approx 80 + and it becomes a bit of chore to find my 3 databases in this growing list .
I'm using SQL Server Management Studio 2008 R2.
As you know, using the "Object Explorer Details" window (pressing F7) you can see details related to the item selected in "Object Explorer". For example, (assuming you have Northwind installed), select the Northwind database in "Object Explorer" and press
Now, in the "Search" bar at the top of the"Object Explorer Window", let's search for the "DF_Orders_Frieght" constraint defined in the "Orders" table. Just type, "DF_Orders_Freight" in the Search box and press Enter. For some reason, SSMS cannot find the
constraint, or any constraint, for that matter. There seems to be a similar problem is searching for column names.
The Search box is certainly a nice feature but why doesn't it find column names or constraint names? It's especially annoying when a constraint fails and we need to find out where that constraint is defined.
I I have an ASP.Net web site I built using Visual Studio 2008. I also have a SQL 2005 database I use with this web site. I presently use MS SQL Server MManagement Studio Express to add / modify SQL tables, stored procedures, etc.
But I want to now maintain my SQL datbase directly from my Visual Studo 2008 where I maintain my ASP,Net web site. I have created a script from my QL DB that creates all my existing tables and stored procedures. Can I somehow run this to create the necessary source files within VS 2008?