SQL Server Tools

Is anyone out there using dbLockdown? Does anyone have any feedback to offer? Thanks, Keith ...

I was just saddled with SQL Server 2005 Express after having SQL Server MSDE.  I was able to use Enterprise Manager to schedule database backups automatically.   Is there a tool that works with SQL Server 2005 Express that allows me to ...

Hi, I've installed SSMA Extension Pack 2.0.0.380 and SSMA 2.0.0.380 In SSMA I'm choosing source Oracle 9.2 database and then the following error message appears: "Server components have inconsistent versions.Some features may work ...

does someone know how can i create a linked server from sql server 2005 to sybase 11? did it really worked for someone ? ...

All Anyone know what is truly recommended for the NIC settings for SQL 2005 when installed on Windows 2003? Microsoft SQL MVP and SQL author: Mark L. states that the NIC should be set to: "Maximize date throughput for file sharing." ...

SQL 2005 workstation components, configuration tools, analysis services, performance tools & management studio installed.  Can't find maintenance plans.  Have installed full integration services.  What specifically needs to be installed in 2005 to get to maintenance plans? ...

I need to set up a Maintenance Plan on a 6.5 DB. I know the version is old but the customer cannot upgrade at this time. When I try and run the wizard to set it up I get a warning about running a plan on a DB that is larger that ...

Is it possible to change the default backup file location? ...

Hi All , I did accidently  truncated one table from sql server. when i check the backup deveice  not working. Is there any way to restore  the data from ldf  file. Please  help me anyone know about this. ...

This picture outs tears in your eye...:'(:'( [link] [link] [link] ...

This picture outs tears in your eye...:'(:'( [link] [link] [link] ...

HELP!!!!  I've been using SQL for years, and I support a product built on top of SQL Server.  Many of my customers are starting to upgrade to SQL 2005, but the ones that are not "SQL inclined" are having problems modifying data.  ...

On the 15th Day of The Israeli Aggression : A total of 958 deaths since the beginning of the war, over 3,369 wounded, 915,762 Displaced, and the world is still silent! THIS IS THE LEAST WE COULD DO FOR : LEBANON! Look at those pictures [link][link][link][link][link][link][link][link][link][link][link][link][link][link][link] Tell your friends about what is going on! ...

In SQL 2000, it was easy to view the details for a database and transaction log by changing the view of the database in the SQL Enterprise Manager. With the new Microsft SQL Server Management Studio for SQL 2005, I cannot ...

Hi,     Is there a way to delete the trace files on the sql server without using xp_cmdshell. Since, xp_cmdshell can be disabled in SQL Server 2005 I dont want to go with this option.     This option should work on both 2000 as well as 2005 :) ...

Hi, As a certified DBA in 2000 I've done hundreds of views in Enterprise manager.  I've just started to get my teeth into 2005. As one of my first forays, I thought I'd whip up a typical view.  No ...