Developer Newsgroups: SQL Server Tools

SQL 2005 Management Studio: File Extension: Adding: How to?

Chuck Hawkins - 17 Feb 2006 6:04 PM - 3 messages

I'm working with GA Management Studio on Windows XP SP2. I have a file with a UDF file extension (user-defined function). When I open the file in Management Studio, I cannot execute the file. I'm going to Tools-Options, Text Editor, File Extensions. I then add the UDF ...

Tools with/for Express

Tom Ellison - 17 Feb 2006 5:04 PM - 7 messages

I've been using SQL Server 2000 and MSDE intensively ever since it was introduced, and 7.0 before that. I have a specific requirement that will be served by Express 2005. Initially I only need to be able to create a table using a script, copy data ...

SQL Agent debugging

Ken Abe - 17 Feb 2006 4:08 PM - 4 messages

I'm connecting to SQL Server 2005 using Management Studio. I copied a table to another server using the "Export Data" facility and opted to save the SSIS package on my server. Then, I created a Job that runs the package as its only ...

Input File Variables

mrprice - 17 Feb 2006 2:35 PM - 5 messages

I am using an input file with osql to run a rather lengthy script (osql -n â€“iLoad_It.sql). Is there any way to pass command line variables into the Load_It.sql script? Thanks, Mark ...

Germany Super Sex Hotline Live FREE!

¦Qþ¶ý - 17 Feb 2006 12:59 PM - 1 message

The latest interactive Sex Hotline! Call +49 4489 5198 Free! Multi-lingual! ...

Problem going from Lotus Notes to Query Analyzer

Toddz - 17 Feb 2006 11:53 AM - 1 message

When I go from Lotus Notes inbox (R5.0.11) to Query Analzer (8.00.194), my queries go slow, even just " select 'a' ". Anbody else come across this? ...

Tool for printing SQL Diagrams

Pasquale - 17 Feb 2006 8:10 AM - 1 message

Does exist a method to export a SQL Server diagram in a Word document? Many thanks ...

Query Analyzer Debugging - Won't stop at breakpoint

JL - 16 Feb 2006 9:30 PM - 4 messages

Hi all, I am trying to debug an SP in Query Analyzer but after I've specified the input values, as soon as I click on the "debug" button, the debugger will skip all my breakpoints and finish the SP. ...

stored procedures not "refreshed" in Query Analyzer

Brian Connors - 16 Feb 2006 3:14 PM - 3 messages

This problem appeared two days ago. I'm using SQL Server 2000. I create stored procedures in Notepad, then copy and paste them into a blank query window in Query Analyzer; then I click on the buttons to check the ...

Error 14258: ... SQL ServerAgent is starting

vsiat - 16 Feb 2006 11:55 AM - 7 messages

Whenever I attempt to edit/run/... a scheduled job, I get the error message: "Error 14258: Cannot perform this operation while SQL ServerAgent is starting. Try again later." I also notice that all scheduled jobs have "Date/time not available" in ...

query analyzer table owner

g - 16 Feb 2006 2:04 AM - 4 messages

i have a table owner of sysdba so when writing queries as sa I have to prefix the tables... sysdba.[TableName] but when I do a trace it shows as just [TableName] as the sql commands are executed by sysdba, is my guess. I ...

Sql Web Data Administrator hangs

the friendly display name - 15 Feb 2006 8:07 PM - 1 message

Anyone uses this tool? [link] Anyway, I do, and I have following problem: It hangs. If I try to login, nothing happens, it just hangs. Whether I try mixed mode or integrated ...

workgroup SQL server database backup to a second server

Albert - 15 Feb 2006 5:26 PM - 3 messages

How can you backup a sql database to a different server if the sql server is installed on a standalone workgroup server? The issue is that there are several sql servers each installed on stand alone workgroup servers. We want ...

hotkey to uncomment

g - 15 Feb 2006 5:22 PM - 2 messages

CTRL-SHIFT-C comments code, what do you use to uncomment? I searched online help and googled and for the life of me cant remember ...

Any Program or Tool that helps in convertion ???!

alabdulelah - 15 Feb 2006 3:52 PM - 2 messages

Hi, I need a tool or a program that helps me to convert an MS SQL backup database file with the ( .bak) extension into ( .sql) , I need that urgently please. Many Thanks in advance. Alabdulelah ...

Visio

Gary L - 14 Feb 2006 5:35 PM - 2 messages

Since I've not had much luck playing with the database diagram to put it in some format you can actually see and manipulate I attempted to reverse engineer into Visio. Unfortunately Visio does not support SQL Server 2005. ...

SQL MANAGE - solution for MS SQL servers

Igal - 14 Feb 2006 2:30 PM - 1 message

SQL Manage, your automatic DBA is the leading software solution for easy, effective and intuitive management of MS SQL Servers. Now when so many organizations are using SQL Server we decided it's about time to manufacture a management tool that will save you operational costs while getting your ...

roles ermissions view in sql2005 vs. sql 2000

JÃ¼rgen Kliegl - 14 Feb 2006 11:56 AM - 1 message

Hello, in sql2000 i see all objects of the database in a grid with marked check-boxes for the permissions belonging to that role. How can I obtain this view in sql2005? ...

Indexes

g - 13 Feb 2006 5:30 PM - 3 messages

when dropping and recreating indexes, is there anything else that needs to be done? I keep hearing the phrase rebuilding indexes... thanks ...

ANN: Database Workbench 2.8.1 released!

Martijn Tonies - 13 Feb 2006 10:03 AM - 1 message

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: Database Workbench 2.8.1 has been released today! What is Database Workbench? A database developer IDE that supports, amongst others, Microsoft SQL ...

SQL stored proc source control

Vi - 13 Feb 2006 5:15 AM - 3 messages

Hi, I have a Visual SourceSafe 2005 server, another server with SQL Server 2000 and I'm using Visual Studio 2005 on my workstation. I want to be able to add SQL stored procedures to VSS, and to be able to ...

Just how to navigate SQL Server?

sqlservernewbie - 13 Feb 2006 12:18 AM - 7 messages

Dear experts, I'm an Oracle guy, looking to pick up SQL Server. I've installed SQL Server 2000 on XP (home). I'm now trying to navigate SQL Server. In Oracle, I would just open SQLPLUS, and query away. ...

Cannot create BI package get funny error 0x8002801D Library Not

Martin - 12 Feb 2006 11:38 PM - 3 messages

sql server 2005 0x8002801D Library Not registered when opening a temp file? How do you fix this, tried uninstalling BI and reinstalling same error? ...

Diagram to Image

Beau Peep - 12 Feb 2006 9:36 AM - 7 messages

Hello I have created a Database Diagram for the tables I have in the database and set the relationships of the tables with the fields. Now I want to export this diagram to the Image format (jpeg, gif or any ...