Will Installing Sql Server Management Studio 05 Upgrade Enterprise Manager 00?

Will Installing Sql Server Management Studio Express Upgrade Enterprise Manager?
I was wondering if i install sql server management studio express (05) on a pc with enterprise manager(00) on it, if that will upgrade the enterprise manager?  I was hoping to have them installed side by side so that i can manage my sql server 2000 dbs on a server with enterprise manager and manage a sql express 05 db i have on another pc with the managment studio.Thanks!

View Replies !

---

Installing Sql Server Management Studio Upgrade En
... Weill installing sql server management studio upgrade enterprise manager?

I was wondering if i install sql server management studio express on a pc with enterprise manager on it, if that will upgrade the enterprise manager? I was hoping to have them installed side by side so that i can manage my sql server 2000 dbs with enterprise manager and manage a sql express 05 db i have on another pc with the managment studio.

Thanks!

View Replies !

---

Translating Enterprise Manager And SQL Query Analyzer To SQL Server Management Studio
Good morning,
 
I have a project that consists of modifying a report in Crystal. The problem is that I know very little about SQL and I need to add some data items to Crystal using SQL. The guide that I was given refers to Enterprise Manager and SQL Query Analyzer but they have since upgraded to SQL Server Management Studio. Can anyone translate the following statement into SQL Server Management Studio so that I can complete this process?
 
Best regards,
 
 
We will now edit the View on the MS SQL server. Open Enterprise
Manager and find the cst_adEnroll_MyInitials _vw in the Views
section of the database. Right-click, select Copy, then go to the
menu bar and Select Tools and SQL Query Analyzer. Once Query
Analyzer opens: Change CREATE to ALTER before the view name.

View Replies !

---

Enterprise Manager Vs Management Studio?
Hi,

I am using Sql server 2005 express edition, and I want to import a table to text file using express manager.

How to use the Management studio to Import the table into text file as using in enterprise manager in Sql server 2000?

As many of you may faced this problem, if you can please help me.

regards,
km.

View Replies !

---

What Version: Enterprise Manager Or Management Studio Express
This may be a dumb question but I have searched and haven't found an answer to it here yet.

We are planing to get SQL Server 2005 for a specific purpose.We have several existing stand alone SQL Server 2000 database servers already. I have Enterprise Manager (2000) client installed on my PC. I recently installed SQL Server Express (2005) on my PC to get to know about new features.

I have run into problems (BCP specifically) with having two versions of C:Program FilesMicrosoft SQL Server80... and C:Program FilesMicrosoft SQL Server90... on my PC.

Is there any point before or after we purchase Standard version of SQL Server 2005 when I can do away with C:Program FilesMicrosoft SQL Server80... and/or uninstall Enterprise manager?

In other words can I manage SQL Server 2000 databases using only Management Studio(SQL Server 2005 client)? If not, how do I manage the two different versions of the client software on a single PC.

Thanks,

Dave K.

View Replies !

---

Connection Issue With Enterprise Manager But Works With Management Studio
Hi,I have an interesting scenario. I have a SQL Server 2000 Standard Edition instance running on Computer A. I'm trying to access it through computers B and C.Computer B has Sql Server 2005 Express Edition installed and I was able to use its Management Studio and connect to instance on Computer A.Computer C has SQL Server 2000 Standard Edition installed. When I try to connect to the instance on Computer A, I get connection failed message.I checked some settings. Both TCP/IP and Named pipes are enabled on the instance in A. The TCP/IP port is set to 1433 for both client and server.Please give me some ideas as to how I can solve this problem. -Thanks

View Replies !

---

SQL Server Management Studio Upgrade
 

I have SQL Server Management Studio EXPRESS on my computer, and my employer recently purchased SQL Server 2005 Standard and installed it on one of our servers. I am trying to access SSIS and SSAS from my computer, but when I go thru the "Connecting to a Remote Integration Services Server" procedure the ability to select "Integration Services" in the Server Type list box (of Connect to Server window) is disabled.
 
