Activity overview
Latest activity by SQL_Rookie
SQL prompt no longer works ...why?
I had sql prompt 2 for long time now and has been working flawlessly....until today...I get a SQL prompt error when I try to start it up...here is the error
************** Exception Text **********...
when scrolling thru candidate list cursor
I use sql prompt 2.0 in SQL query analyzer, when I scroll down the candidates list using the arrows on the keyboard and if I scroll pass a page or so the cursor on query analyzer goes to the next l...
yes we are using 5.2.0.32..
I meant running sql compare on the prod just to see what is different not to actually go thru with the sync. / comments
yes we are using 5.2.0.32..
I meant running sql compare on the prod just to see what is different not to actually go thru with the sync.
If I reading you reply correctly is that you are saying the left side db as the object encrypted. Actually both db's don't have this proc encrypted. If you see the name of the proc is actually a replication proc used by SQL server. And the procs are the same and we don't encrypt these since replication uses them. We encrypt the other procs that our company creates mandated by security..I know Iknow .... that is why the check box is on... but as you can see I have to pick thru all of them to select the ones I really want to move over....and the replication procs 3 per table and we have over 200 or so tables.....nasty...
Can you explain to me how sql compare works alittle ? I would like to know if there is any impact on running this on a production db while users are heavily using it? / comments
If I reading you reply correctly is that you are saying the left side db as the object encrypted. Actually both db's don't have this proc encrypted. If you see the name of the proc is actually a re...
yes I'm using the "ADD WITH ENCRYPTION "
max lenght is 90
avg length is 30 / comments
yes I'm using the "ADD WITH ENCRYPTION "
max lenght is 90
avg length is 30
not sure what you mean about scripts but here is the code from the sql difference windows
-- Stored Procedure
CREATE procedure [sp_MSdel_Activities] @pkc1 int
WITH ENCRYPTION as
delete [Activities]
where [ACTIVITY_ID] = @pkc1 @rowcount = 0 @microsoftversion>0x07320000
exec sp_MSreplraiserror 20598
GO
-- Stored Procedure
CREATE procedure [sp_MSdel_Activities] @pkc1 int
WITH ENCRYPTION as
delete [Activities]
where [ACTIVITY_ID] = @pkc1 @rowcount = 0 @microsoftversion>0x07320000
exec sp_MSreplraiserror 20598
GO
also if you can tell me how to get the average length of the object names I can supply that too. I can get the LEN of the objects names but how can I get average. / comments
not sure what you mean about scripts but here is the code from the sql difference windows
-- Stored Procedure
CREATE procedure [sp_MSdel_Activities] @pkc1 int
WITH ENCRYPTION as
delete [Activities]...
SQL Compare....objects are the same but tool says not
Running SQL compare 5.2 on 2 seperate db's with same schema. I get back that there are procs that are different but once I highlight them and check the SQL differences window at the bottom of the s...
no since the schemas are the same. It's just more tables are selected more then I had selected on the original project. And another thing is you can edit the clone but you most run the compare to save it....that is no good incase I wanted to just set it up and run it later in the day. / comments
no since the schemas are the same. It's just more tables are selected more then I had selected on the original project. And another thing is you can edit the clone but you most run the compare to s...
Clone on Data Compare
OK I have a db that has few hundred tables but within the schema I only want to compare like 150 tables. I have a Dev, QA, UAT, Stage, Train and PROD db's which resided in different SQL servers. I ...
I have tried the Create Clone button and once I click on the table&Views tab I see all the tables and there are more then I want to be checked. When I clone the original the projet had the correct tables checked.
I also open the sdc file in notepad and edited the db connection to the appropiate server I want to compare with but I can not open the file in the Data Compare or at least I don't know how since there is not a FILE-> OPen oprtion.
what can I do?
I have like 500 tables that I only want 180 something to compare. / comments
I have tried the Create Clone button and once I click on the table&Views tab I see all the tables and there are more then I want to be checked. When I clone the original the projet had the correct ...