i am using sql server 2008 , i got different tables & store proc having different prefex, How can i change them all to dbo?
Can it be done through sql management studio?
View Complete Post
I need to extract or get the schema from tables in my databse and what is the best way to do it. Is there any third party tool to do it??
Any idea will be appreciated..
SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.
Alok Mehta and Ricardo Rodriguez
MSDN Magazine May 2003
Using Microsoft Windows DNA architecture as a guideline, it's possible to create scalable multitier database applications with COM+ and Microsoft Transaction Services. In fact, you can use existing table definitions to automatically build the MTS/COM+ business logic layer and data access components for your application. This article will walk you through the development of database transactions by mapping the transactions to automatically generated MTS/COM+ components. This technique can greatly simplify the task of creating components for a large project.
MSDN Magazine July 2000
I have a .dbml file that I have dragged several tables on to from a database in the Server Explorer. I have written a lot of code against the model that was created.
Now I have added another table (Companies) to the database and a Foreign Key in one of my existing tables (People) which references the PK of the new table. I have refreshed the Server Explorer and can see the new table and the new FK in my existing table. I can drag the new table on to the dbml workspace, no problem. But how do I make the new FK appear in the dbml class? I have tried right-clicking on the .dbml file in the Solution Explorer and choosing "Run Custom Tool" but that doesn't do anything. I suppose I could just delete the .dbml file and start all over again, but surely there is a better way! Eventually there will be dozens of tables involved and recreating every time one column changes in one table would be very painful.
Please tell me that I am overlooking something simple.
As a matter of interest, what if I went the other way and added or modifed a class in the dbml, can I get the database schema updated?
thanks in advance
I am having IIS server and SQL server on two different machines.
In the SQL server I created a new user using the SQL Authentication.
In my application I am using a connection string like this:
<add name="UsrConnectionString" connectionString="Data Source=x.y.z.w\instancename;Initial Catalog=Employee; User Id=xyz; Password=xyz;" providerName="System.Data.SqlClient" />
I can access the other tables within the Employee database. But I am unable to access the tables created by ASP.NET autom
I am getting the following error when I execute an SSRS report.
The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.
The report is executing a stored proc. Which in turn is running an Agent Job.
When I run this report through BIDS it works fine. It is only when I run it though Report Manager I get a problem.
Can anybody help?