What Is It For 'rebuild' Option On Solution Explorer?

Jun 6, 2006

Up to the moment I don't need it at all

tia

View 3 Replies


ADVERTISEMENT

Solution Explorer And SQL Server

Dec 12, 2005

I am a Visual Studio .net developer and understand Solutions and Projects in VS.net.  Nevertheless, it appears that the paradigm of using Solutions Explorer in SQL Server is not exactly the same.  That is, in Visual Studio you can't get anything done without creating a solution first.  In SQL Server, it is entirely possible to get a lot done without a solution and the ability to create and make use of a solution seems almost an after thought or an add-on.
I am particularly interested in using a solution in SQL Server to allow me to make use of SourceSafe.  In the past, we jumped through all kinds of hoops to keep a running trail of changes we had made to (for example) stored procedures.  It appears now that this can be managed more efficiently with the use of a Solution and SourceSafe and saving scripts or .sql files.  I guess it is not possible to save a pristine copy of a stored procedure directly in SourceSafe, but you can save the code that makes up the stored procedure as a .SQL file which I suppose is about as good.
Anyway, what I would like to know is whether there is a good white paper (or chapter in a book) on the philosophy behind Solutions and projects in SQL Server and how MS intends us to use them; perhaps something other than the cold facts from the documentation.  I would appreciate something more that gives me the big picture on just how MS sees them being used in SQL Server so I can get the most out of them.  I have the feeling that if I "get the vision", they are meant to be an integral part of SQL Server now and in the future.
Woody

View 3 Replies View Related

Order Packages By Name In Solution Explorer

Dec 19, 2007

Good afternoon,
This is a simple question....how can I order packages by name in solution explorer ? I have a solution with more or less 50 packages
and it's very ime consuming to find a package ! ehehe

Thanks everybody

View 5 Replies View Related

Oracle Connection In Solution Explorer

Mar 10, 2008

When trying to create a data source in Solution Explorer the Provider is greyed out and only allows me to create a connection to a SQL server database although I can connect to an oracle database in Server Explorer

View 5 Replies View Related

Adding Folders In The Solution Explorer?

Oct 27, 2006

Hi..
Isn´t it possible to create sub folders in the solution explorer??
I have it hard time to create a decent structure inside the SSIS Package folder, since I have like 30 packages in my project. Is it just me being silly or cannot this be done?

Have a nice day
/Erik

View 2 Replies View Related

Arrange Items In Solution Explorer

Sep 20, 2007

Can the items, i.e. reports within the SSRS Report Designer Solution Explorer be arranged in a custom manner instead of being sorted alphabetically only?

View 2 Replies View Related

How To Add Subfolders To The Report Folder In Solution Explorer

Dec 17, 2007



Hello,

When you create a Reporting Services project it by default creates two folders: Shared Data Sources & Reports. When I right click on the Reports folder in solution explorer in Visual Studio 2005 there is no option to add subfolders, I am simply left with handful of options adding report files. Is there a way to add subfolders to the Reports folder? I am going to be migrating over 40-50+ reports and it would be helpful to organize them into their own folders.

Thanks,
Flea

View 3 Replies View Related

How To Use The Deply Menu From Within The Project In Solution Explorer

Jan 21, 2008

I'm stuggling to find information on how to use the Deploy menu within a project in solution explorer. I would like to understand how to setup modify and delete the attributes that affect the actions of the Deploy menu. How to set different settings so that I can deploy to a test server ad then later change it so that I can deploy to a production server.

All help is welcome.
Thanks

View 1 Replies View Related

Adding Misc Files To Solution Explorer

Dec 12, 2005

I assume this is the best forum for this quesiton; if not, please direct me.

View 3 Replies View Related

Sorting The Packages In The Solution Explorer Window

Jun 14, 2006

Hello all,

A simple one: How can I sort the packages in my project (in the solution explorer) in an alphabetical sort?



Thanks,

Liran

View 1 Replies View Related

Solution Explorer Drag/drop Error?

Feb 19, 2007

I've submitted a bug report for this, but I also want to be sure it's not my own installation.

In the solution explorer, when I drag a package (usually accidentally) to another spot in the list, it disappears from the list. If I try to re-add the package, it thinks the original already exists, and names the second one with a "(1)" suffix. I can work around this by moving the original package out of the primary package folder and then re-adding it through solution explorer, but that's a touch cumbersome.

I don't really have a question here other than perhaps validation of the issue. Thanks.

Here's the bug report if others experience the same issue:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=258908

View 1 Replies View Related

Can't Execute Package From BIDS Solution Explorer Post SP2 Install

Feb 20, 2007

