Discussions about databases sql

How can I get all user created databases in SQL server 2005? Hi Guys, I want list of user created databases in sql server 2005. How can list all user created databases by T-SQL? Thanks Rajesh Started by Rajesh on Thursday, August 13, 2009, 5 posts by 5 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): I'm sure there is a 'better' way, but this works: SELECT system databases are master.... The simplest way is exec sp_databases however that will include the system databases, so you'd need and some user databases on my server here.

Using SQL Server 2008 Management studio to connect to SQL Server 2005 databases I have a shared hosted SQL Server 2005 at an ISP, that I can connect to from SQL Server 2005 Management Studio. However, I cannot connect from SQL Server 2008 Management Studio. I log on with SQL Server authentication (username+password). When I connect... Started by Kjensen on Thursday, May 14, 2009, 4 posts by 4 people.   Read the full thread at serverfault Discuss this with your friends on Facebook Answer Snippets (Read the full thread at serverfault): You should see all of the databases on the server There is a connect item about this - the workaround is Connect to another sql server and highlight databases Hit F7 to .... Uncheck Collation, and refresh the Databases node.

How can I manage SQL CE databases in SQL Server Management Studio? I created a SDF (SQL CE) database with Visual Studio 2008 (Add / New Item / Local Database). Is it possible to edit this database with SQL Server Management Studio? I tried to attach it but it only offered .mdf and attaching a .sdf file results in "failed... Started by Edward Tanguay on Monday, February 23, 2009, 4 posts by 4 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): Just not in 2005..... HTH: * In the File > Connect ObjectWere you using Management Studio 2005, or 2008? It should work in 2008 if you create a SQL CE 3.5 database ... Studio Express 2008 does not support SQL CE databases.

Can I use Microsoft Sync Framework to synchronize two SQL 2008 databases? I've seen examples about synchronizing SQL 2008 with SQL CE. But not two SQL 2008 databases. If it can be done, have you seen example code about how to do it? Started by Nestor on Monday, November 30, 2009, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): The catch is that you will not be able to use SQL. For the Collaboration Scenario in Sync Framework 2.0.

Copying BLOB values between databases with pure SQL in SQL Server I need to pull some BLOB data from a SQL Server 2005 database and generate a SQL script to insert this same data in another database, in another server. I am only allowed to do this using SQL scripts, I can't use any other utility or write a program in... Started by Dema on Friday, November 07, 2008, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): If the direction.... The value") of the specified 'table'. Description of TEXTCOPY: Copies a single text or image value into or out of SQL Server. This article " Copy Text or Image into or out of SQL Server " could help: You could integrate.

Joining Tables from multiple SQL Server databases located on separate severs What is the recommended way of joining SQL Server database tables located on databases which are on different servers? All databases will be on the same network. Started by gugulethun on Thursday, July 23, 2009, 5 posts by 5 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): You can use linked on the queries you're running.... Linked servers work - but have some issues that make me try/ You will then be able to run queries that reference the different databases. To look at SQL Server Federated Databases .

SQL Server 2005 query multiple Access databases? Is there a way to get SQL Server 2005 to query 3 or more separate Access databases (each returning 1 record) in one SQL statement? Started by on Thursday, January 28, 2010, 5 posts by 5 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): Once you have those in place, you can query.... databases based on using the Linked Server instance notation when specifying tables in your SQL Server for details about creating Linked Server instances on SQL Server 2005 to MS Access .

SQL Server 2000/5 - Script to get list of Active or Inactive databases (except system ones) I need help to script all the databases on an SQL 2005 server and possibly view their activity (specifically the date of last activity). I need to drop all databases that are NOT active on the server. Started by Jangwenyi on Wednesday, January 28, 2009, 6 posts by 6 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): If you run a query, then you will only see... . I will setup the profile and leave and then have a look at your trace log to see which databases are currently being used. Like the idea of SQL Profiler to get list of INACTIVE databases.

Best way to find free space in sql server databases? I want to be able to find out how much space is left in my database files so that I can know when to increase the space so it doesn't do it when the application is running hard out. I would prefer to be able to script this so I can run it across multiple... Started by GordyII on Thursday, May 14, 2009, 4 posts by 4 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): Manually allocating space is a complication .... However, I have always found that SQL Server is best left doing what SQL Server does. For me, sql server always automatically allocated more space until the harddrive was full, so just.

How to compare the structure of two MS SQL databases? I need a free tool or some kind of tip/technique to compare the structure of two Microsoft SQL databases. Preferably MS SQL 2005. The technique I tried to make work was generating scripts from both databases and then comparing the two files but SQL Server... Started by Germstorm on Wednesday, April 22, 2009, 6 posts by 6 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): Note that SQL Server 2008 support requires an update: http://www.microsoft.com/downloads/details.aspx, but redgate sql compare.... If you have Visual Studio 2008 (Database Edition) you can use that to compare SQL schemas. For me.