Hi All, Is it possible to debug a stored procedure with SQLExpress ? I haven't seen any related item on the menu... TIA Gultekin. -- ...more >>

I have a stored procedure that has two parameters that have data types of REAL. When the value is passed in, the values beyond the decimal place is dropped and the the value prior to the decimal place is being rounded up. I need it to keep the original value as passed in. If I changed the para...more >>

I received an error message in SQL Service Management Studio that said: TITLE: Copy Database Wizard ------------------------------ The job failed. Check the event log on the destination server for details. ------------------------------ BUTTONS: OK ------------------------------ ...more >>

Hi I downloaded and tried to install the sp1. It went through once completely with 'SQL Server Native Client' left out pending restart. I re-ran the set-up, this time it did the client but on the second item 'Set-up support files' it comes up with 'The following unexpected error occurred: U...more >>

I'm working on an ASP.NET project and when a query is ran, some rows returned are NULL, which is causing my app to break. The data is pulled into my webpage as a string, which I'm converting to Int32 to do a number comparison for page formatting purposes. If the value is NULL, then the NULL ...more >>

I'm preparing a new server to replace an old server, and have scripted the restoration of all user DBs so that Data files will be on RAID 5 D: and Log files will be on a faster drive L:, but I would like to have all system and user data files in the same location and all system and user log fi...more >>

Hi, I am trying to determine a couple of books that will help me understand SQL Server 2005 from a few of perspectives: Optimizing databases, specifically from SQL 2000 - I have a recommended book Pro SQL Server 2005 Database Design and Optimization Developing SQL Server 2005 based appl...more >>

Using SQL 2000 for an ASP Intranet app. When this started 4 years ago, I created two fields of type varchar, size 5000 (they were description fields, so it was possible to have this many characters). I did this because of my inexperience. Now I know that for something this size, a text field w...more >>

I created a stored proc that does a query on a table with several datetime fields. The data was exported from an access database into an SQL2000 database. Several of the fields in the access database originally held just times, and not dates. When the data was exported from the access db to...more >>

When programmming a trigger with T-SQL to response to an After update event is the trigger executed on each record affected or say on a group of records. I think it could be either way. -Fried In RI ...more >>

A user needs to run SQL Profiler, how can enable him to run this tool without assign admin rights? or Any alternative way? Thanks. ...more >>

Hello, I used SQL Server Enterprise Managers' Export Wizard with destination ODBC driver for SQL to create a dts package in the structured file format. I entered the following dtsrun line (msde 2000 sp3) dtsrun /S servSQL /U sa /P thepw /N db.dts and received the errors shown. ...more >>

In Management Studio on the search tab I receive the following error message: Search Failed No search provider has been selected. How do I fix this? Thanks, Tom...more >>

I'm trying to restricted users view of report information based on 3 digit codes found in a misc field. The Misc filed is misc2 and might look something like this (001, 002, 005, 008) including the open and close quotes. Here are some of the things I've tried. USE Test SELECT brnId, Name...more >>

tried sp_info on a sql 2005 box and got Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'sp_info'. Has this SP been replaced by anything in sql 2005? -- George...more >>

Hi All, I'd like to take a copy of all sp's and functions on a database to a text file, by using tsql not the menu. I think there are tsql commands to do this, can you help me? Gultekin. ...more >>