Hi everyone! How can I do to debug a Stored Procedure in SQL Server 2005 from SQL Server Management Studio? I looked for the Debug... option when I right-clicked the SP but it seems that in SQL Sever 2005 doesn't not exist. Thanks. Jaime Lucci ...more >>

Hi, Sorry am a bit new to this, but i have a sql2005 installed on both my laptop and the network server, however on my laptop i can't seem to be able to set up access to the sqlserver on the database server (unasysserver), I can access it directly on the server but can't seem to get access ...more >>

Hi there I use DTS to import data into a SQL Server database for archive purposes. After I do a DTS import, it can happen that I have, say, a 1GB .MDF file and a 4GB .LDF file. I then backup the database, selecting the option to remove inactive entries from the transaction log, but this doe...more >>

I have the following task, doing it by hand would take just an increidible amount of time, perhaps a query can be done to update an entire table ? This is the scenario. Table A has a field called "UserId", this will be my source "Id" Table B has a field called "OlduserID", this is the "Id" ...more >>

Hi I am new to SQL Server (which is why I chose this newsgroup for my post) and have a question or two. I have a test database that I want to be able to deploy on the local sql servers of my fellow developers (and ultimately to a production server). I have used SQL Server Management Stud...more >>

I have database A and database B on the same server I want to select from database A and create a new table in database B with the results. This is my query as of now: Select userid, tempimmproapplicantid, improtype, linktothisapplicantid from Users where tempimmproapplicantid is not null...more >>

Hi I am using access mdb as a front-end to sql server 2005 express. I took away the permissions for windows authentication to stop users from importing data. So I linked the mdb using sql authentication. But when I click on the linked table, I am not allowed to view. It defaults back to win...more >>

how can i mannage by code changes in an existing table propeties - add/remove a field, chang char length and so on? ...more >>

I'm trying to devise syntax to assign a value to a variable from a field in the table, where the variable is a different value each time through the loop. Obviously this would be an array solution in a normal coding environment. Is there anything I can do in T-Sql to emulate this? This proc...more >>

I have completed an SQL statement that displays data using SELECT. I would like to put the SQL in a View so my user could open it easily. But, I need to sort the first two columns alphabetically. To use Order By in a View, I understand that I need to include a TOP clause. Can I use TOP 10...more >>

I am trying to set a variable=1 or 0 based on a condition. If the value in a field (char data type)='01', then I want to have @MyVar=1, else @MyVar=0. MyVar is currently a tinyint. I have tried the CASE statement: DECLARE @MyVar TINYINT SELECT @MyVar= CASE WHEN FieldValue='01' THE...more >>

I have a table with a single field (varchar data type). Record #1 has about 125 characters in that field. When I display the table using a SELECT command, I would like the width of the displayed field to be enough to display all of the 125 characters on one line. When I run the SELECT que...more >>

Is there any way to add instructional text to a view. My user will open a view and not understand some of the data in the displayed table. The only workaround I see is to create a new table with one field: Instructions. In the table I enter instruction 1 as record 1, instruction 2 as rec...more >>

In a SELECT command used in SQL Query Analyzer, I have written the following code. With three functions in sequence (CAST, CAST, Round), the code seems unnecessarily complex: CASE WHEN MyVar1='01' THEN CAST(CAST(Round((MyVar2)/22.0,0) AS int) AS char(5)) ELSE '-' END AS Core_Tools MyV...more >>

I am replicating a SELECT statement from Microsoft Access to SQL Server. In Access, the SELECT statement used in a query is: AS SELECT Unit AS Facility, IIf([Mod_Compl_Intro]="1" Or [Mod_Compl_Intro]="-1","Complete","-") AS Introduction FROM User_Data_Table If a record contains 1 or -1 ...more >>

A few days ago, I asked for help getting the Northwinds db into SQL Server 2005 Express. I was pointed to http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en I downloaded this, but cannot figure out how to get it into SQL Server 2005 ...more >>

Hi, A user deleted some data and I'm trying to restore the database up to a certain point in time. My backups are going to a network drive and I see the backup and log files that I want to use for my restore. Before I started the restore, I issued a manual complete backup of the database ...more >>

I develop intranet-based training that connects to a database. My training products are sold to customers. Because of a large customer, I am trying to replicate an Access database (used in the past) to SQL Server. I obtained the developer edition of SQL Server 2000 and have developed a new ...more >>