Yesterday, SQL Server 2005 SP2 was installed on our DEV Server (Windows 2003 SP1 x86) and now I cannot right-click a package in the Solutions Explorer window in BIDS and Execute Package. When I do, I get the following error

===================================

Object reference not set to an instance of an object. (Microsoft Visual Studio)

------------------------------
Program Location:

at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage(ProjectItem prjItem, String taskPath)

I know I could do this yesterday morning pre SP2. I've attempted this with a couple of different packages and solutions, so it is probably not a corrupt package (unless now they are all corrupt). I can execute in debug mode if I open the package first and then hit Start Debugging. However this is not always an optimal solution because I sometimes have many connected packages and sometimes what gets executed is not what is expected.

Your thoughts would be appreciated.

View 1 Replies View Related

Using The ONLINE Option The Alter Index Rebuild

Jul 9, 2007



I do a lot of index maintenance and started testing rebuilding my indexes with the ONLINE option, but noticed an increase in record size by 14 bytes. The issue I have is that for each index you build the ONLINE option, you add 14 bytes for row. After the index rebuild is done, normal transaction updates drop the additional 14 bytes.

The act of adding and dropping 14 bytes would cause fragmentation and uncompressed data. Is this correct or do I have something wrong?

View 1 Replies View Related

Sql Server Agent Option Doesnt Come Under The Object Explorer

Mar 22, 2007

I need to create a job and schedule it in sql server 2005.But the sql server agent option doesnt come under the database instance in the object explorer.Do I have to instal some other component of sql server 2005?

View 1 Replies View Related

How To Enable The Option Of Create New SQL Server Database From Database Explorer

Nov 10, 2006

Hi there

I am working on Visual Web Developer Express Edition 2005. When I right click on database explorer to create an SQL server database then I always find the option " Create New SQL Server database " Disabled.

Can any one tell me how to enable that option please ?

View 4 Replies View Related

How Can I Return A Database From The DataBase Explorer Of VB 2005 Express To The Object Explorer Of SQL Server Management Studio

Mar 3, 2008

Hi all,

I just realized recently that a database "XYZ" in the Object Explorer of my SQL Server Management Studio Express (SSMSE) is put in the Database Explorer of my VB 2005 Express for processing a Stored Procedure in executing the SELECT statements (not by using Input and/or Output Parameters) during the ADO.NET 2.0-VB 2005 Express programming, then the content of the database "XYZ" is not in the SSMSE. How can I return the database "XYZ" from the DataBase Explorer of VB 2005 Express back to the Object Explorer of SQL Server Management Studio Express (SSMSE) safely? Please help and advise.

Thanks in advance,
Scott Chang

View 6 Replies View Related

In SqlServer Management Studio Express, Server Type Option Is Greyed Out, Also Publication Option Missing

Apr 27, 2008

Hi everyone In my SqlServer Management Studio Express, on start up it shows the server type option, but greyed.So that value is fixed to database engine. ( I'm trying to work on an SqlServer Compact Edition database through the SSMStudiothat's why I'm trying to get this to change.)Besides, after I connect i go to the Object Explorer, expand the server node, and go to Replication.When i expand replication, i get the "Local Subscription" option, but nothng for Publication.( I want to work on Merge Replication, that's why I desparately need Publication to work)Am i missing something here? I did not install SqlServer separately, I only have what comes bundled with the Visual Studio  2005 Setup.

View 2 Replies View Related

SQL Server 2008 :: Logic To Rebuild Only Clustered Indexes / Skipping To Rebuild Non Clustered Indexes In Same Table

Jun 25, 2015

I have a requirement to only rebuild the Clustered Indexes in the table ignoring the non clustered indexes as those are taken care of by the Clustered indexes.

In order to do that, I have taken the records based on the fragmentation %.

But unable to come up with a logic to only consider rebuilding the clustered indexes in the table.

