I am a novice SQL guy so you all take it easy on me. I am trying to run a query and one of the columns of my has values that is referenced in another table, i.e. for EmployedStatus I have a bunch a numbers from aother table. I go to that table to see what the numbers mean and there you go. W...more >>

We’ve got database marked as “suspect” in our MSSQL Server. We found out this when viewing it using Enterprise Manager. We are ready to forsake the unwritten transactions in the transaction log. Please tell us what we should do so that we can bring the database marked as normal. We t...more >>

Hi I ran this script to make all my ClientIDs uppercase. UPDATE Clients SET Clients.ClientID = Upper([ClientID]) After it ran, all linked tables had the one ClientID - ZHIR01, which is the last ClientID. The relationships were set to Cascade Update and Delete. Why would this happen? Thanks...more >>

This may be a silly question, but I just got SQL 2000 Enterprise Mgr loaded. I have registered two different servers. Can I copy one table from one server to the other server? If so how do I do it? I don't care if the data comes along or not. One of the servers is production, and the other...more >>

Hi I will be developing an application in vb.net 2005 using SQL Server Express 2005. The client already runs SQL Server 2000 though. When developing this app. is there anything that I need to be aware of that may cause an incompatibilty problem? I'm new to the SQL side of things. An...more >>

If this isn't the right newsgroup to post this in, please advise me of one that would be better. I'm new to SQL. I have been asked to look into MySQL. I am starting to develop in VB.NET. Can you develop in VB.NET using mySQL as the database engine? Many thanks Michelle ...more >>

Sql Server 2005 - Server Management Studio allows a 'contains' filter on stored proc names ... its easy to list all stored procs that contain _aaa_ What is the incantation to list all procs that contain _aaa_ AND _yyy_ ?? Thanks in advance. Barry in Oregon Is there some secre...more >>

For test purposes, I want to fill in some data. Here is the query I'm trying to run. UPDATE [SELECT TOP 500 Account_Handler_0 FROM Clients WHERE (((Clients.Account_Handler_0)='Unallocated - Cork'))] SET Account_Handler_0 = 'Anne O Driscoll' It parses ok, but I try to run it, I get this er...more >>

Hello, I would like to ask you for help. I have notebook Win 2000 and IIS and several web aplications based on ASP.NET 2 and SQL Express. These apps are working well on Web Server, on my production PC and they was also working well on this notebook. There used to be installed Visual Studi...more >>

Hi I have a SQL Server db, with a Clients table. For some reason, I can't update the Clients table from external apps. Also, I can't restore the db, as I get a message that it is in use. I've ran DBCC OPENTRAN and there are no open transactions. Is there a way I can the user name of who is ...more >>

I got sbs 2003 server with sql 2000, and using backup data function to move the database to another 2k server w/sql2k, after I restore on the 2k server, I from workstation try to login by using that data, but there is no account appear on the screen. What is wrong with it or I did something...more >>

I am using SMO 2005 to assign alerts for error number 20574. My doubt is whether we hav to assign job for the alerts that are created?? And also will the alerts be generated when the error occurs and the operators be notified thru email???? Thanks, Somu ...more >>

I need help with this sql syntax: UPDATE TWDECL SET TWDECL.LPROD = TWDECLTMP.LPROD, TWDECL.LQORD = TWDECLTMP.LQORD, FROM TWDECLTMP, TWDECL WHERE TWDECLTMP.LORD = TWDECL.LORD And TWDECLTMP.LLINE = TWDECL.LLINE Not sure how to includ the second table in the syntax. Also, do I need to inclu...more >>

I use an SQL Server 2000 database on my Windows XP Pro desktop. I have installed SQL Server 2005 on my laptop, also Windows XP Pro. Both are on my local MS Windows network workgroup at home. I use MS Access 2003 as the front end with ODBC. How do I copy (is that the proper term?) my 2000 da...more >>