Hi, If anyone can explain why this is happening, it would be greatly = appreciated: Problem Description: 1. Within SQL SERVER ENTERPRISE QUERY ANALYSER, an SQL statement is = entered=20 and executed. No results are returned. SELECT ID FROM PRODUCT_TABLE WHERE=20 ID NOT IN (SELECT ...more >>

I develop computer-based training with a database for customers. The database works with the computer-based training piece to store user results. I am currently trying to replicate an Access database in SQL Server. For large customers, Access is no longer adequate. I obtained the devel...more >>

Is there a way to restore a dropped table??? ...more >>

Like a lot of people, I downloaded and installed the free Express versions of SQL Server 2005 and Visual Web Developer (for ASP.NET). I'm walking through one of the Walkthrough tutorials that came with the Web product, and in the beginning it tells me that the Northwind database is a prerequi...more >>

Been doing triggers for years in sql 2000 now I find I got triggers that = worked in a previous versions but I can no longer just pick up and = paste my code in sql 2005 triggers. One sample. I'm in mydb on myserver and have a table mytable with two fields = LastupdateOn and LastUpdateBy, I wan...more >>

Hi, Any help would be greatly appreciated Can anyone give me a detailed example?,I cant get this to work I have stored procedureA which has one input and one output variables. I also have stored procedureB which takes in the value of the output variable from stored procedureA and performs a ...more >>

How do I update a date field to reflect a specific date? My field is formatted at smalldatetime. I've tried: UPDATE dbo.Dealers SET dbo.Dealers.BillQ2 = 2005/11/14 FROM dbo.Dealers, aipdn.qtr2 WHERE dbo.Dealers.DealerCode = aipdn.qtr2.DealerCode And I've tried it as 11/14/2005 also. ...more >>

Had a create trigger button that was east to use in Enterprise manager, Don't see it in the standard buttons in the new 2005 management studio. Was that functionality removed? If not where is it. Thanks for any help, Bob ...more >>

Can anyone tell me how to remove a comma ',' from a text field? I am coping records to a csv and it is separating my text field into two columns when it finally reaches the CSV. SQL Server 2000 SP4. It is also wrapping some rows to 2 or 3 lines. My query I am using is: Select notes fro...more >>

is their a way in sql code to do jobs like copy files on disk, create folders ect...? ...more >>

Can anyone tell me how to remove a comma ',' from a text field? I am coping records to a csv and it is separating my text field into two columns when it finally reaches the CSV. SQL Server 2000 SP4. Txs. Select notes from rn_appointments results: Col 1 Col2 How do y...more >>

I have a field that is set to autonumber (identity type). As records have been deleted, i found that new inserted records does not reused the number (autonumber). Any way to solved it??? -- xxx...more >>

Hello. Please forgive me if this post is not relative to this newsgroup and if someone could advise which group I should post this in I would appreciate. Does anyone know or have any ideas on recommended software or methods in capturing data from scanned paper documents into a SQL Server 2000...more >>

Hi everyone! How can I do to copy the data and the indexes from an existing table on a database to a new table in another database? I've tried with select * into base1.table1 from base2.table2, but it only copy the data and not the indexes. Can I do it by code? I'm trying to avoid the use...more >>

is their any code for granting permissions to all objects? sam ...more >>

Hi Group I interest count the characters in the field (string), because, the result i need whit 2 characters i.e. ALCOCER = 7 I need ALCOCER = 07 If the name is has more than 10 characters. Tnks...more >>

I have one recordset with multiple values, I need to retreieve those values but instead of creating multiple recordsets I want to see if there is a way to retreieve all values in just one recordset. The queries are: Recordset 1: SELECT paramvalue FROM ParametersUsers WHERE paramname = 'do...more >>

I am new to sql, I am trying to run a job with type transact sql . But when I open the script it gives me an error saying that the sript is to large and will have to be truncated. Can anyone tell me if I can increase this space so that it accepts the script. Thanks...more >>

Hi all, I'm hoping that perhaps someone could help me with a question. I am running SQL Server 2000 standard edition. I have two databases, say A & B, what I would like to know is whether it is possible to call a stored procedure in database B from a stored procedure in database A? I've t...more >>

I installed SQL Server Express and SQL Server Managment Studio Express. The Management tool worked great for one day. Now double clicking on the icon produces nothing. I uninstalled and reinstalled EVERYTHING and it still does not launch. Any ideas? By the way, I think that it may have ...more >>

I'm new to using Sql Server, All of my data is in Ms Access. I am exploring Sql Server 2005 Express to learn how to develop applications with Visual Studio 2005. First step is to get the data moved over from Access to SQL Server. Right now I'm stumped with a Gross Conceptual Error (GCE) (an...more >>

I am new to SQL. I am trying to create a trigger for whenever a new user or permission has been added modified or deleted from a .net application database I need the trigger to update this info into the production database. Can someone tell how can I do this? Thank you...more >>

Hi group, I'm looking for a good book on Sql Server 2005. Most of the books I've found were based on Yukon when it was still in beta. Reviews on Amazon show that a lot of information is outdated and samples don't work anymore. Is there a book that's based on the released version of Sql ...more >>

Is there a way to find out what stored procedures are currently running in regards to SQL Server 2000? John ...more >>

SBS 2003 Premium edition, dual Xeon, 2GB RAM, separate SCSI hard drives for system and pagefile, data on SATA RAID5, no clients connected, only default data files. On boot-up one of 3 instances of sqlservr.exe in Task Manager grows over a period of some 24 hrs from around 70MB initially to ...more >>

Hi, I have a range of data all with DATE How can I query this data to return just those records within the last Week ? Many thanks! ...more >>

I am trying to use a case statement to pull bad phone numbers out of my company table into a readable format. I am using SQL Server 2000 SP4. The phone numbers, in my inherited database, are in any number of formats, not complete, etc, and I need to pull a report showing only the good phone ...more >>

how can i make changes in msde triggers, and procueders at the user machine as msde dosn't have develop tools? can i do it with the connected access application? if yes how? thanks ...more >>

I was wondering where I could buy just the manual for SQL Standard Edition. Thanks...more >>

I am using SQL Server 2000 SP4 I am trying to filter bad phone numbers out of my results but I cannot quite get the syntex that I need. I have phone numbers like: ++ () - + () -3681 + () -8544 + () ? + () ? + () 0-+00-00 + () 0-00 + () 0-00 + () 0-00--00 ++ () 0-00-000 + () 00-000 + ...more >>

I tried installing SQL Express one 3 machines. All failed at least once, although one (my WinServer 2003 machine) does have a successful instance now. I think. In most cases, the error I got was something about not finding a native client file. I couldn't find any info on the Microsoft site...more >>

We have had SQL Server 2000 a couple of years. When we want to use the Query analyzer, we use remote desktop to access the server where it resides, but there is an inbuilt limit of 2 sessions using this method. Is it possible to run the Query Analyzer locally connecting using ODBC? Is there a c...more >>