The only way a view would take up any resources is if it were indexed. In the case of an Indexed View you need enough disk space for the index.

You can use sp_MSForEachDB to iterate through each database.

The stored proc code to insert a new category and the lang_id and cat_name is below.

CREATE PROCEDURE uspCategoryInsert (

@LanguageId AS INT

, @CategoryName AS VARCHAR(100)

)

AS

BEGIN

BEGIN TRANSACTION;

BEGIN TRY

INSERT INTO category (cat_name, lang_id)

VALUES...

Make sure you save the Script Task before Clicking "Ok" and exiting out.

No worries. Someone mentioned the same situation in the comments of the instructions on how to create the linked server. It's the first comment. They bounced the SQL service and...

I believe there is an MAS90 ODBC driver that you can download. I would install that and try and set up the linked server. Here are some detailed instructions to...

The AUTO_CLOSE option is a server option in the model database and not a setting of the database. You can update the setting on your local server with sp_configure.

I just tried it on my home machine and work machine with no luck.

I found another article that recommended adding a VisualStudioProjectsLocation entry to the Registry under HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Shell...

It depends on how or if the data is related. If it is related and you want to enforce referential integrity and implement Foreign Keys which can only be done...

This article details how you can change the default directory: http://visualstudiohacks.com/options/changing-the-my-projects-folder-location-and-other-settings-in-ssms/

This will list all tables and columns for a database. You can add a filter to return columns for a specified table.

SELECT st.name AS TableName

, sc.name AS ColumnName

FROM sys.tables AS...

You can create a linked server: http://community.sagemas.com/t5/Sage-MAS-90-and-200-Extended/SQL-Server-Linked-Server-MAS90-ODBC/td-p/23757

Hi Bob,

Can you provide more information? You should be able to write the output from the inner stored proc to the file. Have you tried to eliminate the code around...

True, but if you have no experience one way to set yourself apart and demonstrate knowledge, without the experience, is through certification. The certification may help get someone with no...

Is it possible to run a Trace and identify all of the existing code that violates the constraints to be added? If you have a QA server with comprehensive automated...