Developer Newsgroups: SQL Server Tools

Free Hot Phone Sex

AnimalSperm - 21 Jan 2006 4:02 PM - 1 message

+8613352960090 100% Free multi-lingual AnimalSperm Production el***@digi-art.de ...

Free Hot Phone Sex

AnimalSperm - 21 Jan 2006 4:02 PM - 1 message

+8613352960090 100% Free multi-lingual AnimalSperm Production el***@digi-art.de ...

SQL 2005 Management Studio bug?

Rick Razzano - 21 Jan 2006 3:44 PM - 2 messages

If I execute the following DDL: CREATE VIEW testvw AS SELECT employee_id, employee_id FROM emp_master The server *should* return the following error: Server: Msg 4506, Level 16, State 1, Procedure testvw, Line 3 Column names in each view or function must be unique. Column name ...

Data Compare

Joe - 20 Jan 2006 8:58 PM - 2 messages

I have and use Red Gate software for comparison. However; I'm at a loss on this data compare scenario: I have two tables I want to compare, but the PK-ID field is seeded differenly between the 2 tables. So when I do a comparison - every row is ...

Clean out (Reinitialize) SQL Server Database?

Joseph Geretz - 20 Jan 2006 6:02 PM - 6 messages

It there an easy way to 'clean out' a SQL Server database? I need to get a database of an unknown state back to a known state of 'empty'. Is there an easy way to drop ALL structures; TABLES, VIEWS, SPROCS, FUNCTIONS, INDEXES, ...

Logging details in SQL Server 2005 Maintenance Plan

Michelle - 20 Jan 2006 3:08 PM - 6 messages

In setting up maintenance plans in SQL 2005, I am unable to get the maintenance plans to log the details. Under the "Reporting and Logging" dialog, I do have "Log Extended Information" checked. All I get in the log ...

Database Diagrams from SQL Server

wnfisba - 19 Jan 2006 7:50 PM - 4 messages

In your experiences, what is the best way to create Database Diagrams? SQL Server Enterprise Manager Diagrams or Visio??? In SQL Server Enterprise Manager, when I create a "Diagram" and then try to "Autosize Selected Tables" it leaves a lot of white space at the top which ...

find tables in database diagram

Roy - 19 Jan 2006 4:40 PM - 1 message

I have a database diagram with lots of tables. How do I quickly locate one of the tables in the diagram? ...

WTF? SVRNETCN.dll => ...80\tool\binn instead of ...\80\toolS\binn

news.microsoft.com - 19 Jan 2006 4:36 PM - 1 message

Ok, can someone explain WTF happened to my SQL Server today? Our company has 1 licensed SQL Server, which is currently being used on our internal sharepoint site. It was an upgrade from MSDE to enable full-text, so the instance name is SHAREPOINT...not that I believe that matters. ...

Problem Alerts Management Studio

DrBob - 19 Jan 2006 1:58 PM - 1 message

In Enterprise Manager problems were easily located by the Red Icons that appeared on the Replication Monitor or Agent Jobs. How can I quickly locate similar problemsin the Management Studio Object Explorer? Thanks ...

Any better monitoring for locks and blocking in SQL2005?

James - 19 Jan 2006 12:50 PM - 3 messages

Are the facilities for monitoring locks and blocking in SQL2005 better than 2000? I found that in SQL2000 Enterprise Manager by the time you waited for "current activity" to refresh, the information could have been and gone. I'd be interested to hear if you've been using it sucessfully to do this ...

Sizing preview window in Enterprise Manager

Morgan Wade - 18 Jan 2006 9:02 PM - 4 messages

Hi there, Can anyone tell me how to set the size of the preview window that comes up when you double-click a stored procedure or function in Enterprise Manager? On my instance its tiny and difficult to use, I always need to copy and ...

Free mp3's

Jickles - 18 Jan 2006 6:48 AM - 1 message

<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>And much more that that!</P> <P><A href="[link]">[link] ...

Re: Remote SP debugging from VS 2003: error

test - 18 Jan 2006 4:45 AM - 1 message

I 'm still getting the error: "Cannot debug stored procedures because the SQL Server database is not setup correctly or user does not have permission to execute master.sp_sdidebug." I have configured DCOM on the remote sql server according tothe MSDN ...

SQL Server 2005 management studio the summary window lost object l

Charts - 17 Jan 2006 10:10 PM - 2 messages

With SQL Server 2005 management studio, I found from time to time the summary window no longer showing the object list by clicking the left pane of object browser tree notes. I tried to refresh, close the summary window, and reopen ...

SQL Server Remote Access Tool

ekowalow - 17 Jan 2006 8:42 PM - 8 messages

Is there a SQL Server remote access tool that can be placed on a desktop? I'm looking for a tool that can access the SQL database without giving a user full server rights. Thanks. ...

Script Utility

baddy - 17 Jan 2006 12:43 PM - 2 messages

I relied a lot on scptxfr.exe in SQL Server 2000. It does not ship with the new version of SQL Server and does not work with SQL Server 2005 either. What's the equivalent of that scripting utility in SQL ...

database migration

ben - 17 Jan 2006 9:49 AM - 2 messages

Hi, I wonder wether a software or a device (or script) allowing to migrate data from an existant database to a new database by using correspondant ODBC drivers existed. Thanks for your help. ...

SQL SERVER 6.5

Antero - 17 Jan 2006 12:40 AM - 2 messages

I am running SQL Server 6.5 with NT 4.0 server, but the MSSQL Server service is nor running, when I try to start it there is a "Setup" error message: could not find INF source file check the /i parameter, and then there is ...