Post New Web Links

Using SourceSafe with SQL Server 2008 R2 as source control - how do you keep them in sync?

Posted By: Posted Date: April 10, 2011 Points: 0 Category :

Currently there are two developers working on a VB.NET desktop application that accesses a number of SQL Server databases. We have recently added SQL Server script files (for stored procedures, tables, agent jobs, views and functions) to SourceSafe (VSS). This finally gives us a way to store sql source code with change tracking, centralized shared access, etc. - a vast improvement over the previous method of manually trying to keep track of all the code components of our database development activity.

We have a "solution" defined in SQL Server that has three projects: right now we have one project for each of three databases that we are accessing. The projects were created as "SQL Server Scripts" so they have Connections, Queries and Miscellaneous folders. The Queries folders currently contain stored procedures used in each of the three databases. In all we have about 200 stored procedures.

However, we have not yet figured out a bullet proof way to keep the source in VSS in sync with the code that SQl Server is actually storing and executing. If I open a stored procedure for edit by double-clicking the file shown in the Solution frame, it gives me the stored procedure in VSS. If I edit it and then click on EXECUTE to actually ALTER the procedure in SQL Server and then check-in the

View Complete Post

More Related Resource Links

Virtual Source Code Control Systems: Promoting and Managing Projects using Visual SourceSafe

Source code control systems like Microsoft Visual SourceSafe can simplify just about any development project, and make it easier for your code to move safely among individual programmers, development teams, and project stages. Visual SourceSafe provides an object model that you can use as the basis of your own customized source code control environment. To give you an idea of what is possible, we'll walk you through the elements of a browser-based source code control system built with Visual SourceSafe, ASP, and VBScript. This simple system lets members of your team build, label, and promote individual files or entire projects, and to reverse promotions.

Ken Ramirez

MSDN Magazine May 2000

SQL server 2008 r2 Data sync question???

Sql 2008 r2 data sync, does it involve a db hosted by microsoft or does that involve us hosting the sync functionality locally? I know we have db's local that need to be sync'd across a wan but does that happen in a db hosted in the ms cloud or does that have to do with a sync functionality that runs locally to keep my db's sync'd? Thanks, SL

How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual

I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, if I create a shared data source and specify "Credentials stored securely in the report server", I can check the "Use as Windows credentials when connecting to the data source" checkbox. This tells SSRS that the user ID and password I specify are from a Windows user, not a SQL Server user. I want to create the shared data source using Visual Studio though. In Visual Studio I have an option to use stored credentials but there is no equivalent of the "Use as Windows credentials when connecting to the data source" checkbox. SSRS always assumes that user and password are for a SQL Server user, not a Windows user, and thus the connection fails. Does anyone know how to tell Visual Studio that the stored credentials are for a Windows user?

SQL 2008 R2 Report Server - what sync method should I use?

Setting up a report server inside the same network for accounting to run reports on. Data can be 1 day behind and would like to be able to add more indexes than the original server. No data will be written back to the original (pub) server. I have about 5 databases on the sql server that I'll be replicating. In reading the book, seem Transactional is the best choice. Any ideas or new features I should try instead?

Sync Oracle and SQL Server 2008

Does anyone know of a way that I could sync a few contact info views from an OracleDB to SQL Server without spending thousands on syncing software?

Best Regards

SQL Server 2008 SP2 Windows 7 UAC Prompt Print Control

