Developer Newsgroups: SQL Server Tools

file damage and repair

Brenton D. Glisson, MD - 10 Feb 2006 5:12 PM - 2 messages

I have been trying to restore a backup file (BAK) in SQL 2000 ENT SP4 on a WS 2003 ent server. When I try to restore it reports that is not the correct tape backup type. This file was backuped to my hard drive, not a tape drive. ...

Read80Trace.exe in SQL Server 2005

baddy - 10 Feb 2006 4:40 PM - 11 messages

My present production environment is in SQL Server 2000 and we are planning to upgrade to SQL Server 2005 soon. I use the profiler a lot and then use Read80trace.exe to process the trace files. However, the Read80Teace does not accept a trace file from SQL Server ...

Scripting options

Louis Davidson - 10 Feb 2006 12:44 AM - 2 messages

I hunted (way too long) for a way to script only certain object types in management studio today (and yesterday) and so here I am :) Is there a way to script only check constraints? Or only primary keys? Etc? I was trying to change the datatype of a bunch of columns to try to ...

Last Access to the Database

dotNetDave - 9 Feb 2006 10:04 PM - 2 messages

Is there a tool for SQL Server 2000 that will tell me the last time all the databases were accessed on the server? I'm trying to detemin which databases are not used anymore or not very often. Thanks, David ...

Documenting SQL Server 2000 + 2005

info - 9 Feb 2006 9:44 PM - 1 message

Fact: Documenting databases is not the most pleasant job , it's a boring job and you loose a lot of time (Do you recognize this feeling?). But: database documentation is important and necessary if you want to grow, adapt it easily in the future etc. ...

Where i can find tool "Object search" (as for instance in Query Analyzer) in SQL Server Management S

Sergey Fedorenko - 8 Feb 2006 10:55 PM - 2 messages

Where i can find tool "Object search" (as for instance in Query Analyzer) in SQL Server Management Studio 2005? Thanks ... Serg ...

Database Diagrams

michael - 8 Feb 2006 6:58 PM - 7 messages

I have a SQL 2000 database that I imported into SQL Server 2005 by restoring the database from a backup. I carefully re-did the Users to make sure there were corresponding Logins. I want to create a Database Diagram using the Microsoft SQL Server ...

SQL Server Management Studio for 2005

Lee - 8 Feb 2006 5:10 PM - 1 message

I'm a little tired of getting this errors which render the summary pane unusable. Is there a fix for this? See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ...

New server: the tuning advisor don't consume the worjload...

Jéjé - 8 Feb 2006 2:35 PM - 1 message

Hi, I have just installed a new server, and like another one the database tuning advisor don't do its job! the consuming workload and performing steps still at 0% for 1 hour (which is the default timeout value) I do it against a simple select * from mytable query statement, so there is ...

Count Rows in Statusbar

peppi911 - 8 Feb 2006 1:56 PM - 2 messages

Hi, ig i use QueryAnalizer i get the number of Rows in the statusbar, which is really helpful. Usually i use Enterprise-Manager for creating queries, does anyone know how to get the result here too? Is there a switch somewhere? ...

OSQL spelling mistake?

Robin - 8 Feb 2006 1:25 PM - 2 messages

Hi, has anybody else noticed a spelling mistake when using OSQL utility with the -E -L switches. It reads The -L parameter can not be used in combineation with others parameters Robin ...

can not find the relationship in 2005

Mattias - 7 Feb 2006 7:09 PM - 8 messages

I have a few database that was created in SQL Server 2000. Now I have 2005 installed and I can see the db:s in SQL Server Management Studio But how do I display and edit the relationsships.....can not find it here! ...

What is SQL2005 final build number?

Clayton Sutton - 7 Feb 2006 1:33 AM - 6 messages

Can someone please tell me what the fnal build number is for MSSQL 2005? I just took over a network where the old admin did a lot of playing around on the network and installed a lot of "Test" software. This includes MSSQL ...

bcp accent problem

Sitar - 6 Feb 2006 9:31 PM - 25 messages

Hello, I'm importing data from formatted text files with accent (Latin1). My database is set to French_CI_AS. I use bcp with -C"Latin1" or -C"French_CI_AS" but bcp seems to ignore the flag and every single accent is ...

Tools to create jobs and backup devices

AWilliams - 6 Feb 2006 6:46 PM - 2 messages

Hi, I am trying to locate a tools(s) (SQL 2000) that can automate the creation of jobs and backup devices. I know I can use the maintenance wizard but I want to be able to see the 'Jobs' and 'Backup' devices in the Management ...

SQL Server 2005

Mathivanan - 6 Feb 2006 2:00 PM - 4 messages

Hi All, I am getting the below error while installing sql server 2005 in windows 2000 Server. The setup has encountered an unexpected error while wizardfirst. The error is :Fatal error during installation Kinldy help me in installing the same. ...

Select and ID Column

AwAnvil - 6 Feb 2006 1:31 PM - 4 messages

I had posted a question last week about about a getting rid of duplicates in a select statement that was answered thanks to people on this forum. After working on it I ran into a problem this weekend. I have the following SQL statment that returns the correct number of ...

SQL2K EntMgr DB Taskpad View - Where do all the indexes come from?

Paul - 6 Feb 2006 12:15 PM - 2 messages

Hi, When I use taskpad view in Enterprise Mgr on a DB I can see a lot of indexes that don't appear under the index view in Q.A. or in Manage Indexes in E.M. Where do these come from? ...

Network Monitor

Praetorian Guard - 6 Feb 2006 9:43 AM - 3 messages

Hi NG, #1: Is there a utility from microsoft that can monitor who is connected to our Windows 2000 server similar to netwatch.exe from the resource kit but instead of monitoring the shared folder I would like to know who is ...

Query Analyser can only open my tables in read-only mode :(

Steve Terepin - 6 Feb 2006 8:11 AM - 2 messages

I've got a database on my local machine whose tables come up as 'read-only' when I open them using Query Analyser - although when I open these same tables in Visual Studio or Enterprise Manager, they are NOT flagged as ...