TIA, because I really hardly know where to begin with this issue... Currently have a SQL Server 2000 system being accessed as a backend to a MS A2k mde. After about 6 years of working with relative pain-free ease, my tiny db started preventing users from being able to update one of the tables...more >>

Here is an extremely simplified copy of a table I have: Field 1 Field 2 Field 3 1 4 E 1 4 B 1 4 H 1 5 Q 2 9 O 2 8 I 2 9 U 2 8 W 3 7 F 3 6 C 3 7 Q 3 7 Z I would like to filter out the records that have the max value in Field 2 within each group of equal values in Field 1. Here i...more >>

Hi, After just installing sql 2005 on our test machine, I am trying to restore a database using a backup file on the network. However, the specify backup diagol box allows only for browsing to a file on the local machine - I find no way to type a UNC path to choose the backup file fro...more >>

I have several Microsoft SQL 2000 Servers. On each servers I notice that Transaction log files for database keeps growing. We also have Symantec Backup Exec 10d with SQL Server Agent. The backup runs every night and it does a full backup of SQL Server databases. I don't understand why th...more >>

Is there a convenient way to convert a small single column table of zero to six rows of VarChar(50) data to a single string via a function. Each item is ideally separated by semi-colon space. Do I need to use a cursor to do this? ...more >>

so I've gone to view a webcast at MSFT.com about a dozen times over the past year. and from what I see; their signin information just DOES NOT WORK. you find the webcast you want; you click to view it.. and then it sends you back to select a webcast again. Plus-- if a webcast is previousl...more >>

Hi, I have applied SP4 on a testing box, but my application is not compatible to SP4. I want to UNINSTALL not remove the SP4 from my server. kindly, suggest the procedure for the same. Thanx in advance. ...more >>

I just found this in a measure-up exam; it kinda surprised me; it seems like a no-brainer backups cannot be directly written to CD or DVD burners why is this true? ...more >>

I'm writing essentially a client based SQL interface(although the client accesses it indirectly). In the database there will be several different types of tables. Initially I was only going to use one table structure but I felt that it would be more productive to have it arbitrary. Now ...more >>

Hi There, I have a query that has drastically different execution plans when run as an ad-hoc query vs. a stored procedure, is this normal? The reason I ask is because it causes the stored procedure to run extremely bad when one parameter changes. Here are some details about the query... - ...more >>

I seem to be spending too much time "Googling" for info on what should be a a fairly straight forward task - porting an mySQL db schema over to SQL Server. The T-SQL documentation I have seen so far do not give any useful (i.e. detailed enough) examples. My tables generally tend to have ind...more >>

I'm writing a C# app that needs access to a remote SQL database. The issue is that I don't want users of the app to have directly access to the database because of security reasons. I do not have permissions to run any application on the server to write some interface so I don't know what t...more >>

Hey folks. I used to use studio 2005 with my sql databases. HD crashed, and I don't have it anymore. Is there a good program that is free, or relativly inexpensive that I could use?? any help would be appreciated Jeff ...more >>

I've created a new project in SSIS. I've saved the project to c:\DBProjects\DB1 All of the sql files are located in c:\DBProjects\DB1\sprocs When I right click the project name and select to add existing item, I point to the sprocs folder and add one sql file. When I look at the fold...more >>

I have an SQL database table that I need to perform some updates on. What I am trying to do is update one field in one table based on the information found in another table. I can run the query in Access, but I need to do this in SQL Server so that I can schedule it, either in a stored proce...more >>

I setup up an SQLExpress instance on a dedicated server. I configured the surface area to allow TCP remote connection. But I just can't connection from my laptop over the internet. I use IP address + INSTANCE as server name (like 123.123.123.123\SQLEXPRESS) and use sa account always get th...more >>

Dear all, I found SQL Server (either 2000 or 2005) Backup & Restore functions have a great problem Windows 2003 : They can't see shared network drives ! For example, a server machine has C:, D:, E: local drives and a F network drive mapping to another machine. In Windows 2003 File Explore...more >>

We're developing an app that will have multiple remote client servers, receiving a subscription from a central SQL2005 box. Our Sysadmin is saying we must use Vista on the remote, because we won't be finishing development for at least 6-8 months and Vista is what we'll get on the new hardware...more >>

