SQL Server Tools - Week 7, 2006

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 ...

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 ...

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. ...

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 ...

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 ...