Which columns are in what tables
Tue, 9 Feb 2010 14:55:33 +1100
I have been asked to provide a list of all columns in all tables in a
database.
I have the output from "select * from sys.tables" and "select * from
sys.columns", but how do I know which columns are in what tables?
Thanks
Bob
...
|
Monitoring SQL Server availability
Thu, 4 Feb 2010 00:43:01 -0800
I have been tasked to manage a non-critical SQL Server 2005, which is a
backend for multiple SharePoint instances. Using a free monitoring tool, I
want to automate the basic monitoring...like SQL Service monitoring, disk
space availability etc.
I want to run this free tool on my XP machine (preferably as a ...
|
SQL2005 Performance Tool
Wed, 3 Feb 2010 10:24:06 -0800
We are having performance issues with our software vendor concerning the
performance of an application that uses SQL2005. The vendor thinks the poor
performance is due to our servers/network we don't agree. We think it is
their database design.
What tools are available to measure the performance of an SQL 2 ...
|
SQL Server H2 Health Tool missing servers in SSRS report server list
Fri, 29 Jan 2010 13:58:25 -0800 (PST)
Hello,
Has anyone had an issue with all servers in the configuration tool not
showing up in the reports. I've looked at the XML config file and the
servers I don't see are in there. I've restarted the collection tool
and reporting services (SQL 2008).
Any help is appreciated,
Erik ...
|
How to avoid BCP from adding BOM at the beginning of output file?
Wed, 27 Jan 2010 14:27:09 -0800 (PST)
Hello,
I use SQL 2000 on Windows 2003, and I have a scheduled job in my SQL
Agent that runs this:
declare @cmd varchar(2048)
SET @cmd = 'bcp "EXEC sp_select_import" queryout import.txt -c -T'
EXEC master..xp_cmdshell @cmd
This creates my tab delimited file 'import.txt'. However importing
this file i ...
|
Concatenate Mutiple Rows Data to Single RowColumn comma separated
Data
Mon, 25 Jan 2010 02:58:46 -0800 (PST)
Hi friends I m using SQL 2005 I want to concatenate multiple rows into
single row with comma separated. I tried using for XML and all but
what I m looking for I m not getting that My Table structure:-
Table A
SOANo | TaxOrderDisplay | TaxDescription|
2009001 | 1 | Excise
2009001 | ...
|
Backup Comparison and Schema Versioning for SQL Server by Devart Is
Now Released
Fri, 22 Jan 2010 04:01:41 -0800 (PST)
dbForge Schema Compare for SQL Server 2.0 compares schema snapshots,
database backups, and database changes in version control systems to
accelerate the work of advanced database developers.
Devart has announced the public availability of Schema Compare for SQL
Server 2.0, a sophisticated tool specially design ...
|
|
|
Capture SQL 2005 database transaction and replay them to test data
Thu, 21 Jan 2010 10:18:03 -0800
I just wanted to ask you a question about capturing SQL 2005 database
transactions and later replaying them on the same database in the test
environment. Is there a way to capture all transactions on a database to a
file and then posting these transactions to the same database on another
server. I understand ...
|
Index Error in SQL Server Management Studio when accessing a repor
Thu, 21 Jan 2010 09:05:01 -0800
Hello,
I am using the SQL Server 2008 Management Studio on both Windows 2003 and
Windows 2008 32 bit editions to manage several SQL Server 2008 installations,
running on Windows 2008 x64. All installations, and the workstation I'm
running the Management Studio on, are fully patched, including Service Pack 1 ...
|
where do I go to download SQL 9.0.4053?
Tue, 19 Jan 2010 19:04:01 -0800
Hello:
I know that the security update that makes SQL 2005 be version 9.0.4053 is
just that--an update. But, where can you go to download this? I can find
the URL anywhere.
childofthe1980s
...
|