create table #fragmentation
(
FragIndexId BigInt Identity(1,1),
--IDENTITY(int, 1, 1) AS FragIndexId,
DBNAME nvarchar(4000),
TableName nvarchar(4000),

[Code] ....

View 5 Replies View Related

SOLUTION! - VB.NET 2005 Express And SQL Server 2005 - NOT Saving Updates To DB - SOLUTION!

Nov 30, 2006

VB.NET 2005 Express and SQL Server 2005 Express - NOT saving updates to DB - SOLUTION!

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

The following article is bogus and confusing:

How to: Manage Local Data Files - Setting 'Copy to Output Directory' to 'Do not copy'
http://msdn2.microsoft.com/en-us/library/ms246989.aspx

You must manually copy the database file to the output directory
AFTER setting 'Copy to Output Directory' to 'Do not copy'.

Do not copy








The file is never copied or overwritten by the project system. Because your application creates a dynamic connection string that points to the database file in the output directory, this setting only works for local database files when you manually copy the file yourself.

You must manually copy the database file to the output directory
AFTER setting 'Copy to Output Directory' to 'Do not copy'.

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

The above article is bogus and confusing.

This is rediculous!

This is the most vague and convoluted bunch of nonsince I've ever come accross!

Getting caught out on this issue for the 10th time!
And not being able to find an exact step-by-step solution.

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

I've tried it and it doesn't work for me.

Please don't try what the article eludes to as I'm still sorting out exactly what is supposed to be happening.



If you have a step-by-step procedure that can be reproduced this properly please PM me.

I would like to test its validity then update this exact post as a solution rather than just another dicussion thread.

Many thanks.



This is the exact procedure I have come up with:

NOTE 1: DO NOT allow VB.net to copy the database into its folders/directorys.

NOTE 2: DO NOT hand copy the database to a folder/directory in your project.

Yes, I know its hard not to do it because you want your project nice and tidy.
I just simply could NOT get it to work.
You should NOT have myData.mdf listed in the Solution Explorer. Ever.

Create a folder for your data following NOTE 2.

Copy your data to that folder. * mine was C:mydatamyData.mdf



Create a NEW project.

Remove any Data Connections. ( no matter what)

Save it.

Data | View Data Sources

Add New Data Source

select NEW CONNECTION ( No Matter what, do it!

Select the database. * again mine was C:mydatamyData.mdf

Answer NO to the question:
Would you like to copy the file to your project and modify the connection?
- NO ( no matter what - ANSWER NO ! - Absolutely NO )
Then select the tables you want in the DataSet.
and Finish.



To Test ----------

From the Solution Explorer | click the table name drop down arrow | select details
Now Drag the table name onto the form.

The form is then populated with a Navigation control
and matching Labels with corresponding Textboxes for each field in the table.

Save it.

1) Run the app.

Add one database record to the database by pressing the Add(+) icon

Just add some quick junk data that you don't mind getting lost if it doesn't save.

YOU MUST CLICK THE SAVE ICON to save the data you just entered.

Now exit the application.

2) Run the app again.

And verify there is one record already there.

Now add a second database record to the database by pressing the Add (+) icon.

NOW add some quick junk data that you WILL intentionally loose.

*** DO NOT *** press the save icon.

Just Exit the app.

3) Again, Run the app.

Verify that the first record is still there.

Verify that the Second record is NOT there.
Its NOT there because you didn't save the data before exiting the app.

Proving that YOU MUST CLICK THE SAVE ICON to save the data you just entered.

Also proving you must add your own code to catch the changes
and ask the user to save the data before exitiing or moving to another record.

As a side note, since vb.net uses detached datasets,
(a copy/snapshot of the dataset in memory and NOT directly linked to the database)
the dataset will reflect all changes made when moving around the detached datasets.
YOU MUT REMEMBER TO SUBMIT YOUR CHANGES TO THE DATABASE TO SAVE THEM.
Otherwise, they will simply be discarded without notice.

Whewh!

I hope this saves me some time the next time I want to start a new database project.

Oh, and uh, for anyone else reading this post.

Thanks,
Barry G. Sumpter

Currently working with:
Visual Basic 2005 Express
SQL Server 2005 Express

Developing Windows Forms with
101 Samples for Visual Basic 2005
using the DataGridView thru code
and every development wizard I can find within vb.net
unless otherwise individually stated within a thread.

View 17 Replies View Related

SQL 2012 :: Configuring Memory Per Query Option And Index Create Memory Option

Feb 10, 2015

So I started a new job recently and have noticed a few strange configurations. Typically I would never mess with min memory per query option and index create memory option configuration because i just haven't seen any need to. My typical thought is that if it isn't broke... They have been modified on every single server in my environment.

From Books Online:
• This option is an advanced option and should be changed only by an experienced database administrator or certified SQL Server technician.
• The index create memory option is self-configuring and usually works without requiring adjustment. However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value.

View 3 Replies View Related

Object Explorer And Object Explorer Details

Apr 23, 2008

SQL server 2005:
How to view or open tables under object explorer details, when i double click an object under object explorer.

thats how the default settings used to be.

now when i double click any object or try to open query analyzer it is open in the same left side pane on top of Object explorer window.

i did something to my explorer and explorer details panes since then both are separated, they are not getting synchronized.

Thanks for your help.

View 1 Replies View Related

LOG Explorer

Apr 27, 2007

