.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Jean Paul
SP
satyapriyanayak
Ashutosh Jha
Simon Robert VoIP
Post New Web Links

Howto use Visual Studo 2008 to maintain SQL Server 2005 tables and stored procedures

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :ASP.Net
 

I I have an ASP.Net web site I built using Visual Studio 2008.  I also have a SQL 2005 database I use with this web site.  I presently use MS SQL Server MManagement Studio Express to add / modify SQL tables, stored procedures, etc. 

But I want to now maintain my SQL datbase directly from my Visual Studo 2008 where I maintain my ASP,Net web site.  I have created a script from my QL DB that creates all my existing tables and stored procedures.  Can I somehow run this to create the necessary source files within VS 2008?

Bob




View Complete Post


More Related Resource Links

CLR stored procedures asssemblies working in sql server 2005 but giving issues over sql server 2008

  
Hi I developed CLR stored procedures assemblies using VS2005 and deployed in sql server 2005 are working fine. Currently we are migrating to sql server 2008. The same CLR assemblies are not working in 2008 version and raising following error. Here i created CLR assemblies in sql server 2008 using 'sa' user account which is having db_owner permission over 'mydatabase'. I am getting an error message like "A .NET Framework error occurred during execution of user-defined routine or aggregate". In sql logs showing messages like as -- Common language runtime (CLR) functionality initialized using CLR version v2.0.50727 from C:\Windows\Microsoft.NET\Framework\v2.0.50727\. -- AppDomain 2 (mydatabase.dbo[runtime].1) created.   Please let me know what may be the cause for this type of issues. Is there any specific backward compatibility settings has to be done over sql server 2008 or sql server 2008 R2 while using 2005 CLR routines?   Thanks in advance.  

SQL Server 2005 Express Edition - GUI to set permissions on stored procedures

  
Hi there, I have SQL Serve 2005 Express Edition (Build 2600: Service Pack 3) installed; I also have the Management Console installed. My problem is that I cannot set execute permission, or any other type of permissions on my stored procedures through the GUI, as the Property menu item is missing from the right click menu. I read somewhere that this happens when you have SP1, but as I stated above I have got SP3 installed... Any help?   Regards, D.

