|
I am retrieving the database list by executing the sp_databases stored proc. Is there any way I can exclude system databases from this list? I do not want to use the query SELECT name FROM dbo.sysdatabases where dbid > 6.
Thanks
Started by Jay on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The only thing you can do is use the INSERT EXEC pattern to insert table #t (db_name varchar(255), db_size int, remarks text) insert #t exec sp_databases select/instance & I have to list the databases....
Sp_databases takes no params.
|
|
SQL Express is installed on the machines that I'm going to, but I'm not going to install the clunky SQL Management Studio. I just want an EXE I can run, so preferably I'd like it to be install-less.
Current options are:
1) Write one myself - not too hard...
Answer Snippets (Read the full thread at stackoverflow):
It is an SQL GUI and comes with an installer-less version.
Thanks
Try RazorSQL.
I found a good db admin tool.
Please see SO answers: SQL Server Management Studio Alternatives
There most certainly is.
|
|
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
, 5 posts
by 5 people.
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.
|
Ask your Facebook Friends
|
Our SQL Server 2000 instance hosts several databases which are all similar, one for each of our client. When comes the time to update them all, we use Red Gate SQL Compare to generate a migration script between the development database and a copy of the...
Started by MaxiWheat on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
In more details I have like....
I have small *.bat script which iterate through all the databases and execute script using sqlcmd command.
I have the script in *.sql file and the list of databases on the 2nd file.
On the server I work.
|
|
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
, 4 posts
by 4 people.
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.
|
|
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
, 3 posts
by 3 people.
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.
|
|
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
, 5 posts
by 5 people.
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 .
|
|
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
, 4 posts
by 4 people.
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.
|
|
Please tell the query to find out size of the individual databases in the sql server 2005?
Started by srihari on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Try this sp_spaceused
exec sp_spaceused
EXEC sp_MSforeachtable 'EXEC sp_spaceused [?]'.
|
|
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?
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 .
|