I tried to migrate a SQL Server 2000 DB to Sql Server 2005. I am using SQL SERVER 2005 Express Migration Tools, however it seems the express version does not support DTS. My websites are on a shared server administered by my ISP. Is there a seperate download for the Management Tools (not Exp...more >>

Hi all, I have an existing server that I wish to replace with new hardware. What I would like to do is to take backups, move them to the new server, take the old server offline and rename the new server to match the old server's name. I've read this article (http://msdn2.microsoft.com/en...more >>

Publisher/Distributor: Windows 2000 SP4 SQL Server 2005 Standard Edition SP2 Subscribers: Windows XP Tablet Edition SP2 SQL Express 2005 SP2 - on clients Replication topology: Merge replication with client subscriptions Most articles replicate both ways but we have a few ...more >>

Is it possible to have an SQL account that is only used to compare data without actually being able to view it? I was thinking that it would be better if when I was checking user login information if I could use an account that had no access to reading the names and passwords but somehow I c...more >>

I'm using SQL Server Management Studio Express and trying to create multiple stored procedures. I created the first stored procedure for this assignment with no problem. When I try to create another one, it doesn't show up in the list. I can excute it perfectly but it just never shows up. A...more >>

I have an update query that I'm trying to run. Basically I start by build three temp tables and running a fourth query that is an update on the FOLDERSDOC table based on conditions in the temp tables. After this first update query is run, two more temp tables are built and a second update que...more >>

Hi, I am trying to run the following command to rebuild the master database but nothing happens and I get a prompt - 'more?' What am I missing? start /wait path to setup.exe on the local drive(copied over from the dvd/qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD...more >>

Hi I'm looking to find a Database engine to use activesync to sync DB's with desktop version. I have a desktop version of software, which I want to develop a PDA version of also. I want to then be able to Sync the data between both of the apps, preferably via ActveSync. I want to avoid ...more >>

Hi I'm looking to find a debate / discussion on the merits of coding a .NET application with either MDB or SDF files?? (ie. Access versus SQL Server Compact Edition) I guess the official line would be that SDF files should be used; but what advantages does each have over the other?? Is the...more >>

Hi I'm looking to find a debate / discussion on the merits of coding a .NET application with either MDB or SDF files?? (ie. Access versus SQL Server Compact Edition) I guess the official line would be that SDF files should be used; but what advantages does each have over the other?? Is ...more >>

I have SQL Express installed and I can access it using C# and SQL connection manager but I'm confused on how to use this for my application. What I want to do is host a database on a web server(which uses mysql) that stores information for users. I have no idea how SQL works except for a v...more >>

I just downloaded SQL Server Express (along with Visual Web Developer). However I am at a loss as to how to use it - since it appears to have installed only a service/server configurator (IIRC) - and there is no available documentation (with the install). I have a lot of experience with oth...more >>

Hi all, I am having an issue at one of our client sites. Our software uses an SQL Server 2005 backend, and this particular site is having an issue where a couple times a day, some processes block each other and pretty much prevent our application doing any work, it times out (and thus affects...more >>

Hello, I am designing a database in SQL Server 2005 that will be holding a large amount of text for many different "forms". In this system a user would pick a type of form, which really is a template, and fill-in the blank portions of the form. That text would then be saved in the database. W...more >>

Hi, I have a DB migrated from SQL Server 2000 to SQL Server 2005 and I have a strange problem that I don't find any reason. I make a simple SQL Query with one table showing all the fields and everything goes well. But when I insert another auxiliar table and showing one field, then I can't ...more >>

Hi all, I have a major problem with my ASP.NET website and it's SQL Server 2005 Express database, and I'm wondering if anyone could help me out with it. This site is on a webhost (WebHost4Life) and was running fine and dandy, until I decided I needed to add some additional stored procedure...more >>

Is there any column type available in SQL Server that will faithfully store any and all special characters used in a Word .doc file? Thanks, Dean S ...more >>

Hello, Could you help me please and tell URL of SQL Server 2005 Express Edition with Advanced Services download? (I need Advanced Services because I need to use full text search.) /RAM/ PS. I downloaded SQLEXPR_ADV.EXE and SQLEXPR_TOOLKIT.EXE from Microsoft, but it didn't install full text s...more >>

Hi, Doing some comparisson testing on SQL 2005 and thought it might provide a fairer test if each query ran without the benefit of any previous execution plans. Could anyone tell me a) how to clear the buffer cache b) how to see what's in it Thanks DAve ...more >>

Hi, SQL 2005 Std edition. Got a SQL Agent job with 17 steps that runs every 15 minutes. Problem is the SQL Agent history seems to lose history at about 100 entries. I can then see what has happened overnight. Does anyone know where this limit is set? Thanks Dave ...more >>

Hi I get this error:-Server: Msg 213, Level 16, State 4, Line 1 Insert Error: Column name or number of supplied values does not match table definition. when I run this query:- INSERT INTO <LinkedServer.<Database>.dbo.<Table> VALUES ('Full',getdate()) but when I run it locally, on the li...more >>

Why does my SQL Server db show loads of free space when the individual files have hardly any? I have SQL Server 2000 SP4 on Win2k Server. I have to keep a close eye on the db size as we don't have a lot of disk space. When I went to Enterprise Manager and then to the Shrink Database task, it t...more >>

Hello, I would like to ask such question: what is the simples way to copy records from table T in database D1 to table T in database D2 (I mean both dataabases contain table T with same structure). (I am rather beginner...) /RAM/ ...more >>

Hi, I'm new to SQL Server 2005 and can't figure out how to make the Object Explorer retain my servers so I don't have to keep reconnecting them. If I close the studio down the Object Explorer is empty when I return. This is probably really simple but any guidance would be greatly appreciated...more >>