SQL Server Tools

I have seen database diagrams of a sql server(2000) database in Visio(2003).  I need to create a similar diagram in visio with my DB.  Anybody know how to do this?  I opened up Visio, selected New/Databases/Diagram... then what? ...

A useful, free, little utility, xSQL Object Search, is now available for all of you out there who were used to that search functionality on SQL Server 2000 and were disappointed when you realized you can't do the same thing on SQL Server 2005. xSQL Object Search does for SQL ...

What are the ways to find the outcome details of maintinence plan? Is it something have to do with Activity monitor, sqlagent.out, file_yyy.mm.dd? Thanks. ...

Using SqlExpress 2005, I have a database with over 1000 stored procedures for a project still in development. From time-to-time I need to script out the stored procedures for backup or transfer to another system. For the past ...

I have got sqlserver(IA64) 2005 SP2 evaluation version installed and the sql server management studio has not working on Windows server 2003 Enterprise Edition SP2 Itanium 2. Now when I try and open it up object browser then nothing and closing the management studio. ...

Hi all! I'm getting an error trying to install the Management Tools either on the server hosting SQL or on my workstation. Not sure of the reason, but whenever I try it goes through the installation fine until it gets to actually ...

SQL 2000 & I've got sp4 installed. In Query Analyzer, when I open a query window on a 1600x1200 monitor, the end of long tsql commands DISAPPEAR! It's like about 5% at the far right of the screen is invisible. If I set the Query window into a non-maximized ...

I had to have a new profile setup on my PC as there were some issues with my old one, now I'm in the process of trying to get my new one to the same point, well not to where it won't work but so that I have my favourites and ...

I am by no means an SQL expert, I need to figure out if doing a nightly reindex defrags my indexes.  From the data below it seems pretty obvious it doesn't, but I am unsure. I ran a DBCC SHOWCONTIG and I have a index that appears to be absolutely a ...

Feeling realy dumb here, when I right click a node I do not have the Reports or Custom Reports option.  Anyone tell me what I am not doing right. Thanks Rick ...