Viewing 15 posts - 3,901 through 3,915 (of 7,191 total)
The solution is to wait. The transaction has to be rolled back in order to leave your database in a transactionally consistent state. This can take time depending,...
August 14, 2013 at 1:48 am
You're the DBA. Just say no if the request isn't appropriate.
John
August 14, 2013 at 1:40 am
Still not clear. How about this?
skDte >= '20110101'
If that's not what you require, please supply table DDL (CREATE TABLE statement), sample data (INSERT statements) and expected results.
John
August 14, 2013 at 1:35 am
That seems to work... as long as you remember to close your quotes!
By the way, sysobjects is there for backward compatibility only. You should use sys.objects, sys.tables or INFORMATION_SCHEMA.TABLES...
August 14, 2013 at 1:31 am
laurie-789651 (8/14/2013)
select * from sysobjects where xtype='U' and name like '%_%'
That won't work because "_" is itself a wildcard character. Look up escape characters in Books Online.
John
August 14, 2013 at 1:12 am
Do both of the processes have the same number as well? If so, it's the same process, probably showing up twice due to parallelism. If it has a...
August 14, 2013 at 1:11 am
Are there dangers with dropping constraints, running an insert statement, then adding the constraint again?
Yes. If you're doing this because the data you want to insert violates the constraints,...
August 13, 2013 at 7:37 am
No it won't, but he only asked to be able to add users to the database.
John
August 13, 2013 at 5:57 am
Either:
SET IDENTITY INSERT ON
INSERT INTO WhatsUp_Assyst_replicatie_All.dbo.device
(nDeviceID, nDefaultNetworkInterfaceID)
SELECT nDeviceID, nDefaultNetworkInterfaceID
FROM WhatsUp_Assyst_replicatie.dbo.device
SET IDENTITY INSERT OFF
or:
INSERT INTO WhatsUp_Assyst_replicatie_All.dbo.device
(nDefaultNetworkInterfaceID)
SELECT nDefaultNetworkInterfaceID
FROM WhatsUp_Assyst_replicatie.dbo.device
I would recommend the second method, since you are likely to get duplicates in...
August 13, 2013 at 5:45 am
Right-click on the table, choose Script Table as -> CREATE To -> New Query Editor window.
John
August 13, 2013 at 5:33 am
I can do better than that. If you post the DDL for your two tables, I'll give you the exact script.
John
August 13, 2013 at 5:22 am
In that case, you either have to SET IDENTITY INSERT ON, or omit the identity column from your SELECT list.
John
August 13, 2013 at 5:16 am
INSERT INTO device
SELECT *
FROM WhatsUp_Assyst_replicatie2.dbo.Device;
John
August 13, 2013 at 5:06 am
There's a db_securityadmin database role - would that work for you?
John
August 13, 2013 at 5:04 am
Did you follow the link I posted to watch the video? You need to use DAC.
John
August 9, 2013 at 7:17 am
Viewing 15 posts - 3,901 through 3,915 (of 7,191 total)