Hello all I am extremely new to sql server and I am trying to install Sql server 2005 beta 2 on to my system that is currently running windows xp pro with 2gb memory ..I keep getting this message during the : System Configuration Check everything else checks out but this message...(An applic...more >>

Hello, We are using MS SQL Server 2000 Enterprise with SP3. I am getting an error: [Microsoft][ODBC SQL Server Driver][SQL Server] Syntax error converting datetime from binary/varbinary string. Has anyone come across this error ,and would you share your resolution? Pls. e-mail me at l...more >>

Is there a forum devoted for sqlExpress 2005 users?? Thanks Henry ...more >>

I currently have SQL Server 2005 Express and Management Studio Express installed. I want to switch to the 180 free trial version of SQL Server 2005 (Standard). Do I have to uninstall both Express and Managemnt Studion Express before installing the 180 free trail? Or do I just need to unins...more >>

I'm trying to convert an MS-Access query so that it uses T-SQL code in Query Analyzer. I'm stuck at one point. The MS-Access query has the following field definition and conditional statement: NewClID: IIf(IsNull([CL_ID]),"0",[CL_ID]) How do I convert this to T-SQL. I have looked and lo...more >>

I wish to create a package that I may schedule to run every x amount of minutes. I have successfully done this twice before where the package simply grabs data form one db and inserts newly created rows into another db table. Now however, I wish to Have the package grab the source da...more >>

Hi I just tried to log on to SQL 2005 managment studio using windows authentication. It keeps giving me a logon failure with Error No 18456. I am logged on as administrator and the greyed-out user name shows administrator, this has only started happening since upgrading to Vista RC1. ...more >>

What is the annual license maintenance costs for SQL Server. Is it a %age of the product license costs TIA ...more >>

Hi, I am trying to migrate some data from dev db to prod db. I am trying to do this by creating queries in query analyzer like SET QUOTED_IDENTIFIER OFF select "Insert into productinfo (programname) values ('" + productname from productinfo where product_id=21 + "')" I am getting Synta...more >>

I need any info anyone can share on utilizing SQL Mail for SQL Server 2000. We use Job Scheduler and at times we find errors on there but it is a manual visual check up. Trying to find a way for e-mail to be sent out when specific errors happen on Job Scheduler. Any ideas? If need more info...more >>

For the life of me, I can't delete a backup job that was created with the maintenance wizard. The job deletes from the Management\Maintenance tree, but doesn't delete from the SQL Server Agent tree. I script the job to drop and get this error msg: Msg 547, Level 16, State 0, Procedure s...more >>

Hello, After finally convincing my client to upgrade to SQL Server 2005 Enterprise Edition SP1, we run smack into three bugs that have been fixed by hot fixes: http://support.microsoft.com/default.aspx?scid=kb;en-us;911569&sd=rss&spid=2852 http://support.microsoft.com/kb/919144 http://supp...more >>

Some time ago I met a difference in behavior of SQL 2000 EM and SQL 2005 Management Studio. In 2000 I always have table data displayed in order it was entered when I use Open Table from popup menu, while I get unordered data when I use Open Table in MS. Although I've got some answers explaini...more >>

Is there a way to take a DB from SQL2000 and SQL2005 to MySQL? Thanks...more >>

Can you take a SQL2000 and SQL2005 database and convert it to a MySQL database? By backing up, or exporting, or something along those lines. The powers above want to me to move all of our websites, which have both 2000 and 2005 SQL DB's, to MySQL. Is this possible? Or more of a problem? ...more >>

how can i automate decreasing the log file size? thanks ...more >>

I have installed Visual Studio 2005 pro, which installs SQL server express. Can I create an SQL database to store data in using VS and if so how? ...more >>

Hi I am working on a VB6 application for my office where we will be getting the backend as SQL 2005, which edition that I am not sure. The VB6 application will be installed on 400-500 client machine and they will be connecting to the SQL Server on the network. Now these user will be frequentl...more >>

In running an insert statement I've encountered this message: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'fk_benkey' All well and good, but is there a way through the Enterprise Manager or Query analyzer to show me which table(s) are using this column as a foreign key, so...more >>

Dear all, I have an Access database that I would like to import under SQL express 2005. Is there a way to do this ? SQLserver 2000 privide a tool for that but could not find a way for EXpress 2005 Thnaks for help regards serge...more >>

I need to move some databases to a new drive but there is no management studio on the server. It is SBS R2 with SQL 2005 workgroup edition What to do ? Jack ...more >>

I need to add entries to an existing table. The table has 2 columns (name, number). I need to routinely add entries for multiple names and multiple numbers for each name I'm just not sure the best way to do it. I know I can just do a Insert..values query, but I don't want to specify each one ...more >>

I have a selection form that collects the following data with their associated form field names: Warehouse (Whse) This is a drop down list of appx 40 items Part Number (PartNumber) This is a drop down list of appx 2300 items Status (Status) This is a drop down list of appx 1...more >>

Hi, Any would plz tell me which standard of SQL, MS Sql Server uses. and is there any free source code to validate sql query? thanx in Advance Regards ___ Atif ...more >>

I used to work with SQL 200 Enterprise Manager. Now I started to use SQL 2005. Unlike in SQL 2000, if I open table data is displayed in some strange order (I even do not know what order is used). For instance in SQL 2000 all data is displayed in order it was entered in the table - first inse...more >>

I'm attempting to table with Enterprise Mgr and it hangs up. The table was corrupted and I made a new one, but the old one won't delete. Any ideas on how to delete it? Thanks. ...more >>

So I have a table with various records, each with different datetime fields populated..I want to query the records and then display them on a web page (ASP) so that when there's a different month, it breaks out as: 1/10/06 1/20/06 1/30/06 (note the space between eac...more >>

Hi I have two databases set up, one for Office A and one for Office B. The databases have the same structure. There is a lot more data in the Office A database. Yet the Office B mdf is 6 times larger. Why would this be? Thanks Vayse ...more >>

Hello, I want to make an SQL query that selects all records in a table where a certain column is NOT -1 The column is an int but may have the value NULL I have used this SQL statement: SELECT * from MyTable where (NOT (MyCol=-1)) If I have an integer value in the column then it works...more >>

I am new to SQL and I was wondering if anybody has any recommendations on books to learn how to write SQL queries. Any suggestions on where I can start this learning process? Thanks, Jasper ...more >>

Ok, I feel like a retard for having to ask this, but... In SQL Server 2005, I wish to have a column keep track of when that specific record was created/updated. Any suggestions? I thought I could use GETDATE() in the Formula property, but if I do so, whenever the aspx page loads and dis...more >>

I recently bought SQL Server 2005 Standard Edition, 1 server and 5 CALs, from an online store (techusastore.com), but did not received any information such as product key or licensed key or authorization number, or anything like that. No documents. Just the 2 cds in the cd sleves. Not even a ...more >>

Hi I am in the process of writing some SQL based reports. The will be around 3 groups of reports. The setup will be Group 1 will be viewable by all staff. Group 2 will be viewable by managers, and above. Some accounts staff may also require access. Group 3 will be only viewable by...more >>

Hi, Is it possible to use SQL 2005 report service in VB.net 2003? I cannot find SQL 2005 report viewer component in VS 2003. Thanks Luke ...more >>

Dear all, We have a supervision application which is based on concurent access and strorage of data actually in an Access database 97. This actually run under windows 2000. Today we are thinking to review our application and plan to move it under Windows Vista. One of our issue is to re...more >>

I've made a database with phpmyadmin. Now I want to add text to the fields i"ve made. Can i do this trough phpmyadmin or how can i do this? I've got these fields. id int(11) No Null auto_increment titel varchar(50) No Null bericht text No Null datum varchar(16) No Null ...more >>