User profile for ccollins

I checked the comparison results again. When comparing a local to a remote server, the extended property is not listed in the side-by-side window on the remote server side. When I look in Query analyzer or select the table's extended properties it is listed on the remote server's database. / comments

I checked the comparison results again. When comparing a local to a remote server, the extended property is not listed in the side-by-side window on the remote server side. When I look in Query a...

0 votes

Select@ServerName +'/' + DB_Name() as varchar(35)) as ServerDBName, sp.type, CAsT(sp.name As varchar(20)) As XP_Name, CAsT(sp.[value] As varchar(45)) As XP_Value, Cast(so.name as varchar(25)) As Ta...

0 votes

Will the latest version of SQL Compare, (3.2), ignore the merge replication items? :?: / comments

Will the latest version of SQL Compare, (3.2), ignore the merge replication items? :?:

0 votes

Dead After a Day. I had to end the SSMS process, no other method worked. I am going to attempt to add static linked tables in groups and check in. This may work around the check in issue, but probably not the get latest issue. This is a wall, not a speed bump. / comments

Dead After a Day. I had to end the SSMS process, no other method worked. I am going to attempt to add static linked tables in groups and check in. This may work around the check in issue, but pro...

0 votes

Description: A problem caused this program to stop interacting with Windows. Problem signature: Problem Event Name: AppHangB1 Application Name: Ssms.exe Application Version: 2009.100.1600.1 Application Timestamp: 4bb679e7 Hang Signature: 5d4e Hang Type: 6400 OS Version: 6.1.7600.2.0.0.256.1 Locale ID: 1033 Additional Hang Signature 1: 5d4e89e34b78d1eaec09604964415018 Additional Hang Signature 2: 7339 Additional Hang Signature 3: 7339e7c669c193a7ad276d15bf9f2609 Additional Hang Signature 4: 5d4e Additional Hang Signature 5: 5d4e89e34b78d1eaec09604964415018 Additional Hang Signature 6: 7339 Additional Hang Signature 7: 7339e7c669c193a7ad276d15bf9f2609 Read our privacy statement online: http://go.microsoft.com/fwlink/?linkid= ... cid=0x0409 If the online privacy statement is not available, please read our privacy statement offline: C:\Windows\system32\en-US\erofflps.txt / comments

Description: A problem caused this program to stop interacting with Windows. Problem signature: Problem Event Name: AppHangB1 Application Name: Ssms.exe Application Version: 2009.100.1600.1 Applica...

0 votes

From our experience, up to 25 tables is not so bad, between 25 and 50 it is a long inconvience, after 50 unbearable. We have one database with 304 static data linked tables. The Calculating changes spinner has been going for two hours now... The get latest might take all day for our other programmers. / comments

From our experience, up to 25 tables is not so bad, between 25 and 50 it is a long inconvience, after 50 unbearable. We have one database with 304 static data linked tables. The Calculating change...

0 votes

Last week I was getting timeouts. I believe the timeouts were due to either a disconnect from the tfs server or no response from the sql server, (i.e. sql timeout). I am not getting timeouts today. I stopped the last attempt to commit of 304 tables around noon our time today. I started it back at 12:45PM CST/CDT. It gets to the calculating changes spinner in about two minutes and is spinning... I plan on letting this and nothing else run until. / comments

Last week I was getting timeouts. I believe the timeouts were due to either a disconnect from the tfs server or no response from the sql server, (i.e. sql timeout). I am not getting timeouts toda...

0 votes

Thursday morning and still at Calculating changes. The SSMS window does not have a (Not Responding), appended title. However when I click on the commit changes comment text box I receive a systray ballon stating that sql is busy. I noticed that the Calculating changes is not spinning at this time and neither is the yy on the databases. I believe ssms is stalled, locked up or otherwise waiting for something from rrssc. I plan on stopping it soon if I don't have success in tracing or troubleshooting the issue. / comments

Thursday morning and still at Calculating changes. The SSMS window does not have a (Not Responding), appended title. However when I click on the commit changes comment text box I receive a systra...

0 votes

Control data is commonly 'large' recordsets. In the USA the following are common: zipcodes, zippluscountycodes, icd9diagnosis, salestaxesmatrix. SSC is painful with the zipcode recordset and in some peoples opinion unusable with the icd9 diagnosis recordset. / comments

Control data is commonly 'large' recordsets. In the USA the following are common: zipcodes, zippluscountycodes, icd9diagnosis, salestaxesmatrix. SSC is painful with the zipcode recordset and in s...

0 votes

We place the trunk databases on the default sql instance in most cases. Our build machine uses the following instances for building each branch: sqlserver\trunk sqlserver\retro sqlserver\lab Each instance has the databases linked to different branches of the code in TFS/SVN, etc. This works. It would be helpful if there was some automation to 'move' the db's from trunk to retro. Currently we have to unlink all the databases and remove in the trunk instance and then create new blank databases and link in the retro instance. / comments

We place the trunk databases on the default sql instance in most cases. Our build machine uses the following instances for building each branch: sqlserver\trunk sqlserver\retro sqlserver\lab Each...

0 votes

How can we help you today?

ccollins

Comments