We recently installed SQL Reporting Services SP2. When we run Report Manager (i.e http://myserver/reports) and attempt to print a report using the Print control we get UAC prompts for both Vista and Windows 7. This may not be relevant but if we click Show Information About this Publishers Certificate under UAC prompt it indicates the certificate expired on Feb 22, 2009. Were the correct CAB files for installing the print control included in SP2?

Most of our clients are running Windows 7/Internet Explorer 8 and are fully patched. Logged on users are members of local administrators group and the UAC settings are set to default settings.

If we right click IE 8 icon and then "Run As Administrator" we don't get the prompt. My question is can the UAC prompt somehow be disabled if IE is started without using the "Run As Adminstrator" option and without turning off UAC?

Unable to install SQL Server 2008 SP2 Via PCU Source

Hi,

I have extracted SP2 to D:\SQL2K8\PCU but I'm unable to install SQL 2k8 SP2 via PCU SOurce and getting the following error "The required attribute 'Path' is missing." D:\SQL2k8\setup.exe /PCUSource=d:\SQL2K8\PCU

2010-10-28 08:36:03 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2010-10-28 08:36:03 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\100\Bootstrap
2010-10-28 08:36:03 Slp: Sco: Attempting to get registry value BootstrapDir
2010-10-28 08:36:03 Slp: Reading XML resource 'Microsoft.SQL.Chainer.PackageData.Package.xml'
2010-10-28 08:36:03 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Package.Package.xsd'
2010-10-28 08:36:03 Slp: Error: Action "InitializeMsiExtension" threw an exception during execution.
2010-10-28 08:36:03 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: The required attribute 'Path' is missing. ---> Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException: The required attribute 'Path' is missing. ---> System.Xml.Schema.XmlSchemaValidationException: The required attribute 'Path' is missing.
2010-10-28 08:36:03 Slp: at System.Xml.Schema.XmlSchemaValidator.SendValidationEvent(XmlSchemaValidationException e, XmlSeverityType severit

Does Sync Center support for SQL Server 2008 R2 Express Edition pull merge subscription?

Hi,

I have create a subscription (pull, merge replication) on SQL Server 2008 R2 Express Edition to a publication on SQL Server 2008 R2 Enterprise Edition. I have seen that the subscription has been enabled for Windows Sychronization Manager as I can see in its property dialog. However, I cannot see it in the Sync Center of Windows 7 on the Subscriber.

Does Sync Center support in this scenario? From another thread, it seems we need to use Windows Task Manager. If so, how can I set it up?

Thanks in advance.

Please mark replies as helpful or answers if they are helful, doing so can help others encountering the similar issue.

create subscription on client creates no entry in Sync Center if there is another SQL Server 2008 R2

We created a publication on SQL Server 2008 R2 (Dev. Edition). Then we tried to create a pull-merge subscription on the client which should create an entry in Synchronization Center (Win 7) as well under Windows Explorer – Synchronization (Win XP).

This scenario works if there is only our instance of SQL Server installed on the client.

If there is another instance (default or another named instance) installed before we create our instance with subscription there is following strange situation:

- Subscription is created properly within Management Studio, property for showing in sync center set to enabled.

- No entries created in Synchronization Center or Win Explorer Synch.

- &nbs

On SQL Server Express 2008 R2 and Windows 7 x64 replication subscription does not show in Sync Cente

I am running SQL Server 2008 Express R2 64-bit on Windows 7 x64, and I've created a subscription to a database publication on a Windows Server 2008 with SQL Server 2008 R2 standard. The subscription created fine on the Windows 7 machine in SQL Server Management, but it does not display in the Sync Center. I have set the subscription to "Use Windows Synchronization Manager" and recreated the subscription several times, but it never shows up.

I've searched for hours and I cannot find any answers to this. Has anyone else run into this problem? Is there a step I'm missing?

Thanks,
Jonathan

Sorting Data in a GridView Web Server Control

The GridView control provides built-in sorting functionality without requiring any coding. You can further customize the sort functionality of the GridView control by using custom SortExpression property values for columns as well as by using the Sorting and Sorted events

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Server side validation of Fileupload control not working

I've tried this method in my code behind to try and validate that the Fileupload control has a file or not. I get the error message the the event "Server Validate" cannot be found. Can anyone tell why? Thanks.

Public Sub CustomValidator1_ServerValidate(ByVal source As Object, ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs) Handles CustomValidator1.ServerValidate

' Get file name

        Dim uploadAvatar As FileUpload = DirectCast(AdvertisementForm.FindControl("uploadAvatar"), FileUpload)

        Dim UploadFileName As String = uploadAvatar.PostedFile.FileName

        If UploadFileName = "" Then
            ' There is no file selected
            args.IsValid = False
        Else
            Dim Extension As String = UploadFileName.Substring(UploadFileName.L

Building Re-Usable ASP.NET User Control and Page Libraries with VS 2008

I am having problems with a user control. I want my solution to have a separate project for holding my user controls.

The main project can get a reference to this user control project and can import this user control dll into my main project.

Thanks in advance,

Dheeraj Mittal

dhemittal@gmail.com

Error upgrading SQL Server 2008

i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)

Source Error:
sql server 2008 adventureworks database
dear Friends

For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008.

And the query is
-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
WHEN NOT MATCHED BY TARGET THEN
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
WHEN NOT MATCHED BY SOURCE THEN
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	
Please help me to overcome this issue and let me know where can I download that database too.

Thanking you
happy Coding


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All