Hello there... I had an intrusion into my DB and I'd like to analizethe log looking for the moment and the IP the modification was.Does anyone know about free software for this?Thank you.

View 2 Replies View Related

Explorer?

Jul 20, 2005

With Oracle, there is a comprehensive tool called SQL Navigator as well asTOAD. Does such a tool exist for SQL Server 2000?@drian.

View 2 Replies View Related

SQL Rebuild

Nov 15, 2000

Can anyone advise on issues arising from a complete format & rebuild of a SQL server. The machine exists in a small domain and contains 1 small 30 MB production database which I would want to back up and restore to the newly built server. What are the issues with maintaining permissions? etc.

View 2 Replies View Related

Rebuild / Help

Mar 4, 1999

I had to reinstall sql 6.5 on my server. However I am not sure of the correct sequence to resetup my databases. I have all of my original database devices and backups. However when reinstalling I no longer see the database devices or databases( excepected). How do I recreate my database devices using the devices that I have on an existing device. I need sql to recognize these devices then I can recreate my databases and do my restores. Please help!

View 1 Replies View Related

Object Explorer

Jun 2, 2007

I am using vs 2005 to connect to a remote database. I dont have remote access or any other type of access. I need to setup some constraints on the database, but the object explorer is missing. How can Iincorporate this tab into vs

View 1 Replies View Related

Can't See Server Explorer

Sep 18, 2007

Hi,

I just installed 2005 Evaluation version (high spec laptop but running Windows XP Home edition).

Have opened SQL Server Management Studio then set up a dummy database with a table and a query then tried opening the Server Explorer.

I understand that Server Explorer should be on the 'View' tab with, say, Object Explorer but I can't see it.

Does the fact I am running this on XP Home edition have anything to do with it? Or do I need to run another SETUP.EXE or configure some options or is it something else?

When I installed SQL Server 2005 I got one error message saying:

quote:- IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

Does Server Explorer need IIS to be running in order to work?

Help will be very appreciated.

Thanks in advance.

View 12 Replies View Related

Template Explorer

Nov 7, 2007

Hi,
Is there any way to change path for template explorer? Default path for SQL templates is ..Application DataMicrosoftMicrosoft SQL Server90ToolsShellTemplatesSql. I have scripts & would like to share with my teammates. Is there any way to set this path to a common folder so that whenever anybody connects with their login to our TS server, they should be able to see these scripts in template explorer.

Thanks in advance
Sandesh

View 2 Replies View Related

Red-Gate SQL Log Explorer

Jul 14, 2006

Does anyone happen to know if the folks at Red-Gate used a public SDKto create the log explorer, or did they fork over money to microsoft toget a ISV licensed SDK?I'm looking into making a similar product that would be open source,and I'm trying to figure out what they used to translate entries in thelog to something that is readable by the human eye.Thanks.....

View 1 Replies View Related

Object Explorer

Mar 24, 2006

Hello All;

I downloaded the VWD2005 recentrly, it was really agiant achievement , i appreciate the people who developed such an easy-to-learn web development package. I noticed the difference between VS2002 and VWD2005. I really liked it. (i am sorry if this speech isn't in its right place). Here i have an enquiry, I downloaded the the VWD2005, but i haven't seen the Object Explorer(SQLExpress), although it was included in the downloades?

Thanks alot

View 3 Replies View Related

Connection Explorer

Nov 9, 2007



I am using MS SQL Server Managment Studio 2005 - I also use the old Enterprise Manager from time to time. My questions are about making SMS2005 more user friendly.

I) Is there a way to keep the list of server connections displayed in the object explorer after the application is closed and re-opened?

II) Is there a way to save the password in the "Connect Object Explorer" so I don't have to keep confirming the password to enable the connection?

In summary: In Enterprise Manager, the database engines are always displayed in the Object Explorer and are automatically connected upon opening the manager. Is this functionality possible in SMS2005?

View 3 Replies View Related

Not Available In Object Explorer

Feb 15, 2007

Im new to Sql Server CE and I am following the procedure in books online to create a new database. Through Sql Server Management Studio, I have version 9.00.2047, books online says to click connect through Object Explorer and then select Sql Server Compact Edition. I dont see this option. I see Sql Server Mobile. Is it the same thing or am I missing something?



Thanks,

Jesse

View 3 Replies View Related

Complete Rebuild

Apr 9, 2001

Dear all,

I have a SQL Server 7 box that is shortly to be rebuilt completely (still on NT4, but with new RAID system), does anyone have any advice on how I can make the transition as painless as possible? Particularly, I want to maintain the backup, security and DTS structures as much as possible.

Thanks in advance
Jonathan

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved