Hi, I'm looking for assistance/advice in the areas of source control and change mgmt. We are a small shop (4 developers and one DBA). We would like to implement a change mgmt process for check-in/check-out of Db objects (incl SSIS packages) between our DEV/TEST/PROD environments. We have a modest number of PRODUCTION databases and objects to support so price and appropriate scale are significant factors. I would very much appreciate tool and best practice recommendations/suggestions.
TIA, Chris.
Cannot connect to THISSERVER Additional Information: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) Connect to SSIS Service on machine €śTHISSERVER€? failed: Library not registered
Is there a better/faster/persistable way to generate sql objects with the ms sql server mgmt studio than to go thru that long wizard? I hate having to configure it each time.
Has anyone here been having issues where SQL Server Management Server will sometimes ignore selected text and run all scripts on the current tab?
This has been happening most recently after a connection times out or is forced shut. From a disconnected tab, if I add "Use Master" at the bottom of a page full of script, it will often run ALL statements starting from the first line.
I have SP2 installed which rolls management server to 9.00.2047.00 - but this has been an issue for me even before SP1 & SP2.
I can find nothing in the knowledge base regarding this, but perhaps my search string wasn't very thorough.
I'd just like to know if others are experience this issue so I can report to MS.
I just tried installing SQL Server Management Studio Express Edition (SSMSEE?) and it wouldn't install because I had the "regular" SQL Server Management Studio already installed. Is that correct? The version I installed was a CTP. Is the final version going to have the same limitations?
=============================================== Creating tomorrow's legacy systems today. One crisis at a time.
I have Visual Studio 2005 standard installed and want to add SQL server managment studio can I just install the extras pack or do I need to re-install SQL server express with the advanced options.
I have just installed SQL Server 64x on Vista 64 but when I try to find the server in SQL Management Studio nothing appears to connect to. I did run the program to make my Vista login a SQL Admin. Any ideas why?
I have created a SQL Everywhere database using SQL Server Management Studio (because I couldn't figure out a way to create it with VisualStudio.NET).
Then, I try to open it in Visual Studio.NET, using the following steps:
Add New Data Source Pick type Database Click New Connection Pick Data Source "<other>", and Data Provider ".NET Framework Data Provider for OLE DB". Pick OLE DB Provider "Microsoft SQL Server 2005 Everywhere Edition OLE DB Provider for Windows". Enter a full path to the filename as the Server or File Name. (I've tried it with and without doubling the backslashes in the pathname - no difference.) Click Advanced and enter the Password that I assigned to the DB. Click Test Connection - it says it succeeded. Click OK. It says "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."
No. No I do not want to save changes to that sp_who2 query I just ran. I just want to close the window, and not be bothered with the computer's obsessive compulsive need to save everything I do. Dang it all, it sounds like my computer is working for the NSA leaving a paper trail that even a kitten with Attention Deficit Disorder on catnip could follow.
As you can tell, I am weaning myself off of Query Analyzer, and can not find the checkbox for "Don't bother me when I close a window". Anyone else come across it, yet? It does not appear to be under tools->options or query->query options.
I have a Linux machine here at work that I do some development on, along with a few other tasks. It's also on my primary machine at home. Is anyone aware of a SQL Server Management suite that will run (natively - not in a VM) on Linux? I've used Aqua Data Studio in the past, but I would rather not have to pay for another License just for a part-time use.I'm not looking for a full suite of graphical utilities. If I could get the basic functionality of Query Analyzer (query window, object scripting, etc..), I'll be happy.I've googled around, and the pickings have been rather slim. The only thing I've found is something called Transact-SQL Analyzer (http://sourceforge.net/projects/sqlanalyzer/). I haven't tried it yet, but I'll give it a shot. Has anyone used it before? It doesn't make mention of 2k5 support, either.
Is there a way to tell SQL Server 2005 Management Studio that I don't want it to include "USE [dbname]" and "/****** Object: Table [dbo].[TBL_NAME] Script Date: [date] ******/" when it creates scripts? I searched the forums and couldn't find an answer, and I don't see it in Tools->Options.
I created a bunch of stored procedures on my dev machine using Visual Studio 2008 interface.
Now I am using MS SQL Server Mgmt Studio 2005 and looking at the PRODUCTION database online. I tried to create the new stored procedure. But how do I SAVE it to the database? It keeps asking me to save the sql file locally, but I don't know how to do it to the db itself. Please help.
within sql server management studio... we have set up a few sql scripts to run at 2am every night (sql server agent > under jobs)... although it has been successful each night, we'd like to setup sql server agent to automatically email success and failure notifications to our email boxes.
i see under the properties of sql server agent > jobs > properties of a job > there is section that says Notifications but then it doesnt really have a place to type in which email we want to send them to? some reading material or instructions greatly appreciated
i just got an error in my application when i tried to do an insert stating that there was a "unique key constraint". I have the database open with sql server management studio and i need to find out how to view the constraints?
How do i navigate to see the constraints on a table? Thanks
I deleted a database referenced in a maint. task and then I tried to delete the maint. task. I am getting an error "Exception has been thrown by the target of an invocation" and also it says Named Pipes Provider:, error 40: Could not open a connection to SQL , error 53). I think it has something to do with deleting Maint. Tasks outside of SSIS. Does anyone know of a solution?
I've had requests for a version of my product ViEmu, a VS.NET 2003-VS2005 add-in, which will work within SQL Server 2005 Management Studio. I had a look at the Mgmt Studio, and it seems to be a version of the VS2005 environment customized for the product. There is a registry hive along the line of the one in Visual Studio, but located in HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsShell.
I looked for any hint online, but it seems largely undocumented.
I tried plugging my software by writing the right 'Packages' and 'AutoloadPackages' keys, and running "SqlWb /setup", which seems to do something. Nothing happened afterwards, anyway, the DLL doesn't seem to be loaded into the process. I tried using the '/log' option, but an error message comes up (which doesn't describe the /setup option either).
Is there a way to load a VS package into SQL Server 2005 Mgmt Studio? Is this a problem with the PLK? Is it unsupported? Has anybody been successful in such a feat? Would it be ok if I hack some way, no matter how obscure? Is this deliberately turned off, as in the Express editions?
Best regards and thanks in advance,
- J ---------------------------------------------------- ViEmu - vi/vim emulation for Visual Studio
Is there any way to provide 'Windows' credentials to connect the Management Studio to a remote SQL 2000 DB when I am not logged on as that user (on the dev machine where I am running Mgmt Studio)?
I do of course have local machine admin rights via an AD domain account added to the machine administrators on the remote SQL box itself.
i apperciate any help you guys can give me regarding this. I'm trying to connect to a sql ce db using sql server mgmt. studio express but from some reason i can't change the server type from the native engine (db engine) to sql ce (it's simply greyd out). I think I've installed all relevants to this (engine, sdk, etc...) but still nothing. The thing is, that on another machine I can do it and i can't figure out what more do I need for this to work.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Invalid column name 'from_msx'. Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
------------------------------ BUTTONS:
OK ------------------------------
As you can imagine, the links take me to a "We're sorry... no additional info available" message. Has anyone else seen this, or better yet, resolved it?
...why the script generator in 2005 Management Studio is SO FREAKING SLOW!?
2000's EM would script out all the objects in a databases in 15 seconds. The new GUI is taking three-to-five seconds per object on my 1000 object database.
I'm in sql server mgmt 2005 and i highlighted a stored proc and clicked on "execute". I need to pass a null value in as the first param value to test this stored proc. what is the syntax, is below correct?
Hello, does anyone hate the new interface where you manage the Table Relationships, Indexes, and etc?
I hate it a lot for these reasons. 1) Dialog window cannot be resized (really really annoying) 2) The Table-Relationship configuration dialog window is not as convenient to use as SQL Server 2000 Enterprise Manager.
I hope this is the correct place to provide feedback and I hope this will get modified a bit in the next service pack (or) update....
I installed Mgmt Studio and SQL 2005 on a new server - I imported my complete old SQL 2000 databases - then shut down my Original SQL 2000 server and used that Idenitical IP as the Mgmt Studio SQL 2005's IP
I am using Linux Jakarta Tomcat v5.0.27 and all SQL references are referring only to the IP number of ther server and not using DNS -
Originally I was getting an error when my system tried to access the SQL stating that it was an untrusted connection - I then realized that the IP number referred to was not the primary IP and I changed that so the it was.
Both the Linux and SQL 2005 are now using network IPs and then I got a message that the password that I was using was not strong enough so I changed that as well - then all my logging dissappeared
When I try to connect now there is no indication in any log (SQL nor Windows) that I am attempting to connect - the website just hangs for like 3 minutes and fails the login stating that the username/password is incorrect (or it could not verify it) even though I changed nothing on the Tomcat side and it was logging before the IP werent matching.
Is there a significance difference between SQL 2000 and SQL 2005 that will not allow my Tomcat to connect?
Few Addl Notes I can ping to and from each server I can telnet from Linux to SQL 2005 Linux of course is not part of my Windows 2003 Domain but it is on the same network
Although I've got a fine running mirror between my clustered 2005 sp1 SQL box in Tampa, and my DR box in Dallas, I cannot run mirroring monitor. It fails with "no data received" in all fields.
Likewise, I cannot run "sp_dbmmonitorresults" or in fact any "sp_dbm*" stored procedure.....because none of them exist on the server.
A fast perusal of our various SQL 2005 servers reveals that only those servers that also have the SQL Server Management Studio installed to them have any of the mirroring system stored procedures as well.
This poses a dilemma for me. I have a serious need to monitor mirroring, however I work in a very sensitive industry with uber security, and we simply cannot be permitted to install SQL Server Management Studio on a SQL server that contains production data.
I presume that it is in fact these system stored procedures that enable the graphical Mirroring Monitor, explaining the failure.
Is there a method whereby I can get these system stored procedures installed to the clustered SQL server all by themselves? Installing and then uninstalling the Management Studio is *not* an option. Thanks!
I just installed SQL Server 2005 Express. I would like to import tables from another DB, and I read in the help files that I just need to (1) right-click on a non-system database in Management Studio Express, and (2) select Import/Export under the Tasks menu.
I tried this, but my Tasks menu only contains these options: Detach, Shrink, Backup, Restore, Generate Scripts.
I googled for "sql server 2005 "no import" tasks", and it appears that a couple of people have had this problem -- the only solution I read was to install the "Workstation Components," but I already have, and still no luck.
how do I attach my user instance mdf and chagne scheme etc? for example my mdf is at c:sqldatamyapp.mdf
I tried attach and got
TITLE: Microsoft SQL Server Management Studio Express ------------------------------
Attach database failed for Server 'IEI-A64SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
I have created two tables and receive a "columns in table ... do not match an existing primary key or UNIQUE constraint." error message.
Table1: GOSMapping
PK: AuthInd (bigint)
PK: GLCode (nchar(8))
-both columns were set as PK simultaneously
Table2: GOSTracking
PK: AdjID
FK: AuthInd (bigint)
FK: GLCode (nchar(8))
I open Table2 in the designer and right click, then select Relationships. I choose both of the columns that are the PK in Table1, and set the exact fields as the FK in Table2. I get the message when trying to save this relationship. All data types are congruent, and the primary key has been set as the combination of the two PK columns in Table1. Any ideas?
All: As the subject suggests I am encountering an error while running a package through an agent. Unfortunately the error does not provide much information for me to diagnose the problem, and hence the post.
I have pasted the error below and appreciate help from anyone.
Thank you,
Message Executed as user: EPSILONSYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:16:31 AM Error: 2007-08-02 10:16:32.25 Code: 0xC002F304 Source: File System Task File System Task Description: An error occurred with the following error message: "Could not find a part of the path 'P:FinanceItems Sold Below CostItems Sold Below Cost_2007-08-01.csv'.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:16:31 AM Finished: 10:16:32 AM Elapsed: 1.047 seconds. The package execution failed. The step failed.
I'm in stage of manually populating a database that requires me to have about a dozen tables open simultaneously. It would be great to be able to save the tables, locations and sizing so that these can be recalled and opened automatically. Currently I do a screen capture, which is pretty lame.
Any suggestions would be welcome.
Config:
Microsoft SQL Server Management Studio 9.00.2047.00 Microsoft Analysis Services Client Tools 2005.090.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600
Running SQL Server 2005 x64 Enterprise on Windows Server 2003 X64 Enterprise and I am getting the error below when I add users to the permissions on the SRS HOME folder with browser rights.
Response is not well-formed XML. (System.Web.Services)
Unexpected end of file has occurred. The following elements are not closed: Message, MoreInformation, detail, soap:Fault, soap:Body, soap:Envelope. Line 11 position 30230. (System.Xml)
I need to add more users to reporting services and have never experienced this before.
I've been using my DotNetNuke database for weeks on my local PC with SQL Server Express. It attaches as a "User Instance". Basically, I am using all the DotNetNuke defaults. Today I decided to attach the DotNetNuke database in SQL Server Management Studio Express and peek at the tables. I attached the database; then I detached it when I was done. This all went well. But when I tried to open my DotNetNuke web site again I now get a message that it cannot connect. Attaching and detaching the database in SQL Server Management Studio obviously changed something about the database, but I don't know what. My connection string to the database has not changed.
The specific error displayed in the browser is: ERROR: Could not connect to database specified in connectionString for SqlDataProvider
In event viewer is this message:
Exception information:
Exception type: SqlException
Exception message: Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
