Comments
Sort by recent activity
Hi Troels
You are correct, although the syntax is slightly different.
If you have any triggers defined on you tables, with the option checked, they will be disabled. The script will then read.
ALTER TABLE [dbo].[<table name>] DISABLE TRIGGER [<trigger name 1>]
ALTER TABLE [dbo].[<table name>] DISABLE TRIGGER [<trigger name 2>]
DELETE FROM [dbo].[<table name>] WHERE (...)
UPDATE [dbo].[<table name>] SET (...)=(...), (...)=(...) WHERE (...)
INSERT INTO [dbo].[<table name>] (...) VALUES (...)
ALTER TABLE [dbo].[<table name>] ENABLE TRIGGER [<trigger name 1>]
ALTER TABLE [dbo].[<table name>] ENABLE TRIGGER [<trigger name 2>]
If you do not see these commands in the script then please email us at support@red-gate.com and we will help you find out why.
Regards
Dan / comments
Hi Troels
You are correct, although the syntax is slightly different.
If you have any triggers defined on you tables, with the option checked, they will be disabled. The script will then read.
ALTE...
Hi Troels
We know about this problem and are currently working on a fix that will be included in the next minor release.
I expect this to be available sometime early next week.
Regards
Dan / comments
Hi Troels
We know about this problem and are currently working on a fix that will be included in the next minor release.
I expect this to be available sometime early next week.
Regards
Dan
That’s great
If you have any more problems please get in touch again.
regards
Dan / comments
That’s great
If you have any more problems please get in touch again.
regards
Dan
Hi Stephanie
I have done some more research on your problem, and it seems that there can be an intermittent problem with using ado .net.
There has been a fix for the problem. Here is a link from the Microsoft site that you can use to down load the patch. http://support.microsoft.com/default.as ... -us;823679
Let me know how you get on.
Regards
Dan / comments
Hi Stephanie
I have done some more research on your problem, and it seems that there can be an intermittent problem with using ado .net.
There has been a fix for the problem. Here is a link from th...
Hi Stephanie
Occasionally windows will default to a different connection library. To force the connection to use IP there are two methods.
The first is to type the following in to the server field "tcp:hostname,port" where hostname is the server name, and port is the TCP port used by SQL Server (default is 1433).
The second is to use the SQL Server Client Network Utility and create an alias for the server that will for it to use the IP network library.
However it may be that there is a different error that is causing your problem that is related to the operating system. If the suggestions above fail please contact us (suppoert@red-gate.com) for additional assistance to solve the problem.
Regards
Dan / comments
Hi Stephanie
Occasionally windows will default to a different connection library. To force the connection to use IP there are two methods.
The first is to type the following in to the server field ...
Hi
There is a new issue that has been highlighted by the new version.
I will email you directly, or can you send me further information to support(at)red-gate.com .
Regards
Dan / comments
Hi
There is a new issue that has been highlighted by the new version.
I will email you directly, or can you send me further information to support(at)red-gate.com .
Regards
Dan
Hi Hambledon
Can you check the xtype of the object in the sysobjects table? It should be S for system.
This is another way to identify a system object as well as using OBJECTPROPERTY.
Regards
Dan / comments
Hi Hambledon
Can you check the xtype of the object in the sysobjects table? It should be S for system.
This is another way to identify a system object as well as using OBJECTPROPERTY.
Regards
Dan
Hi
This is behaviour that we haven't seen before. We need to investigate it in further detail.
Could you send us some screen shots, and your database to support(at)red-gate.com .
We can then try and recreate your problem and find a solution.
Thanks
Dan / comments
Hi
This is behaviour that we haven't seen before. We need to investigate it in further detail.
Could you send us some screen shots, and your database to support(at)red-gate.com .
We can then try an...
Hi
Can i check a couple of things with you.
Firstly the situation is that the permissions needed to be synchronised. They were then synchronised but after a refresh of the project, although they are now the same, both upper and lower views report them as being out of sync.
Secondly could you let me know what version of the products you have installed.
Regards
Dan / comments
Hi
Can i check a couple of things with you.
Firstly the situation is that the permissions needed to be synchronised. They were then synchronised but after a refresh of the project, although they ar...
I have put this forward to the development team. However it is unlikely to be considered until the next major version.
Dan / comments
I have put this forward to the development team. However it is unlikely to be considered until the next major version.
Dan