Hello, I need to create a AK from two columns in a table. Both columns are int types and I need the new AK column to look like P0000-0000 how do I do this? Bryan ...more >>

I am trying to create a database website for a company that I work for. When i do the database editor I can connect to the sql server and my submission form works but if I try to edit data I get this error on the web page... Database Results Wizard Error Description: Incorrect syntax near ...more >>

I have an existing installation of SQL Server 2000 configured for Windows authentication. I have a new application that requires SQL Server and Windows authentication. If I install SQL Server 2000 on this server again, am I creating another "instance"? Is the authentication method specific ...more >>

Hi, I use a numeric field (vs. nvarchar) to log the KM of a vehicle because I'd like the data to be displayed with the 1000 separator (123.456). In a web page, the data is displayed with decimals (123.456,00). I removed the decimal setting in the server's regional configuration with no avai...more >>

I want to move a copy of a database (bak file) to my local machine so I can have access to the data offline. My goal can be thought of as copying a database, data and structures, to my local machine. How do I do that? Do I restore it? When I try to restore it using Enterprise Manager, I see...more >>

Can I print off something that has all my tables and their column names along with all the relationships between them???/ ...more >>

how can i automate sending emails from sql server? can it be sent with attachments? thanks ...more >>

I have a 20GB database and i recently delete a 2GB table from it, but still it shows as 20GB database. I have done a backup on both transaction log and ..data file but it didn't help. any idea how can i free up that 2GB space? Thanks Hooman ...more >>

Is there any way of finding all of the database objects and their permission settings that are assigned to a role in SQL 2005? This was available in SQL 2000's interface :-(] THANK YOU VERY MUCH!!! :-[) ...more >>

I am trying to setup a domain user to that will be used to start-up the SQL server and agent services. I am on a 2003 domain using SQL 2000 SP 4 The domain user is not part of the local administrators group where the SQL Server is loacted but I have assigned the local policy privileges as ...more >>

I am trying to use several tables that have one 10-character text field in common. Most of the records have a numeric expression, but some tables have leading 0's, and some don't. I can't cast the field to numbers because there are some records that have letters also. What function can I us...more >>

Been struggling with this for way too many hours. I am trying to get a database copied from one location to another. The place it's coming from is SQL Server 2000. The destination is SQL 2005. They are not on the same network and I cannot connect them to do an import. First, I tried detachi...more >>

Need to change part of a field, and I 've been running some tests in pubs. This gives me and error> update authors set substring(phone,5,3) = '888' where substring(phone,5,3) = '826' this is the error > update authors set (substring(phone,5,3)) = '888' -----------------------------...more >>

Hi guys I am trying to import a text file into sql server but sql doesnt let me do that. My flat file is in the txt format. Here is a part of my txt file Indicatorid,IndicatorName,Reportingquarter,SourceDate,DHB,DHBName,PHO,PHOName,Practice,PracticeName,Practitioner,PractitionerName,NHI,DOB,...more >>

How to use local format file to bcp local data to remote server? If I use a local fmt file then system reponse "could not find the driver". If I use DTS to bcp to a remote server, I only can find the remote server's driver... Is it possible to use bcp (local data & fmt file) like that ...more >>

I got this error the other day any ideas? Event Type: Error Event Source: VSS Event Category: None Event ID: 6004 Date: 7/19/2006 Time: 8:47:58 AM User: N/A Computer: TGKW001 Description: Sqllib error: Database WrestlingHistory is not simple. For more information, see Help and Supp...more >>

Hello, I want to do a global search and replace in my SQL database where the data type could also be "ntext". I did find the code which works for (char, vachar, nchar, nvachar) Thank you for your help regards ...more >>

Is there any need for SQL standard Logins, other then for non-MS systems like Unix to be able to connect?? Shouldn't all users (who are all using WINXP systems) be able to do what they need to through Windows Auth? Please help me out here I just want to be sure, and hear any other ideas, I...more >>

I have done this before with no problem, so I don't understand why I can't do it now. I have a SQL 2000 database, which I want to copy over to another machine. It happens to have 2005. I understand that I can't detach and attach a 2005 database to 2000, but I should be able to go from 2000 ...more >>

Hi folks, I'm new to SQL Server 2000, obviously, and I need help with the following task: I have a server with 2 instances running. I need to stop all access to one of these instances until further notice. I have tried stopping the service, but I notice that it keeps restarting. I test...more >>

Hi guys I am trying to learn how to use stored procedures..I am quiete familiar with sql server 2005 but i have never used stored procedures. We have been asked to run some validation checks on some data provided by our clients. Could you give me a bit of a direction as to how should i learn S...more >>

Why does this query not work> I am trying to compare fields in 2 tables and Show me only the results of fields that are different, I thought this would work, but ... well, select o.name from DBNAME.dbo.sysobjects o, DBNAME2.dbo.sysobjects n where o.name != n.name ...more >>

I need to migrate some data from one DB on one DB server to another DB on another DB server. Can that be done from a SQL query or is this more involved due to the tables existing on separate physical servers? -Darrel ...more >>

Hi, I'm new to MS SQL server databases. My experience is in MySql/Perl/Linux. In MySQL loading data into the database from a file is done by using the LOAD DATA INFILE command from the mysql command line client. How do I go about loading data into a MS SQL Server 2005 database via a file? ...more >>

I am about to run an application update on an application that uses SQL databases, and would like to ensure that there are no users in the database? I thought from what I've read that it might be best to stop the SQL service, and restart in single user mode. There are only 2 applications that...more >>

Hello, I have a sql database whose tables/content I would like to import into a new database. Unfortunately, not all the fields match up, some are named differently and some don't exist in the new database at all. How is this best done? Is there a tool out there(preferably free) that wil...more >>

