SQL Server Tools

Upscene Productions announces a Spring Sale with 25% discount on all database developer tools! Currently available from Upscene Productions: Database Workbench A multi-database engine development IDE, currently supporting Microsoft SQL Server, Oracle, InterBase, Firebird, MySQL and NexusDB. IB LogManager Suite ...

Where find SQL Profiler in SQL 2005? Reginaldo/ Brasil ...

I downloaded SQL Server Express yesterday for the first time.  I used the BCP utility a couple of times without incident but then it stopped working.  I received a message reading "BCP is not a valid Win32 application".  I uninstalled and reinstalled SQL Server Express but it ...

Hi, Is it possible to include the db diagrams when using the SQL Server scripts wizard  in management studio on a database (SQL Server 2005)? If not, why not? What is the best pratice to export these diagrams for documentation, for ...

Return code was 0x80004005 Windows XP Pro PC installed SQL 2000 Enterprise manager Query analyser works but Enterprise manager generates a Snap-in failed to initialize. Name: <unknown> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F} I've tried unregistering the dll referenced in registery, deleted, and ...

Hi, I am using SQL Server 2005. I have created the tables for my Database through the Management Studio front end tool. I can apply a primary key to the tables easily enough. What I am having trouble with is assigning multiple columns as primary keys and also how to ...

Hi, How do I (programatically) find the last date/time the database was used. Even better would also be to find how much time the database has/is being used. Some background: I'd like to write a custom tool to clean out some of our development ...

I have a new SQL server, Windows 2003, SQL 2000. I had planned on NOT putting MAPI on this server, given that it's been troublesome in the past. On my other servers, I have MAPI installed, and when it gave problems, I ...

Let me preface by saying that I'm not a DBA-type person.  I'm more of the network guy who truly hopes to have an honest-to-God DBA hired on within the next six months.  I'm the interim DBA without much DBA knowledge just backing ...

In SSMS05 , Tools > Options > Text Editor > Plain Text > General > Line Numbers I check the box , but no line numbers show in the .sql windows. ...

I've installed SQL SP4 on Win2k3 server std. edition.  I keep seeing login failures about 3 per minute for the nt account sql is running under.  I don't see any jobs failing or services.  The agent is running without issues.  Any ...

Hi everyone, I'm totally new to SQL and could use all the help I can get!  I was wondering what SQL resources does everyone use?  Books, links, sites, magazines, forums, etc.???  Any feedback would be greatly appreciated! ...

I have a web app that uses database mail in a stored procedure on SQL 2005. The mail is being sent, but the code is causing the ASP pages to error out with this: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) ...

I use MS SQL Server Express 2005 (the 'unpaid' version). I managed to create a backup of my database using an option onder 'Server Objects'. My questions: 1. Is it possible to schedule this backup or is this only a feature of the ...