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 >>