Displaying All Databases And Tables Made In SQL Server 7
Please tell me how can I display all the databases I have made in the SQL Server 7 and their respective tables. Is there a query for that? I need to display all the databases made in SQL SERVER and their tables on a form made in Visual Basic.
Please reply to the following email urgently
saad_19@yahoo.com
Please help me. Thankyou :)
View Complete Forum Thread with Replies
Related Forum Messages:
Linking Tables Between Databases On Same Server
Hi, I have 2 similar databases on the same SQL server (due to licencing and customisation issues for off the shelf software). I would like to create a third database with site specific lookup tables to map data across to site codes, to do summary queries for data reporting, and to create a single point for data access. I can't modify the 2 databases. I have created the third database and added the necessary tables, relationships, views, etc. But, how do I link to tables in the other databases on the same server so that I can do joins in a query/view ? I have SQL Server Enterprise manager. Thanks.
View Replies !
The List Databases And Tables In SQL SERVER With SQLDMO
hi i have a project and i want make thats; 1-)The list All SQL Server(s) in my network to dropdrown list(that's ok) 2-) the list all databases to selected sqlserver(that's ok) 3-) the list tables to selected database(i cant) i wrote my source kod please help me 1-) Dim mDMOApp As New SQLDMO.Application Dim mNames As SQLDMO.NameList Dim t As Integer mDMOApp = New SQLDMO.Application mNames = mDMOApp.ListAvailableSQLServers() lstServers.Items.Clear() For t = 1 To mNames.Count lstServers.Items.Add(mNames.Item(t)) Next 2-) Dim server As New SQLDMO.SQLServer Dim db As SQLDMO.Database server.Connect(mysqlserver, "xxx", "xxx") For Each db In server.Databases lst.Items.Add(db.Name) Next 3) how can i ???
View Replies !
Change Index Of All Tables, In At The Databases On A Server.
Hi, I am working on a script to do following: get a list of indexes on all tables in all dbs on a SQL server. If the index property to allow page locks is off, then turn it on, re-index and turn it off again. My problem is: i want to use ' Use <db>' statement in the middle of my script but it is not working.I tried using dynamic SQL with set @cmd='use '+ @dbname exec (@cmd) But this is not working. Can we use 'use' statement in the middle of a script? If not what is the alternative? My script looks as follows: DECLARE @Database VARCHAR(255) DECLARE @Table VARCHAR(255) declare @Index varchar(255) DECLARE @cmd NVARCHAR(500) DECLARE @fillfactor INT SET @fillfactor = 90 DECLARE DatabaseCursor CURSOR FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tempdb','distrbution') ORDER BY 1 OPEN DatabaseCursor FETCH NEXT FROM DatabaseCursor INTO @Database WHILE @@FETCH_STATUS = 0 BEGIN SET @cmd = 'DECLARE TableCursor CURSOR FOR SELECT table_catalog + ''.'' + table_schema + ''.'' + table_name as tableName FROM ' + @Database + '.INFORMATION_SCHEMA.TABLES WHERE table_type = ''BASE TABLE''' -- create table cursor EXEC (@cmd) OPEN TableCursor FETCH NEXT FROM TableCursor INTO @Table WHILE @@FETCH_STATUS = 0 BEGIN set @cmd='use '+@Database print (@cmd) exec (@cmd) declare IndexCursor CURSOR for select name from sys.indexes where object_id=object_id(@Table) open IndexCursor fetch next from IndexCursor into @Index print (@table) --select name from sys.indexes where object_id=object_id(@Table) print (@index) WHILE @@FETCH_STATUS = 0 begin if (INDEXPROPERTY(OBJECT_ID(@Table),@Index,'IsPageLockDisallowed')=1) begin print (@Index + ' page locking off') -- SET @cmd='ALTER INDEX '+@Index +' ON '+@Table+' SET (ALLOW_PAGE_LOCKS = ON) reorganize -- ALTER INDEX '+@Index +' ON '+@Table+' SET (ALLOW_PAGE_LOCKS = OFF)' end else begin print (@Index + ' page locking on') -- SET @cmd='ALTER INDEX '+@Index +' ON '+@Table+' reorganize' end --PRINT (@cmd) fetch next from IndexCursor into @Index end CLOSE IndexCursor DEALLOCATE IndexCursor FETCH NEXT FROM TableCursor INTO @Table END CLOSE TableCursor DEALLOCATE TableCursor FETCH NEXT FROM DatabaseCursor INTO @Database END CLOSE DatabaseCursor DEALLOCATE DatabaseCursor Can anyone help me please?
View Replies !
SQL Server 2005: Copying Tables And Stored Procedures Between Databases On Same Server
This question is about SQL Server 2005: I have been trying to figure out how to copy tables and stored procedures between 2 databases (on the same server) using SQL Server Management Studio. I have tried right clicking on the table name, "script table as", "drop to", "clipboard", then I click on the 2nd database, and then click on the "tables" . I change the name of the database and click "execute". This creates the table but does not copy the data. I have also tried "create to" "clipboard" and "insert to" "clipboard" and cannot seem to be able to figure out how to get the results that I want. I am new at this but need to get the tables with the data copied along with the stored procedures, even if I have to do them one at a time. When I was using SQL Server 2000, I was able to use DTS to copy objects to other databases easily. Can someone please tell me a way to accomplish what I need to do? I have gotten information here before that was very useful and was hoping that someone can help me again.Thank you so much. Carol Quinn
View Replies !
Tables Not Displaying In SQL
I am hoping someone can help me on this. I have lost the ability to see tables in one database. I can see views and have full access rights on this database. I was trying to install OLAP Analysis on my PC and suddenly I lost this capability on one of the databases I access. Any thoughts? I have looked at everything I can find trying to fix this. Have re-installed and even cleared my user and re-added. It is something on my PC alone since it also affects anyone who signs on to my box.
View Replies !
Displaying Constraints From Tables
hey i was just wondering how to display the constraints from a particular table and display all the constraints and wat columns they apply to, someone told me they keyword u use but didnt tell me how to use it :P
View Replies !
Displaying Results From Multiple Tables
Hi, I have created a new reports application project in VS 2008. I have a dataset with 2 tables: Customer and CustomerAddress with one to many relationship. I want to have a simple table in my report which displays data in the following format: Customer Name Address ---------------------------------------------------------- ABC Add1 ABC Add2 XYZ Add1 XYZ Add2 Here Address is obviously from CustomerAddress table. I have tried few options but it's mainly disgusting to work with Reports Application project when there was an amazing Busines Intelligence Reports project available in VS 2005 and equally good designer interface (Dataset, Design and Preview tabs for each report). Please give me a solution to this. Shyam
View Replies !
Displaying Data In Datagrid From A Normalized Set Of Tables
Ok, I'm fairly new to .NET and even newer to the whole database concept. But, don't run away yet, I'm no idiot and I shouldn't have too hard of a time understanding your responses if you're kind of enough to give them. That being said, here's my dilemma:I'm trying to make a database of all the movies I own, the actors in them and the genre (s) they belong to. I have a set of tables that are in the 2NF (I think). I have a movies table, an actors table, a genres table, and two tables called movies_actors and movies_genres with primary-foreign key relationships to pull it all together (e.g. movie_id 1 has two entries in movies_genres, one for Action and one for Drama). My problem arises that when execute my monster query to pull ALL the data on one movie, I get a row returned for every combination of Genres and Actors in a movie. Example:movie_id movie_title comments actor_first actor_last genre_name1 Casino blah blah Robert DeNiro Action1 Casino blah blah Robert DeNiro Drama1 Casino blah blah Joe Pesci Action1 Casino blah blah Joe Pesci Drama And here's the query that produced that:1 SELECT movies.movie_title, movies.comments, actors.actor_first, 2 actors.actor_last, genres.genre_name 3 FROM movies INNER JOIN movies_actors ON movies.movie_id = movies_actors.movie_id 4 INNER JOIN actors ON movies_actors.actor_id = actors.actor_id 5 INNER JOIN movies_genres ON movies_genres.movie_id = movies.movie_id 6 INNER JOIN genres ON movies_genres.genre_id = genres.genre_id So, I want to put all the actors for one movie into the same cell in the datagrid (same with the genres) and still keep it sortable by actor or genre. Is this possible with the .NET 2.0 datagrid? Do I have some fundamental misunderstanding of how my tables should be structured? Am I just really far off and acting like a n00b?
View Replies !
Combining Two Pivot Tables And Displaying The Data
Hi all, I have the following tables Tbl_Request ------------------------------------------------------------------------------------ RequestType NoOfPositionsRequired SkillCategory Req1 10 .Net Req2 3 Java Req1 2 SQL Req3 5 Java ---------------------------------------------------------------------------------- Tbl_User ------------------------------------------------------ ID SkillCategory Experienced ----------------------------------------------------- 101 Java 0 102 .Net 1 103 Java 1 104 SQL 1 105 .Net 0 106 J2EE 0 --------------------------------------------------- Experience is a bool column. Required Output: --------------------------------------------------------------------------------------------------------------------------------- SkillCategory Req1 Req2 Req3 TotalDemand Exp NonExp Total Supply --------------------------------------------------------------------------------------------------------------------------------- .Net 12 0 0 12 1 1 2 Java 0 3 5 8 1 2 2 SQL 1 0 0 1 1 0 1 ---------------------------------------------------------------------------------------------------------------------------------- Well the first half of it I am able to retrieve meaning the 'Demand' part by pivoting it from the table request and the next part i.e. 'Supply' is also obtained in the similar fashion. Tbl_User may contain more skill categories than those mentioned in Tbl_Request. So the output should reflect only those categories that are existing in tbl_Request. How can we combine the both? I have taken both the outputs in two temp tables. Now I would like to know if I can combine them and show it as one output or if there is any other better way of doing it. I am using a stored procedure which is called for my web application so I didn't go for views. Can someone tell me how to do it.
View Replies !
Problem In Displaying Or Inserting Data Into Sqlserver Tables Using Utf
i have such a error in my sql server db i examined arabic_ci_as and SQL_Latin1_General_CP1256_CI_AS but in my web pages that uses utf-8 codepage that retrieves data using ado and asp scripting the ouput or inserted that dispalyed in both of query analyzer and Enterprise manager replaces or display '?????' for characters . i am using nchar and nvarchar and ntext
View Replies !
Querying Table2 With Results From Table1 And Displaying Data From Both Tables
I need help in writing a query. The query should get top 10 items and their values from current year and the values for the same items from previous year table. I was able to write the code for 1st part that gets values from 1st table but I don't know how to get the values from 2nd table. The 2 tables does not have any primary/foreign key relations. Both tables have same structure and same columns. I am attaching some images below to give more information. Image of results from my query. Image of how the final output should look like. The Store Procedure code is: ALTER Procedure [dbo].[free_customsHS4]( @TblName1 varchar(20), @TblType varchar(20), @District varchar(6), @Month varchar(3) ) AS Begin SET NOCOUNT ON; Declare @SQuery nvarchar(3000) set @TblName1 = '[' + @TblName1 + ']' set @TblType = '[' + @TblType + ']' SELECT @SQuery = 'select top 10 a.commodity1 as HS4, b.descrip_1 as Description, sum(a.all_val_mo) as [Amount], (sum(a.all_val_mo)/(select Sum(a.all_val_mo) FROM ' + @TblName1 + 'a where a.stat_month <=' + @Month + ' and a.district=' + @District +'))*100 as [% Share] FROM ' + @TblName1 + ' a left outer join ' + @TblType + ' b on a.commodity1=b.commodity1 where a.stat_month <=' + @Month + ' and a.district=' + @District +' Group by a.commodity1, b.descrip_1 order by [Amount] desc' EXEC sp_executesql @SQuery END
View Replies !
Track Changes Made To SQL Server
Hello there,Does anyone know of a way to track changes to an SQL Server database so thatI can easily run those changes at a later date?That is, I want to make schema changes, and record those changes so that Ican execute them 6 months later on a copy of the orignal database.Thank you kindly for any ideas anyone may haveJohn
View Replies !
A Connection Could Not Be Made To The Report Server
While attempting to deploy from within VS2005 running on 2003 server we get the following error: TITLE: Microsoft Semantic Model Designer ------------------------------ A connection could not be made to the report server http://xxxxx:90/ReportServer. Running sql2005 sp2 integrated w Sharepoint 2007 Thanks..
View Replies !
A Connection Could Not Be Made To The Report Server
hi, I got this error when I was trying to deploy the reporting into IIS.. TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/reportserver. ------------------------------ ADDITIONAL INFORMATION: The server committed a protocol violation. Section=ResponseStatusLine (System.Web.Services) ------------------------------ BUTTONS: OK ------------------------------ I am not able to solve it please help. Thanks.
View Replies !
A Connection Could Not Be Made To The Report Server Http://localhost/ReportServer
I recently installed Reporting Services onto the same computer that we have SQL 2005 Standard installed on. I ran the Reporting Services Configuration utility and have green check marks on all but: Encryption Keys (Blue ! Circle) Initialization (Greyed out X Circle) Email Settings (yellow ! triangle) I built my first report, but I get the following error when I deploy: TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/ReportServer. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title>Configuration Error</title> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } </style> </head> <body bgcolor="white"> <span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1> <h2> <i>Configuration Error</i> </h2></span> <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "> <b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. <br><br> <b> Parser Error Message: </b>Could not load file or assembly 'Microsoft.BusinessFramework' or one of its dependencies. The system cannot find the file specified. (c:inetpubwwwrootweb.config line 77)<br><br> <b>Source Error:</b> <br><br> <table width=100% bgcolor="#ffffcc"> <tr> <td> <code><pre> Line 75: <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" /> Line 76: <!-- <add name="Session" type="System.Web.SessionState.SessionStateModule"/>--> <font color=red>Line 77: <add name="EnterpriseInitializationModule" type="Microsoft.BusinessFramework.Security.EnterpriseInitializationModule,Microsoft.BusinessFramework" /> </font>Line 78: <add name="BPAdminRedirectModule" type="Microsoft.BusinessFramework.Portal.Administration.BPAdminRedirectModule,Microsoft.BusinessFramework.Portal" /> Line 79: <add name="BPHomeRedirectModule" type="Microsoft.BusinessFramework.Portal.Shell.BPHomeRedirectModule,Microsoft.BusinessFramework.Portal" /></pre></code> </td> </tr> </table> <br> <b> Source File: </b> c:inetpubwwwrootweb.config<b> Line: </b> 77 <br><br> <hr width=100% size=1 color=silver> <b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832 </font> </body> </html> <!-- [ConfigurationErrorsException]: Could not load file or assembly 'Microsoft.BusinessFramework' or one of its dependencies. The system cannot find the file specified. (c:inetpubwwwrootweb.config line 77) (c:inetpubwwwrootweb.config line 77) at System.Web.Configuration.HttpModuleAction.get_Entry() at System.Web.Configuration.HttpModulesSection.CreateModules() at System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) at System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) --> --. (Microsoft.ReportingServices.Designer) ------------------------------ BUTTONS: OK ------------------------------ Can anyone help?
View Replies !
A Connection Could Not Be Made To The Reporting Server Http://localhost/reportserver
Hi all, When I build a simple project using the report wizard project. When i deploy the report i get the following error. TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/ReportServer. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <?xml version="1.0" ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head> <title>Server Unavailable </title> </head> <body> <h1><span style="font-family:Verdana;color: #ff3300">Server Application Unavailable </span></h1> <p> <span style="font-family:Verdana;"> The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. </span></p> <p> <b>Administrator Note: </b> An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur. </p> </body> </html> --. (Microsoft.ReportingServices.Designer) ------------------------------ BUTTONS: OK ------------------------------ Could some one come to my rescue. Thanx in advance. Ronald
View Replies !
A Connection Could Not Be Made To The Report Server Http://[IP Address]/ReportServer
Hi I have sql server 2005 Business Intelligent studio on my machine and Report server on some other machine. I created one rdl file and tried to deploy it on the report server. I have checked the report folder name and everything. But the error mentioned in the subject is being thrown. Additional information is The request failed with HTTP status 407: Proxy Authentication Required. (Microsoft.ReportingServices.Designer) Please let me know what all I need to do to resolve the problem. Regards Rajesh
View Replies !
A Connection Could Not Be Made To The Report Server Http://localhost/ReportServer.
Hello Guys, Please take me out from this hell. I created report using VS2005 Business Intelligence Project. It builds fine. I can also see data in the design time. But when I am trying to deploy it gives me this error. TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/ReportServer. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title>Configuration Error</title> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } </style> </head> <body bgcolor="white"> <span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1> <h2> <i>Configuration Error</i> </h2></span> <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "> <b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. <br><br> <b> Parser Error Message: </b>An error occurred loading a configuration file: Failed to start monitoring changes to 'c:inetpubwwwroot' because access is denied.<br><br> <b>Source Error:</b> <br><br> <table width=100% bgcolor="#ffffcc"> <tr> <td> <code><pre> [No relevant source lines]</pre></code> </td> </tr> </table> <br> <b> Source File: </b> c:inetpubwwwrootweb.config<b> Line: </b> 0 <br><br> <hr width=100% size=1 color=silver> <b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 </font> </body> </html> <!-- [HttpException]: Failed to start monitoring changes to 'c:inetpubwwwroot' because access is denied. at System.Web.FileChangesMonitor.FindDirectoryMonitor(String dir, Boolean addIfNotFound, Boolean throwOnError) at System.Web.FileChangesMonitor.StartMonitoringFile(String alias, FileChangeEventHandler callback) at System.Web.Configuration.WebConfigurationHost.StartMonitoringStreamForChanges(String streamName, StreamChangeCallback callback) at System.Configuration.BaseConfigurationRecord.MonitorStream(String configKey, String configSource, String streamname) at System.Configuration.BaseConfigurationRecord.InitConfigFromFile() [ConfigurationErrorsException]: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:inetpubwwwroot' because access is denied. (c:inetpubwwwrootweb.config) at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal) at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors) at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject) at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission) at System.Configuration.BaseConfigurationRecord.GetSection(String configKey) at System.Web.Configuration.RuntimeConfig.GetSectionObject(String sectionName) at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index) at System.Web.Configuration.RuntimeConfig.get_HealthMonitoring() at System.Web.Configuration.HealthMonitoringSectionHelper..ctor() at System.Web.Management.HealthMonitoringManager..ctor() at System.Web.Management.HealthMonitoringManager.Manager() at System.Web.Management.WebBaseEvent.RaiseRuntimeError(Exception e, Object source) at System.Web.HttpResponse.ReportRuntimeError(Exception e, Boolean canThrow, Boolean localExecute) at System.Web.HttpRuntime.FinishRequest(HttpWorkerRequest wr, HttpContext context, Exception e) --> --. (Microsoft.ReportingServices.Designer) ------------------------------ BUTTONS: OK ------------------------------
View Replies !
A Connection Could Not Be Made To The Report Server Http://localhost/reportServer..
hi, I got this error when I was trying to deploy the reporting into IIS.. A connection could not be made to the report server http://localhost/reportServer. ------------------------------ ADDITIONAL INFORMATION: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer) ------------------------------ The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer) I am not able to solve it please help. Thanks.
View Replies !
Many Databases Vs. Many Tables
Hi, I'm writing an intranet application - a web survey engine. I'd like to create a new database for each user that creates a survey form... versus creating new tables for each survey. Memory and disk space is not exactly the problem... just user permissions. If I dump all the results onto one database, doesn't it mean that this user can have access to all other tables(including the results of other surveys??) Question is, does SQL Server reserve a bunch of memory for each database that I create, thereby hogging up a lot of space if I create more than one database. Thank you.
View Replies !
All Databases' Name With Their Tables' Name
hi all, i want to write SQL query that create table and insert in this table all databases' name and their tables' name that exist in my server. e.g DB name Table name ------- ---------- Northwind product Northwind customers Northwind Employees Pubs authors Pubs discounts Pubs employee msdb log_shipping_databases msdb log_shipping_monitor
View Replies !
All Tables In All Databases
Credit for this script really goes to ToddV (see http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=13737) The following script issues a DBREINDEX command against every table in every database on your server. It can be modified to issue other commands, but this one in particular is helpful as we are migrating about 30 databases from SQL 7 to SQL 2000 (new server) and re-indexing is recommended. Here's the script: DECLARE @SQL NVarchar(4000) SET @SQL = '' SELECT @SQL = @SQL + 'EXEC ' + NAME + '..sp_MSforeachtable @command1=''DBCC DBREINDEX (''''*'''')'', @replacechar=''*''' + Char(13) FROM MASTER..Sysdatabases WHERE dbid > 6 -- skip the 6 built-in databases. Remove to process ALL PRINT @SQL -- Only if you want to see the code you're about to execute. EXEC (@SQL) Notes: There is a limit (nvarchar 4000) to how big your command can be, so too many databases will halt this. ------------------------ GENERAL-ly speaking...
View Replies !
An Attempt Has Been Made To Use A Data Extension 'ORACLE' That Is Not Registered For This Report Server.
I am attempting to deploy a sample report (SQL 2005 Workgroup w/SP2) and I am receiving the subject error message when I attempt to view the report on the web server. We are using SQL Server 2005 Workgroup Edition connecting to an Oracle database. Is this a limitiation of this version? In report designer, I am able to select Oracle as a connection type. If I try to create a data source at the server, "Microsoft SQL Server" is the only option available. If I look at the ReportServer config file, I see many other data connection types available. Did I miss a step, or is this a Workgroup Edition limitation (it's not documented as a limitation that I am able to find)? Thanks in advance...
View Replies !
SQL Server Compact Table Not Getting Data Edits Made In Datagrid From Vs05 C#
New to SQL Server Compact Edition and I am getting my feet wet with the following tutorial: http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20060831MobileRB/manifest.xml I follow the tutorial exactly, but the data I edit through the Edit Dialog Form is not saved to the SQL Server table even though all of the edits appear in the datagrid. They never make it back into the table. Any help would be appreciated. Thanks!
View Replies !
How Can I Join Two Tables From Two Different Databases?
hi, i have one database ASPNETDB.MDF created by default when adding a user to my site, and MyData.mds - my database...i want to join the aspnet_Users table with another table created by me (in myData.mds), how can i do that? is hard if i should re-write all the data from myData into the ASPNETDB,i even writed both connectionStrings in the web.config but still with no succes... is there any trick in the SQL statment? please help me thank you
View Replies !
Acess Tables From Different Databases
I am using Vista Business with Visual Web Developer and Sql Server Express 2005. I want to be able to access the data from two tables in a query. Both tables are attached to the application. To refer to the two databases I have used the following DATABASE.OWNER.TABLE (specifically TaskMgr.dbo.TaskTable) For both databases I get the error "Invalid object name" What am I missing? Thanks
View Replies !
Sending Databases/tables ?
Hello, Let's say I created some tables in SQL server using the designer. Tables -> Right click -> New Table ->... How would I send someone else the script for creating that table? Or how would I send somebody else the tables? Thanks.
View Replies !
Sharing Tables Between .MDF Databases
Hi :) I would like to know if it is possible to link two databases together (in my case ASPNETDB, and another mdf database) so that I can run queries on those shared tables. For example, I would like to use the uniqueidentifiers from the ASPNETDB tables in my own tables. Thank you! (I do use the latest version of Visual Web Developer).
View Replies !
Joining Tables In Different Databases
HiI'm working on an ASP project where the clients want to be able toeffectively perform SELECT queries joining tables from two differentdatabases (located on the same SQL-Server).Does this involve creating virtual tables that link to another database, oram I completely on the wrong track?Any hints as to where I might find more information (buzz-words, etc.) wouldbe most appreciated.Thanks
View Replies !
Linking Tables From Other Databases?
In a database, I am creating a new db. From there, I am setting up thetables, so that I can eventually create a front end (usually access,but I may attempt to be brave and lose the shell.) Anyway, I want touse a table, read-only for a lookup. It exists in another database onour system. Is there a way for me to link it into this database that Iam working on? I would think of it like in access when you go to do anew table and you choose to link the table from somewhere else. Thatis what I want to do. Can anyone possibly step me through this?I know basics of sql server and like to learn.Thanks!
View Replies !
Retrieve ALL Tables From ALL Databases
(SQL 2005)I'm looking to create a stored procedure to first "select name fromsys.databases where name like '%site'" then pass each name to thefollowing using some kind of loop "USE @name select name fromsys.tables where type = 'U'"I tried a while statement, but the master sys.databases recordsetdoesn't change..It's the loop I can't get to work.Any help is greatly appreciated!
View Replies !
Querying Tables From Different Databases
Hello,I am quite new to ms-sql and I have a problem : I want to create an SQLrequest which would copy serveral records from a table in a given databaseto another table (with exactly the same structure) in another database(theses two tables and databases already exist).Could you please tell me how to do this ? I dont know how to access twodifferent databases in a single SQL request.Thank you for you help.
View Replies !
Combining Tables From Different Databases
Hi.I'm currently working on a project which involves the creation of aweb page which reports selected data to customers from two back-endsystems. I use ASP script language on IIS, the server is MS SQL 2000.Now I'm struggling with combining two tables from the differentdatabases. I'm sure it's simple enough, but I'm a little short on theSQL expertise.I've got two databases, db1 and db2, and then two tables, db1.t1 anddb2.t2. I need to combine these two tables (both tables have amatching key field) to make a list of all items from db1.t1, and thosewho correspond from db2.t2.I can list all items from db1.t1, but I can't seem to get the db2.t2joined in.Can anybody help me with the syntax for this, please ? Help !Answers, hints & tips greatly appreciated.Thanks in advance !Kenneth
View Replies !
Combining Two Tables From Different Databases
I have two databases that each contain the same tables, but different data in the tables. For example, each data contains a table with the same name, arcus, that holds data on our customers. Although the data is different in each table, there is some overlap, particularly in the area of customer number since that is assigned automatically when a customer is entered and serves as the primary key for that table. To consolidate, I need to merge the two databases. How can I import the data from one table in second database into a table in the first database and append a number to the customer number so that all data will be brought across. To better illustrate: database one has an arcus file with a field cusno and contains cusno 1-50 database two has an arcus file with a field cusno and contains cusno 27-58 The overlapping cusno's are not the same customer. How can I get all the cusno from the arcus file in database two to the arcus file in database one? Is this even possible?
View Replies !
Relating Tables From Different Databases
Hi, I am trying to relate two tables but both are from different databases. I have a database 'Current' which has a table 'case' and another database 'Org' which has a table 'employee'. I want to establish a one-to-many relationship between employee and case. I created a coulmn 'employee_key' in the case table & entered values matching the pkey of the employee table. Then I wrote a query using joins to access the table records. select Org..employee.pkey, Current..case.assignedengineer, Current..case.pkey from Current..case join Org..employee on Current..request.employee_key=Org..employee.pkey Although the above query works fine, there is no relation between the two tables of the two databases, I wanted to know if this is the right way to achieve what i want to or is there a way in which i can actually create a relationship between tables of two different datbases. Can anyone suggest/help??? Also, I wanted to know if i can relate 1 table of SQL Server db with another table of Oracle DB. Please help ........... Thanks
View Replies !
|
TRACKER
