Developer Newsgroups: SQL Server Tools

select for update

jeffchirco - 9 Mar 2007 7:47 PM - 4 messages

I am a Oracle DBA new to SQL Server. We actually have a small MSDE database running here. How do I select records for update so if somebody tries to updates I have locked they will get an error. ...

Can't Export to a Fixed Width Flat File - No Row Delimiters

Dennis - 9 Mar 2007 6:31 PM - 1 message

We're in the process of migrating from SQL2000 to SQL2005. One of the first steps we've taken (after testing & evaluation) is to give the 2005 Client Tools to a couple of test groups in our department. ...

Customize SQL Server Management Studio (or Express)?

CLRG - 9 Mar 2007 12:25 AM - 1 message

Is there any way to customize the SSMS or Express? SSMS seems to have the same codebase as Visual Studio, so would the Visual Studio SDK work? Curtis Chief Software Fanatic - [link] ...

Permission required to run the Profiler and the Debugger

Cordelia - 8 Mar 2007 11:59 PM - 3 messages

Does anyone know what permission to grant (other than SA) in order to enable the usage of SQL Profiler 2005 and the debugger on a 2005 installation? thanks Cordelia ...

ANN: MS SQL Maestro 7.3 released

Vadim Vinokur - 8 Mar 2007 3:21 PM - 1 message

SQL Maestro Group is happy to announce the release of MS SQL Maestro 7.3, a powerful Windows GUI tool for SQL Server 7/2000/2005 administration and development. The new version is immediately available at [link] ...

Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services

Se0 Guy - 8 Mar 2007 4:10 AM - 1 message

Search Engine Optimization [link] Seo Optimization , Semantic Results, Artificial intelligence in Search, Auto Content Generators, Search Engine Results. SEO optimizer. SEO consulting ...

Save Query Designer Layout

Rob - 7 Mar 2007 5:42 PM - 3 messages

I launch the Query Designer from the Microsoft SQL Server 2005 Management Studio to design some queries. Can anyone tell me if there is a way to save the graphical layout of the tables, joins, etc.? Am I missing something ...

Comparing table structure

Gaspar - 7 Mar 2007 12:55 PM - 2 messages

Is there any tool to compare table structures between two databases? For example: When comparing Table_A and Table_B, which fields are missing, which relations are missing, etc. Thanks, Gaspar ...

Microsoft SQL Server 2005 SP2 Issue

Ed Lehman [MSFT] - 7 Mar 2007 1:09 AM - 2 messages

An issue was recently discovered with SQL Server 2005 SP2 which might impact customers using cleanup tasks in Maintenance Plans and SQL Server Integration Services packages. The issue is described in detail at [link] We have created a General ...

Missing events in sql server 2005 profiler

john conwell - 7 Mar 2007 12:19 AM - 4 messages

I just opened sql server 2005 profiler for the first time and I only have 4 event categories and a total of 6 events!!!!! I know this cant be right. Am I missing a configuration setting somewhere? ...

SQL Server export can't use datetime for new Access 2007 ?

mibainfo - 6 Mar 2007 4:45 PM - 1 message

Hi, I have problem with exporting data from SQL Server database to new access format. Exporting provider : Microsoft.ACE.OLEDB.12.0 Error message: Column information for the source and destination data could not be retrieved, or the data types of source columns were not mapped correctly to ...

Stopping a Restore

BetR - 6 Mar 2007 4:18 PM - 3 messages

I stopped a restore right after it started and the database still appears to be restoring even though no processes are running against this database. Does anyone know what happens when you stop a restore? Is there a system ...

Copy Database Wizard : where is it?

Oscar - 6 Mar 2007 8:24 AM - 2 messages

I own an MSDN subscription. After I installed SQL server 2005 I've noticed that it shows SQL Server 2005 Express. For a reason that I don't know it doesn't show a Copy Database context menu right after right clicking at a database. I also don't see any wizard in ...

Moving databases to a different partition

Don Murphy - 6 Mar 2007 12:23 AM - 7 messages

Is there a good resource that shows how to move the database file from one drive partition to another for SQL 2005 SP2? This is a new server with the default database getting ready for Sharepoint. Right now I start "SQL Server Management Studio" and drill down to database ...

Bug or By Design

Glenn Coello - 5 Mar 2007 5:56 PM - 2 messages

TableA contains FieldA varchar(10) NOT NULL TableB contains FieldB varchar(10) NULL Using Query Analyzer SS2K SP4 I run two queries. SELECT FieldA from TableA WHERE FieldA NOT IN (SELECT FieldB from TableB) - this query returns 0 rows ...

Renaming a diagram in SQL Server Management Studio

Paul J - 5 Mar 2007 12:31 AM - 6 messages

Hello, I have MS SQL 2005 installed on my server. When I tried to rename a diagram, I received an error. Is it possible to rename a diagram, or I need to create a new one and copy the contents? Does this problem exist only in my ...