How do I get access to these services without being physically at the server? It looks like I need the version of Server Management Studio that is NOT made for the Express version, but when I tried to re-load it from the Standard version CD it said I already had a later version on my computer. Should I take it off of my computer and then try to install from the CD? Or am I going in the wrong direction altogether? I can't believe that I need to be sitting in the server room to use these tools!!!!!
 
Thanks!
 

View Replies !

---

Installing SQL Server Management Studio On My PC
I have installed and used SQL Server 2005 64-bit Standard Edition for the last 8 months. Now I am trying to install Management Studio on my PC so I don't have to run the profiler, etc. from the server. The DVD & CD only contain 64-bit program files that will not install on my PC. I can't seem to find a download. Am I out of luck here?

View Replies !

---

Installing SQL Server Management Studio Over Express
I just got a new machine with Vista on it.  It also came with SQL Server 2005 Express.

How do I install SQL Server Management Console on this machine?  I do have an MSDN DVD with a Developer's Edition on it.  Can I use this somehow?  When I try to run the Tools setup.exe with SKUUPGRADE=1, it tells me there is nothing to upgrade.

Is there a separate download somewhere?

Brian

View Replies !

---

Problem In Installing SQL Server Management Studio
Hi all, i have already installed Visual Studio 2005 Professional Addition, due to which the following components have been installed on my computer
Microsoft .NET Compact Framework 1.0 SP3 Developer
Microsoft Compact Framework 2.0
Microsoft .NET Framework 2.0
Microsoft Device Emulator version 1.0-ENU
Microsoft Document Explorer 2005
Microsoft SQL Server 2005
Microsoft SQL Server 2005 Mobile [ENU] Developers Tools
Microsoft SQL Server Native Client
Microsoft SQL Server Setup Support Files
Microsoft SQL Server VSS Writer
Microsoft Visual J# 2.0 Redistributable Package 
Microsoft Visual Studio 2005 Professional Edition - ENU
MSDN Library for Visual Studio 2005
MSXML 6.0 Parser

My visual studio 2005 professional edition is working correctly, but now i want to install Microsoft SQL Server Management Studio. I have a CD on which i have following folders
1.SQL Kit  and Reporting Services(this folder contains folowing setups,
   SQLServer2005_SSMSEE,
   SQLEXPR_ADV,

   SQLEXPR_TOOLKit)
2.Database Publising Wizard 1.0 RC(this folder contains a setup named as Database Publising Wizard 1.0 RC)
3.Book folder contains a setup named as SqlServer2k5_BOL_june2006My problem is that, i don't know in which sequence i have to run these setups, so that the management studio successfully insatlled on my computer. If anybody understands my problem, plz help.

View Replies !

---

Sql Server Management Studio Installing Problem Need Help!!!
 

Hello All
  I am having problem in installing Sql Server Managment Studio whenever i try to install it i get the following error msg:



Code Snippet
"Setup is missing Prerequisites :
   - Msxml -6
  Go to http://go.microsoft.com/fwlink/?LinkId=54583 "
 
 


 
even though i have installed Mxml 6
Please can some one get out of this problem.
 
Thanks Alot

View Replies !

---

Sql Server 2005 Express/management && Enterprise Manager
I have presently installed on my local computer Enterprise Manager for access to our remote sql server. May I install sql server 2005 express and sql server  management studio express on my local computer without causing conflicts with Enterprise Manager?

 

thanks,

damiata

View Replies !

---

Management Studio Missing After Installing SQL Server 2005 Dev
I've just installed SQL Server 2005 Development Edition x64 on Windows XP x64bit. The actual server (as well as Integration, Reporting Services etc) installs fine, I can connect to it via Visual Studio 2005 fine. However, all of the software tools are missing including Management Studio, Business Intelligence Studio etc. They don't show up in the start menu at all and I can't find them in the Program Files directory.

Anyone know how I can get them back? I've tried reinstalling SQL Server 2005, reformatting Windows XP x64, I'm at my wits end!! Many thanks!

View Replies !

---