I'm trying to make a view in SQL Server 2005 with a parameter (WHERE ID = @param) I open the view, and put the = @param in the Filter column. I get an error: 'Parameters' cannot be used in this query type When I click OK, SQL server leaves the statement in the column and puts 'WHERE (dbo.P...more >>

I previously posted this in the integration Services but it might be better here. I have sql server 2005 and I'm very new to sql server. Currently, I have some code in MS Access that uses two tables on a sql server db through an odbc connection. It loops through the records of a table tha...more >>

Can SQL Server Express accept remote connections? If so how? I am trying to copy a database from our main SQL Server 2005 database to a laptop that is housing a SQL Server Express. If anyone knows of a better method on how to get a copy to a SQL Server Express that would be great. -Thana...more >>

The below script was used to create a database. The transaction log file was initially created with restricted growth but was changed to un-restricted growth. the issue i have is that the transaction log file reverts to restricted growth when un-restricted growth is specified. USE [master] ...more >>

How important is it to enforce referential integrity in a database? I'm working on a SQL database that has no foreign key constraints. The tables have primary and foreign keys, but the foreign key constraints are implied, not physically enforced. I did not design this, but I'm wondering, should I...more >>

I am trying to upsize an Access DB to Sql Server. The upsizing wizard runs fine when I try it locally to Sql Server Express 2005. When I try to upload it to our remote server, I keep getting a bunch of errors " Server Error 15135: Object is invalid. Extended properties are not permitted on...more >>

On a secondary table, there are two fields, one is the unique ID (UID) that's the key between the View and the Table for each record. The Table also has a field called Category. Within this table, there could be any number of records with the same UID, but different Categories. Kind of like ...more >>

hi i have SQL Server 2000 Enterprise on CD, and SP4 of SQL Server. how i can make new CD of SQL contains SQL Server With SP4, i mean when i install SQL i install SQL with SP4 Direct. -- Tarek M. Siala ...more >>

I have a several critical databases that need backed up. A consultant created the databases and set recovery model as FULL, with AUTO SHRINK set to false. This made the log files grow and grow consuming disk space. We complained. The consultant wrote up instructions on how to manually ...more >>

Hi, I am using sql 2000, How can i write a query with column name as the column data. For eg: select a.title as a.title..... Thanks Gane ...more >>

Sirs and Madams, Please help with a simple query I am having trouble with. I need the = total count of replies to a topic all in one query.=20 There's only one table involved.. Table board_posts id subject parent_id 1 subject 1 0 2 subject 2 1 3 subject 3 1 Expected Result...more >>

I have just installed SQL 2005, SP1 server on two test computers and am trying to get database mirroring to work. No witness server is being used. I have done a FULL backup of the database and backed up the transaction log. I have also restored the database and the transaction log. On the mirr...more >>

Hey everyone. Everyone here has been very helpful and I really appreciated. I have learned some much in the last couple of weeks. Thanks. I have another quick question. I seem to be getting an error ever so often. It is rather annoying and I am not sure why or how I can prevent it. The a...more >>

Dear Everybody: I try to run SQL Server Profiler, It always pop up this error window: "Only TrueType fonts are supported. There is not a TrueType font. How to solve this problem? Thanks for your help Obason ...more >>

I am using VB.Net in VS2005 against SQL2005. I am writing an UPDATE query and getting an error on my date/time fields. An example of my query string is - DOB = #3/12/1949 12:00:00 AM" I get the error - "Incorrect syntax nar '12' The way I generate the above string is from a data table and I...more >>

Hi, Does anyone know if there is a list of command switches available for SQL Server Service Manager sqlmangr.exe? Thanks Colin ...more >>

I need to compare two tables from external sources. The problem is that they don't share a single identifying field, so I'm creating a new one. In doing so, I'm using this formula: ISNULL(Field1, N' ') + ISNULL(Field2, N' ') + ISNULL(Field3, N' ') + ..... + ISNULL(Field15, N' ') Field2 and Fi...more >>

Hi I am pretty new to SQL Server 2005 and I have already learn so much. I had a quick question. Where is the "Assisted Editor" for stored Procedures. I can edit them on my own but there are other on my team who have never even hear of stored procedures and it would be helpful to them. If you...more >>

I can access all the tools of SQLServer2000 desktop when I'm logged on to my pc with administrator privileges, but if I'm logged on with power user and debugger user privileges the client software refuses to connect me. I prefer to use my pc without administrator privileges. Does anyone know...more >>

I can't find the syntax to do this in BOL, but surely there's a way. For a given database, I'd like to execute a query which would return to me a list of all tables in the database, and the number of rows currently in each. Any help appreciated. ...more >>

Hi All Reading the posts with great enthusiasm. I am just starting on the journey of SQL. The question: I have a developers version of sqlserver 2000 boxed with my visual studio 2003. Should I install that and embark on my journey or download and install the 180 day trial version of sqls...more >>

All, I appreciate everyone's patience, as you can tell, I really am new at this. Let me try phrasing my question a different way: What properies of a table prevent data from being returned by a SELECT statement in a stored procedure, when the same select statement executed from inside the S...more >>

Query returns no data rows even though the table contains data. The query text, scripted table, and data are shown below. What could keep the query from returning the two data rows that exist in the table? Thanks, Keith THIS IS THE QUERY: ALTER PROCEDURE [dbo].[GetUsers] AS SELECT * ...more >>

Hi After many years using InterBase where I had generators to generate unique sequence numbers, I am now using SQLServer 2005 for the first time. I want to generate a system-wide, unique, sequential Int32 value that I can call in a single command from C# .NET 2.0 Do I have to use a sing...more >>