SQL 2005 Management Studio
Fri, 24 Oct 2008 08:52:00 -0700
Can I use SQL 2005 Management Studio to manage SQL 2000 servers? Please let
me know. Thank you ...
|
How to publish schema diagrams to a web page for everyone to view
Thu, 23 Oct 2008 13:20:01 -0700
Does SQL server have any tools or utilities that I can use to publish the
diagrams to a web page? I want to make the schema diagrams available to
everyone in our intranet.
Thank you,
Omid ...
|
SQL Browser Errors Pain Domain Controller with BackupExec
Sat, 18 Oct 2008 14:59:00 -0700
I have spend endless hours with Symantec Tier 2 support resolving the
> SQL server issue but so no result. We have installed Backup Exec 12.0
> and all other componenets several time, Uninstall SQL server instance
> and reinstall it but the error don't go away even with Fresh install
> of SQL instance.
>
> Th ...
|
RE: Utility to read transaction logs
Fri, 17 Oct 2008 00:30:00 -0700
you can use RED - GATE's log rescue to recover data from accidental deletion.
or to audit transection logs . but its only works with sql server 2000. and
its free to !!
you can download it from
http://www.red-gate.com/products/SQL_Log_Rescue/index.htm
"Ellen" wrote:
> Is there a utility to read the ...
|
SQL Setup Recomendation - Maintenance Plan Not Removing .bak files
Thu, 16 Oct 2008 11:46:15 -0700
I am having the same problem on all 6 of our SQL servers with the backup job
not deleting .bak files after a certain amount of days. The Microsoft SQL
Backup job runs, but the files are not deleting, even though I have told it
to.
I am running SQL 2000 and SQL 2005.
Does anyone have a good recomendation ...
|
Sync Schema for Two Databases.
Wed, 15 Oct 2008 22:12:09 -0700
I am comparing tools for synchronizing databases. The best I have found so
far is SQL compare from Red-Gate. Does the community have any suggestion on
other products that may work that are not as expensive?
I simply need to be able to generate a script to outline the changes that
were taken from one versi ...
|
SQL Cluster Tool installation
Wed, 15 Oct 2008 06:49:01 -0700
Environment:
SQL Server Editions:
SQL Server 2000, SP 4
SQL Server 2005, SP 2 with Cummulations Hotfix (kb918222)
O.S.
Windows 2003 Server R2, SP 2
Clustered Production Environment
Node 1
Tools not installed
Node 2
Tools Installed
Summary:
I logged onto the virtual server with an admin ac ...
|
|
|
Cant create new query
Mon, 13 Oct 2008 13:50:08 -0700
From ssms 2005, when I select the New query all I get is a blank sql window.
How do I open in the query grid window? ALso why is the query designer window
always greyed out. I can't change the Query type. Thanks.
...
|
Trimming HUGE Transaction Log
Mon, 13 Oct 2008 09:45:01 -0700
I've got an Access application with a SQL Server back end.
SQL Server db is about 4 gig. Transaction log is about 10 gig. It just
seems to keep growing. I' GUESSING Access never causes transactions to be
committed, so the log file never drops those transactions.
I tried something which SEEMS to work, bu ...
|
QA Object Browser menu (not the OB itself) takes 60 seconds to appear
Mon, 13 Oct 2008 07:49:32 -0400
This problem has just started happening and I'm looking for clues ...
anything to help me troubleshoot.
When I allow the mouse pointer to hover over the Object Browser menu
item in the Tools submenu of Query Analyzer (version 800.194):
Object Browser -> [mouse is hovering over this item]
Object Search ...
|