Error Installing SQL Server Management Studio Express
Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express.  Today I noticed I needed to download the Management Studio seperate download.  I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:

 

Error reading from file C:...SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..

 

Solved my own problem.  Once I moved the msi to C: the installation worked.  Apparently the path it was in was too long causing it to be unreadable. c:xxxxxxxxSQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.

 

View Replies !

---

Microsoft SQL Server Management Studio Express (SSMSE) Upgrade
Hi

Apologies for this question

I have just found out i/we need to upgrade to the full version of this management tool to make use of SSRS for a new CRM we are putting in place, The CRM company tells me we can just install the tool from our SQL 2005 disk.

Im wondering what the best way to go about this is? i would guess we just un-install the express version install the full version  of the management tool  and reconnect to the database. unless im missing anything?

thanks

View Replies !

---

Installing Management Studio On Windows XP Pro SP2 With SQL Server Express Installed
I'm attempting to install SQL Server 2005 Developer Edition Management Tools [only] on my workstation which is running Widows XP Pro SP2. I already have VSTS 2005 installed with SQL Server Express and Management Studio Express Edition.

 

Attempting to do an advanced install with just the Management Tools specified under Client Components, results in the Version Check warning that setup must be run with SKUUPGRADE=1 specified. When I do that, the installation fails with an unexpected error. Clicking the 'Help' button, displays the following info:

 

   LinkID                 20476

   Product Name     Microsoft SQL Server

   Product Version   9.00.2047.00

   Message Source  setup.rll

   Message ID         50000

   EvtType               packageengineinstallpackageaction.cpp@InstallToolsAction.11@sqls::InstallPackageAction:erform@0x643

 

Sending the info results in:

 

We're sorry

There is no additional information about this issue in the Error and Event Log Messages or

Knowledge Base databases at this time.

 

which isn't much help. I'd appreciate any suggestions on installing the full version of Management Studio other

than uninstalling SQL Server Express...









 

 

 

View Replies !

---

SQL Server Management Studio Not Found After Installing Trial Edition
I just downloaded the SQL SERVER 2005 TRIAL EDITION. Where to I get the SQL Server Management Studio from? Can I use SQL Server Management Studio Express?

View Replies !

---

Error Installing SQL Server Management Studio Express On Windows Vista RC1
Hello NG,

After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

"Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."

Where can I find more infos about this error-code?

Anybody knows this problem?

Thank in advance for every help.

 

View Replies !

---

Installing Microsoft SQL Server Management Studio Express Broke My Asp.net Databases
Morning,

I installed the managerment stuid on my machine and now none of my database connections seem to work any more.  I keep getting the attached error.  Before I installed the studio the system worked fine, I could connect to the database and everything was fine.  Does the studio change any permission stuff?  I cannot seem to get it to work again at all now, I added in aspnet as a login inside the studio and it still won't let me connect to the database.  I cannot find *any* logs anywhere that might be helpful in what it is doing or see any way to debug the connection to find out what the problem is.  When I look at the permissions inside of the studio it shows me that the connections should all be fine.

I checked and remote and local connections are setup, although it is only doing local connections anyway since this is a asp.net web server page.

Any idea what the problem is here?  This is very frustrating and annoying :(  Since I didn't change anything and now nothing I will do gets it to work.  I even tried to uninstall the management tool and it still doesn't work.
Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFYASPNET'.



Description: An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.



Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFYASPNET'.

View Replies !

---

SQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that
we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server.

Questions:
1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server?
2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC.  Any expected
    problems when running both 2000 and 2005 SQL Server at the same database server?
3.  What is the best configuration for running SQL Server 2005 when we have old 2000 databases?  Upgade or not upgrade?  

TIA,
Jeffrey

View Replies !

---

MSDE Upgrade And Enterprise Manager
I just upgraded for MDSE 1 (came with VB 6 Pro and inculded Enterprise Manager) to MSDE 2000. After the upgrade, Enterprise Manager was removed.
Is there an Enterprise Manager availble for MSDE 2000, or a similar tool out there?

Thanks for any help.
Greg

View Replies !

---

SP3 Enterprise Manager On Clients. How To Upgrade ?
I have just upgraded SQL 7 with SP3. I have Enterprise Manager installed on two computers. I cannot understand how I can upgrade these computers. Section 4 in the readme document is supposed to explain this but it does not say where and how sqlredis is used. In particular I do not know whether I have to execute this on each terminal or once from the server.

Any Help is much appreciated.

Tony

View Replies !

---

Management Console In Enterprise Manager Error
hi, I always get DR Watson fir Window NT when I test Operators under the Management console. I have created a new operators and when I go to the property to test the email and the pager notification, I get Dr Watson and Sql Server Enterprise disappear.

I am not sure what is going on and if there is someone knows what is going on,please let me know
thanks for your help

Ahmed

View Replies !

---

SQL Management Studio On Vista Enterprise GUI Question
Hi,
I'm using Vista Enterprise edition and my SQL Management Studio (2005) works very well but the object explorer shows still + and - signs in the treeview. When I open SQL Server Enterprise Manager (2000) then I see the little triangles I'm used to view in the Windows Explorer from Vista itself.
Is there any way to enable the Vista look and feel in the Object explorer of SQL Management Studio as well? This is merely a GUI question but it would be nice to have it .
Grz, Kris.

View Replies !

---

Installing SMSS (Management Studio) On Workstation.
I cannot install management studio on workstation (development machine).

I have removed both instances of SQL Express (one installed with VS2005, the other with Office Business Tools).  Have ensured all SQL components are removed.

Is it true that SMSS won't install over IE7, that must have IE6 installed to get SMSS.

thanks

 

View Replies !

---

I Cant Add Or Atach Database After Installing Sql Management Studio
 Hi,im a student who desperately need to use dql management studio at home for my project.But after installing all that is needed,i am receiveing an error 916 when i try to attach a database.It says," an excpetion while executing a transact statement or batch.(microsoft.sqlserver.express.connectioninfo)blah blah blah is not able to access the database model under the current security context.Microsoft Sql server error 916.As for creating a new database,it says,"create database ddenied in database  master>Error 262)".pls help me T.T

View Replies !

---

Trouble Installing Management Studio, Plese Help.
"None of the selected features can be installed or upgraded.
Setup cannot proceed because no effective change is being made to the machine..."

this shows when trying to install SQL Server 'Management Tools', under Client Components, in the Tools install section,
although i manually select 'Entire feature will be installed'
(initially, all features are ticked off with a red X).

this error message shows up regardless of which feature i choose to install. it wouldn't even install books online.

any suggestions?

View Replies !

---

SQL 2000 Enterprise Manager 'Management' Folder Empty
Hi,
We patched our servers last week and now, when connecting to our server remotely via Enterprise Manager (with DBO permissions), the management folder shows as empty.  My guess is its permission related but, I'm not sure where to begin to correct the issue since we aren’t sure how it happened.  Any help will be greatly appreciated.
~des

View Replies !

---

Backup Command And Getting Progress Like Enterprise/Management Studio
Sorry if this is the wrong place for this, but I couldn't find a better place...

I have a .net application that calls a TSQL command to backup the database when the user clicks a button. I would like to give the user incremental feedback on what's going on.

So I hooked into the connection's InfoMessage event.

It gets called at the end of the command, not during.  I read somewhere that you're supposed to be able to add "WITH NOWAIT" to a TSQL command to have it return immediately and then use the InfoMessage for updates, but the Backup command doesn't support it.

I also set a trace on the SQL Server and told SQL Server to backup using Enterprise manager hoping to catch what it was doing special to get these commands, and didn't see anything unique.

Does anyone have suggestions? I really need to show the progress of what's going on.

Thanks!

View Replies !

---

Management Studio Express Installing Error In Vista
At installation Management Studio Express in Vista there is a mistake with what that number. Management Studio it is not supported in Vista?

View Replies !

---

Installing Sql 2005 Management Studio Express On 2nd Hard Drive
Hi,

I've downloaded the sql server 2005 management studio express executable to my second hard drive, as there is no room on my main drive

However, when I try to install, the program shows me both drives, and shows that there is not enough room on my main drive, but it does not allow me to change the installation to my second drive. 

I have previously installed the main sql express product to my second drive with visual studio.  There's loads of room.

Can anyone give me a clue as to why this might be happening.

Thanks

John

View Replies !

---

SQL2000 Databases Not Showing Up In Enterprises Manager But Do Show Up In Management Studio
I can see the databases in the Query Analyzer Object Browser and with EXEC sp_helpdb.
 
NT 5.2 (3790) Microsoft Windows Server 2003, Enterprise Edition for 64-Bit Itanium-based Systems
8.00.2039 Enterprise Edition (64-bit)
 
I did a dbcc checkdb('master') and dbcc checkdb('msdb') and found no errors.
 
I can't see anything in the Management folder either.
 
When I try to view a login it gives me and Error 220.  It works fine in Management Studio.
 

Any ideas?
 
I found a fix at: http://www.ureader.com/message/92216.aspx
 
I had two databases that were offline that had the Error 220.  We took these off line a few weeks back.  I'm not sure why this happened but it works now.
 
I'll include the code in case the link goes away.
 
USE master
GO
DECLARE @db_name varchar(500)
DECLARE dbn_cursor CURSOR FOR
SELECT [name] FROM sysdatabases;
OPEN dbn_cursor
FETCH NEXT FROM dbn_cursor
INTO @db_name
WHILE @@FETCH_STATUS = 0
BEGIN
select * from sysdatabases where name = @db_name
IF @@ERROR <> 0
 BEGIN
     declare @off int
     print 'Restarting database '+@db_name
    
     exec @off = sp_dboption @db_name, 'offline', 'TRUE'
     IF @off <> 0 
  print 'Taking offline failed! Need manual workaround!'
     else
  begin
      declare @on int
      exec @on = sp_dboption @db_name, 'offline', 'FALSE'     
      IF @on <> 0
   print 'Bringing online failed! Need manual workaround!'  
      else
   print 'Restart successfull!'
         end  
 END
FETCH NEXT FROM dbn_cursor
INTO @db_name
END
CLOSE dbn_cursor
DEALLOCATE dbn_cursor
GO

View Replies !

---

How To Upgrade From SQLServer Management Studio Express 2005 To SQL Developer 2005
I currently have SQL Server Management Studio Express 2005 and would like to upgrade my machine to SQL Developer 2005 as easily as possible.  Keeping my databases and such.

 

Any recommendations on the best way to do this would be greatly appreciated.

 

thanks!

View Replies !

---

Visual Studio Database File And SQL Server Management Studio Express Question
I have a database in my "App_Data" folder of my visual studio project.  I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution.  However i recently started playing around with the SQL Server Management Studio Express program.  When i attach my database to Management Studio, and try to run my program it crashes.  I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again.   Any suggestions? ThanksJason 

View Replies !

---

SQL Server Management Express Studio Management Tools
 

I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.

View Replies !

---

Help! Enterprise Manager Turns SQL Server Service Manager Off
IF someone can assist me.  Everytime I load up enterprise manager the service manager turns off.  And the enterprise manager can't connect to the local database.  But everytime i turn it back on and try to connect again it shuts it off and around and around we go.  Help would be appreciated.  Thanks.

View Replies !

---

Side-by-side Upgrade Ruined Enterprise Manager
Hi people

Here is my case: I've a server running Windows server 2003 edition and SQL2000.
I've installed SQL2005 using the side-by-side method as described by MSFT docs. I've then copied the mdf & ldf files to new locations and attached the db in SQL 2005 management studio. Every thing fine. Next, I've migrated the DTSs using the DTS migration wizard. After this step I have some bad warnings in windows:

When I restart the server I get the following message: "mmc.exe Microsoft Management Console encountered a problem and needed to close".
Furthermore: I can't start the old SQL enterprise manager.
It shows another error "mmc.exe - Entry point Not Found" and closes it self.

The MSFT support page on this error relates it to Windows XP but my system is running Windows server....

Any one has any idea why this is happening?
Any suggested course of action?

Many thanks
ds9

View Replies !

---

Visual Studio 2005 Standard And SQL Server Management Studio?
I am new to visual studio and I am still not sure of all its components and features.

I installed visual studio 2005 standard edition but cannot find SQL Server Management Studio?

I guess this must be because it is not included with Visual studio 2005 standard. Is it included with VS 2005 professional?

I want to add pictures of products to my shopping site using an SQL database and I’ve been told that SQL Server Management studio is required as it is a graphical tool.

How would I go about obtaining the SQL server management studio. There seems to be different versions of SQL server that it is confusing to know which one to purchase.

Will the SQL server 2005 version that comes with Visual studio standard be sufficient for me now right? I want to create a shopping site with hundreds, perhaps even thousands of products. I want to use an SQL server 2005 database. The database will include ‘dynamically generated’ product images if that is the correct terminology.

My goodness, it seems I still have so much to learn.

Thanks

View Replies !

---

How Do I Get The Database That I Am Using In Visual Studio Into My SQL Server Management Studio?
How do i get the database that i am using in visual studio into my SQL server management studio?
i need to create some scripts to create stored procedures on a live server.

View Replies !

---

Error When Deleting Report In Report Manager And SQL Management Studio
I am getting a rsInternalError when I try to delete a report in Report Manager and SQL Management Studio.  I am able to deploy, move (as long as the report doesn't exist at the destination) and upload but not delete.
 
This is the error dump:
 
<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.3050.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>Central Daylight Time</TimeZone>
  <Path>C:Program FilesMicrosoft SQL ServerMSSQL.10Reporting ServicesLogFilesReportServer__09_19_2007_00_02_45.log</Path>
  <SystemName>HLTHS2</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
  <OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!5!9/19/2007-00:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-00:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-00:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-00:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-01:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-01:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-02:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-02:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-02:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-03:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-04:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-04:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-05:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-05:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:02:48:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-06:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-07:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-09:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!09/19/2007-09:07:20:: Call to GetItemTypeAction(/Test).
w3wp!library!1!09/19/2007-09:07:21:: Call to CreateFolderAction(Test, /).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources/Warehouse).
w3wp!library!5!09/19/2007-09:07:22:: Call to GetItemTypeAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:07:25:: Call to CreateReportAction(Invoice Balance, /Test, True).
w3wp!library!7!09/19/2007-09:07:29:: Call to SetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPermissionsAction(/).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to ListChildrenAction(/, False).
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:29:: Call to GetPermissionsAction(/Test).
w3wp!library!1!09/19/2007-09:08:29:: Call to GetPropertiesAction(/Test, PathBased).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!9/19/2007-09:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!09/19/2007-09:15:04:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:04:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:05:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!1!09/19/2007-09:15:05:: Call to ListEventsAction().
w3wp!library!1!09/19/2007-09:15:08:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:13:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:15:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:18:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!1!09/19/2007-09:15:18:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!7!09/19/2007-09:15:18:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:18:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!5!09/19/2007-09:15:18:: Call to DeleteItemAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:19:: a ASSERT: Assertion failed!   Call stack:
 Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow() 
 Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() 
 Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String Item) 
 Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String Item) 
 System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) 
 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) 
 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) 
 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) 
 System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values) 
 System.Web.Services.Protocols.WebServiceHandler.Invoke() 
 System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest() 
 System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context) 
 System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 
 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 
 System.Web.HttpApplication+ApplicationStepManager.ResumeSteps(Exception error) 
 System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) 
 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) 
 System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) 
 System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) 
w3wp!library!5!09/19/2007-09:15:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component library;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

 
 
The error in the event log is:
 
EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 reportingservicesnativeclient.ni.dll, P5 2005.90.3042.0, P6 45cd6edb, P7 0, P8 00005253, P9 00000000, P10 NIL.

 
Thanks in advance!
 
Lori

View Replies !

---

SQL Server Enterprise Edition Upgrade
Hi,

Can someone please help me? I recently upgraded from SQL Server 2005 Enterprise Evaluation Version (x64) to SQL Server 2005 Enterprise Version (x64). While the components: Database Engine, Analysis Services, Workstation Components have been upgraded. I can still see that Reporting Services is still in the Evaluation Version. Integration Services is no where to be found.

Regardless, I wanted to add Integration Services but on the System Configuration Check, I am getting the following error: Edition Change Check: To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPgrade=1 parameter. So regardless of this message, I clicked Next, selected Integration Services and then it tells me that it has already been installed.

Anyway, I exit out of set-up. Try to create a new Integration Services project and I get the following error.

Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SQLServer.DTS.Runtime.Wrapper.IDTSContainer90'. This operation failed because the QueryInterface call on the COM component for the interface with IID '8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801d (TYPE_E_LIBNOTREGISTERED)).

Please help!

 

 

 

View Replies !

---

Server Express, Management Studio Express, Visual Studio Standard, And An ASP.NET Page....
I believe I'm missing something as far as my configuration goes...I'm new to working with SQL server and the databinding I'm trying to do.

I have an ASP.NET page that has a radio button list box which I have databound to a database served up by SQL Express

I'm having a lot of problems with connections...

I was going to enumerate the behavior under each configuration (local only, remote tcp/ip only, remote pipes only, remote both), but I've realized that it is just flaky.  Sometimes I can connect to the db with SQL Studio express, sometimes not.  Sometimes I can add new tables and edit tables, sometimes not.  Sometimes I can create a new connection when trying to databind from within Visual Studio, and sometimes not (sometimes I can't even connect, other times, I can connect initially but when I build a query through the designer it then has problems).  Lastly, sometimes the ASP.NET page works correctly and sometimes not.

This all seems to be mostly independent of how I configure SQL Server as far as what kinds of connections are allowed.  I thought there was a pattern, but as I tested it more rigorously I found there wasn't.

What I would like to do is be connected to the same DB with Visual Studio and SQL Studio, edit the DB as I wish, databind to it, and test my ASP.NET page, all without needing to jump through a bunch of hoops (although right now I wouldn't even know what those hoops are...it's just a shot in the dark as to what will work).

It's all quite maddening and any help would be appreciated. 

View Replies !

---

Installing IIS After Installing SQL Server 2005 And Visual Studio 2005 Help Requested!
Hi all, Im new here so il start with a little introduction of myself, My name is Arjan im 19 years old from Holland, and i work for a company to compleet my ICT Education.
 
My situation:
 
My boss gave me a server with server 2003 standard and Sql server 2005 and visual studio 2005 installed already, he asked me if i could figure out how the 'new' reporting services work, Im pretty new to SQL and the reporting service but i figured out i had to install asp.net / frameworks and IIS.
 
So right now i wanna start the Reporting Services Configuration Manager and i get an error that says 'Invalid namespace' and when im trying to approach by using my browser i get 'page not found' so obviously their is Alot wrong. I asked my boss if i could not reinstall everything and do it in the correct order (IIS / ASP.net / Frameworks before installing SQL server 2k5 but that was not an option because we dont seem to have the cd's anymore.
 
The server is not connected to any network or the internet.
 
My Question:
 
Is their any way to fix this? and if yes could anyone tell me where to start

 
Thanks in Advance!
 
ps if their is information or logs that u need in order to help me just say so :-)
 
 
-Arjan

View Replies !

---

Server Hangs Since Upgrade To SQL2k Enterprise From 7.0.
Server Hangs since upgrade to SQL2k Enterprise from 7.0 forcing a hard reboot. Ping still responds, but no RPC requests are handled.

We've been trying to stabilize our SQL2k environment ever since the upgrade from 7.0. At first, we thought we narrowed the problem down to the use of the maintenance wizard, as the hang took place right at the time of day that the backups were kicking off. Now the server hangs at random times throughout the day (more than five times on Friday!). Then it was stable through the weekend and Monday, and hung early this morning.

There seems to be a pattern of entries in the SQL Agent log prior to the server hanging, but it doesn't necessarily hang after every occurrence, so it may be ANOTHER wild goose chase.

Here are the log entries:
2001-03-14 14:36:00 - ! [LOG] Unable to read local eventlog (reason: The handle is invalid)
2001-03-14 14:36:00 - ? [LOG] Attempting to to re-open the local eventlog...
2001-03-14 14:36:00 - ? [201] Attempting to resize the eventlog read-buffer to 18284 bytes...
2001-03-14 14:36:00 - ? [201] Attempting to resize the eventlog read-buffer to 18292 bytes...
2001-03-14 14:36:00 - ? [201] Attempting to resize the eventlog read-buffer to 18452 bytes...
2001-03-14 14:36:00 - ? [201] Attempting to resize the eventlog read-buffer to 16384 bytes...
2001-03-14 14:36:00 - + [LOG] Successfully re-opened the local eventlog - NOTE: Some events may have been missed

This suspicious Error Log entry may be unrelated, but I include it here anyway:
2001-03-14 09:37:50.47 spid65 BobMgr::GetBuf: Bob write not complete after 60 seconds.

The server is a Dell Quad 450 with a meg of secondary cache and 4Gb of RAM and is connected to a Dell Power Vault Fiber Channel via two QLogic controllers. It's running Win2k sp1 with the two latest hot fixes applied (the hot fixes didn't fix it).

Ideas anyone???

View Replies !

---

Installing SQL Server Management Tools
I have been trying for 2 days now to get the SQL Server management tools installed on client machines.  I'm starting to think it is not possible to do that the way we used to be able to with previous versions of SQL Server.  I have installed 3rd party open source software on my own machine so that I can query the database without logging onto the server directly and would like for my co-workers to be able to do the same.  As I mentioned we tried the SQL Server Management studio and all we get is a message saying to uninstall all the beta and Visual Studio *** on our machines.  We stripped one machine all the way down to the OS and still kept getting that message so I'm guessing it is some new Windows Vista issue that makes SQL Server 2005 client tools completely incompatible with XP.  However, we are not going to bow to Microsoft's evil ways and upgrade to their new OS just to use the SQL Server Studio.  If need be I will write my own software to workaround this problem.  In the meantime, can anyone recommend some good 3rd party tools that will allow us to query the SQL Server 2005 database on a server and preferably one that does not require all other software be removed first?

View Replies !

---

SQL Server Enterprise Manager
Does SQL Server Enterprise Manager and Query Analyzer come with the MSDE version of SQL Server 2000.

If it does, how do I open and access it?

If it doesn't, where can I download it from?

View Replies !

---

Where Is SQL Server Enterprise Manager?
I'm a newbie trying to find the SQL Server Enterprise Manager so I cancreate a database. I have installed SQL Server 2005 Express and SQL ServerManagement Studio Express. On the SQL Server menu I see (1) ConfigurationTools and (2) SQL Server Management Studio Express. The SQL ServerManagement Studio Express menu has 3 items on it. Where do I find theEnterprise Manager?Robert

View Replies !

---

Sql Server Enterprise Manager
What to I query in TSQL to check the transaction log size.... etc etc...
when the taskpad gives a javascript error.....

thanks,
Jonathan

View Replies !

---

SQL Server Enterprise Manager
Hi
I am encountering a rare situation with the following problem.
I have a DTS Package which calls couple of Stored procs to Truncate the tables and referesh the tables with new data. When I execute this DTS package (all by itself) it runs fine and populates the tables with 38000 rows. However when I execute this DTS package using the enterpise manager's Job Scheduler it says completed successfully but will have populated only 3000 rows.
(given the user rights are same for scheduler and for running DTS packages;
SQL Server: Version 7/ Windows NT Server 4/SQL Serevr Service Pack 3)

Any suggestions on why this problem could be occuring will be greatly appreciated.
Thanks in advance
Ajith

View Replies !

---