SQL Server 2005 Stored Procedures

  
  I had written a stored proc. to get date & time in Std. format  dd/mm/yy hh:mm:ss AM/PM. I wanted that  when no value is given to the stored procedure it should produce current date & time in the above std. format & when some date is given , it should display that date in above std. format. The stored proc. is as follows: set  ANSI_NULLS ON set  QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[GETDATETIME] @DATE DATETIME = NULL, @NEWDATE VARCHAR(MAX) OUTPUT AS BEGIN --DECLARE @TEMPDATE DATETIME; --SET @TEMPDATE=NULL; --SET @TEMPDATE=; IF (@DATE IS NULL) BEGIN SET @DATE=GETDATE(); SET @DATE=CONVERT(DATETIME,CONVERT(VARCHAR(MAX),@DATE,3)+ ' ' + CONVERT(VARCHAR(MAX),@DATE,24)) ; SET @NEWDATE = convert(varchar(MAX),@DATE, 103)+' ' + CONVERT(VARCHAR(MAX),SUBSTRING(CONVERT(varchar(MAX),@DATE,22),10,12)); GOTO L1; END SET @DATE=CONVERT(DATETIME,CONVERT(VARCHAR(MAX),@DATE,3)+ ' ' + CONVERT(VARCHAR(MAX),@DATE,24)) ; SET @NEWDATE = convert(varchar(MAX),@DATE, 103)+' ' + CONVERT(VARCHAR(MAX),SUBSTRING(CONVERT(varchar(MAX),@DATE,22),10,12)); -- Declare the return variable here --DECLARE @Result int -- Add the T-SQL statements to compute the return value here --SELECT @Result = @p1 -- Return the result of the function --SET @NEWDATE2=CONVERT(VARCHAR(MAX),@NEWDATE); L1: RETURN CONVERT(VARCHAR(MAX),@N

How to start SQL Server 2005 (Visual Studio 2008)

  
I am just starting to work with Visual Studio 2008 (VB) to creat WPF apps and am trying to work with sql server. I want to create databases on my computer to be used with single client applications. When I try to see if the server is running it doesn't appear to be. Is there some special process that I need to do to start the server so I can create some sample databases to work with in Visual Studio? Working with Windows XP, Visual Studio 2008, SQL Server 2005.

Folders or folder like equivalent in SQL Server 2008 ? for packages & stored procedures ?

  
Hi,      Currently running SQL-Server 2000.  We have hundreds of stored procedures and DTS packages. We have so many it's becoming a serious challenge for names and such.  We were wondering if SQL Server 2008 has a way to 'nest' both the equivalent of DTS packages (SSIS) and stored procedures in something akin to 'folders'.  We know we have to upgrade one of these days but a version that would handle these would be much more attractive. Just getting this functionality would be worth whatever effort would be required to upgrade.   Thanks in advance for any help on this.

Installing Visual studios 2008, SQL Server 2005 and 2008

  
I have a new laptop and would like to install Visual studios 2008, SQL Server 2005 and 2008 without using a virtual instance.  Where can I find installation instructions?

Can't SSRS 2008 handle stored procedures which return multiple tables?

  

I tried it and it only returns the first table.

Any suggestion?

Thank you,

Sean




Visual Studio 2008 and SQL Server 2005 SSIS packages

  

My home machine has sql 2005  and Visual Studio 2005 installed. I uninstalled VS 2005 (RTM) and installed VS 2008 (RTM) in its place. I then found that the SSIS templates were missing. Lesson: don't uninstall VS 2005 if you want to use SSIS 2005!

 

1. Is there any "workaround" to this issue?

 

2. (If the answer to 1 is "No") I will install VS 2008 side-by-side with VS 2005 on the same box.  When the SSIS issue is finally resolved, can I uninstall VS 2005 without doing damage to the VS 2008 install?

 

TIA,

 

Barkingdog

 

 

 

 

 


SQL Server Management Studio (2005) and Visual Studio 2008

  

Help -

I had been using SQL Management Studio, from sql server 2005, reciently I installed Visual Studio 2008 on my machine.  I use it for VB coding.  I still use the same Management studio.  It all works fine except when I try and Export or Import a table in Management Studio using the wizard.  I get the following error:

TITLE: Microsoft SQL Server
------------------------------

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Exception has been thrown by the target of an invocation. (mscorlib)

------------------------------

Specified method is not supported. (System.Data.SqlServerCe)

------------------------------
BUTTONS:

OK
------------------------------

Any help would be appreciated.

Thank you


Issues with CLR Stored Procedures - SQL Server 2008

  

Dear members,

I really hope that someone will be able to help me.

I'm trying to create an assembly in sql 2008, for a dll i've created in c# (net 3.5 frameword).

The dll is calling a WS method, that will do some calculations.

The issues i'm having is, once I try to create the assembly, it tells me "

Msg 10301, Level 16, State 1, Line 1

Assembly 'XYZ' references assembly 'system.runtime.serialization, version=3.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(failed to retrieve text for this error. Reason: 15105)). Please load the referenced assembly into the current database and retry your request.

 

" , which I do understand, and following this message, I am trying to create assembly, for the System.Runtim.Serialization dll.

But, if i try to create the dll, it tells me the following:

"

Warning: The Microsoft .NET Framework assembly 'system.runtime.serialization, version=3.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089, process

sql server 2005 view rights only on stored procedures

  

Hi

 I would like my developers to be able to view stored prcedures in production but not execute or modify them.  Is there a way to do this?  I tried granting view definition to the schema but I think they can still modify the procedure.  Any ideas?

 

Thanks

Pam


Cannot connect Visual Studio 2008 to Sql Server 2005

  

I have Windows 7 and installed Visual Studio 2008 Pro and also installed SQL server developer addiotion that comes with VS. After creating a test database in SQL maangement studio and adding the standard asp.net membership provider tables with the aspnet_regsql tool, I created a web project and added a connection string to the web.config file to connect to the database.

No matter what, I cannot connect to the database.

I can create a connection through the server explorer in visual studio and when I drag a sqldatasource onto my page and configure it I can connect to the database etc. But no web.config connection.

This worked on my XP pro machine but not Windows 7.

Has anybody had this problem and what am I doing wrong.

thanks


SSRS 2008 Server Exployer not displaying all stored procedures from the database

  

When I look in the Server Exployer I don't see any of the recently stored procedures that have been developed on the database.  Is there a setting I need to make to be able to see my new stored procedure?


Compatibility issues between Microsoft Visual Studio 2005 and Windows Server 2008 R2

  

Dear sirs,

When I was installing SQL Server 2005 64 bit on Windows Server 2008 R2, I received a notice informing the software Microsoft Visual Studio 2005 has known compatibility issues with this version of Windows.

So how can I get around these problems?

I need to use Visual Studio 2005 to create the Integration Services packages.

Also, I need to migrate directories of Integration Services packages from a server with SQL Server 2005 32 bit on Windows Server 2003 32 bit for a server with SQL Server 2005 64 bit on Windows Server 2008 R2. How can I proceed to do this?

Thanks in advance.

Jose Luiz


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

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend