I can't find the proper parameter(s) to the <providers> statement in the = web.config file ... specifically the type=3D statement for MySql .. Any Help you can provide??? Thanks...more >>

Hi all, I'm trying to migrate an Access database to Sql Server 2005. I downloaded and installed Sql Server 2005 Express and Sql Server Migration Assistant for Access. Worked ok and has complete table migration well, including linked tables. But queries... no. The problem is that my datab...more >>

My Hosting Site provides MYSQL DB support in my package with no add'l = fee vs. SQLEXPRESS or SQL which is how VWD created the Roles & = Membership DB (.mdf). ... So, I'm needing to download and install the = MYSQL "product" ... I'm very confused in searching the NET for the = "package" I need t...more >>

I need to set the primary key on an existing column within a table. Can't somehow seem to get the syntax right. I had assumed something like:- Alter Table <table name> Add Constraint <constraint name> Primary Key <column name> <constraint rule> but this don't work !! Any help greatly appre...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 have a table and one field is 'ItemCode' nvarchar 20. The data in this field are like xxxxxxxxxx-xxxxxx The '-' is not in a specific place in the data. I want to separate the two parts of the field into two different fields, Code1 and Code2. Is there any way using a stored procedure to ...more >>

Hello, I am migrating from MS Access to MS SQL SERVER 2005. But I have a problem with my SQL queries which were running fine on Access. Below there is a query which was ok but on SQL SERVER, it gives the following errors: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword '...more >>

Hi, i defined a field as 'money' (and then as 'smallmoney'). When i insert a non integer value in that field, it's rounded: e.g. if i insert 17,95, it becomes 18,0000 in the table. Any way to prevent That? thanks michel ...more >>

I have a client that was, until recently, on SQL 7.0. Two times within a month they had problems connecting to SQL from their application (Dynamics SL). They would receive an error saying XPSQL70.dll was not located. I reapplied SP2 both times and that solved the problem. A month ago they ...more >>

I am a computer idiot - but I do not know what this is or why it is on my computer - I have a computer 'tower' with a magnifying glass in my bottom window but it won't go away - does anyone have a moment to help me?? PLEASE! ...more >>

Hi, i have to insert values into two tables. The first table (base table) has a primary key (type 'int') which is incremented automatically with each insert. The second table (detail table) contains a field (type 'int') which must get the value of the primarty key of the last record in tabl...more >>

Hi, I have 2 fields in a table: fld1 of type 'int' (primary key) and fld2 of type 'string'. I only insert value for fld2. The value of fld1 is put automatically because it's defined as primary key. I use the "insert into table ..." statement. My question is after testing, i would like t...more >>

Hi Working with SQL Server 2005 I am trying to create a table with the following code create table department (dept_id smallint unsigned not null auto_increment, name varchar(20) not null, constraint pk_department primary key (dept_id) ) but keep coming up with an error. I suspect th...more >>

Just started to work with MS SQL Server and trying to figure out a query that would give me: All the tables and fields in a database. The datatypes of all the fields If the field has an index and if so if it is a unique field The index stats The field data size I can do this in Interbase...more >>

how can i disconnect users, by code, from sql server? thanks ...more >>

Hi, i need an autonumbering field like in MS Access. At first glance, i couldn't find such a field. Is there a way to get the same result? Thanks Michel ...more >>

Hi, At least I got this far and it works properly when I execute it from the QUERY area in Enterprise. (excuse me, I do not know what that area is called) DELETE FROM Orders WHERE ([Date] <= DATEADD([day], - 30, GETDATE())) I am trying to understand how to create a stored procedure. ...more >>

A co-worker recently quit the company, and all of his stored procedures and DTS packages are apparently under his name. Is there any way to change his account to another (ie administrator or SA)?? I am afraid to delete his account in fear all the stored procedures will be lost. (we have back...more >>

Hi, I am new to Sql Server 2005. We are currenly migrating from Informix/AIX. Any recommendations for a Comprehensive book on Sql Server 2005. Focus on administration with coverage on development will be wonderful. Thanks. Kumar....more >>

I must be doing some daft thing- In Management Studio Express I have Northwind, Pubs and a db of my own. I can create SQL select queries and get results back fine but when I try to do an insert, update or delete I get the message: (1 row(s) affected) - making me think all has gone well, however...more >>

What tools can I use to manage SQL 2005 that comes with SBS 2003. I need to run scheduled management tasks to backup the sql database but I appear to have not loaded the correct if any tools to do this. With SQL 2000 you had enterprise manager to do. Thanks, Joe ...more >>

I'm stuck! How do I format an update statement that includes (') in the string? UPDATE <table> set <column> = 'A'T#N' ie, I want the column (varchar(16)) to equal the value: A'T#N I know I can edit the one row at the time in SQL Management Studio, but there are hundreds... Thanks Reg...more >>

I downloaded and installed both SQL Manager Lite and SQL Server = Configuration Manager 2005. I think I'm still missing the SQL Service = (engine) since when I try to lok for my .mdf database that was created = in VWD 2005, I get the following error: SQL Service does not exist or access denied...more >>

I did this on SQL Server 2005 standard with no problem. But apparently SQL Server Express doesn't have any way to import a database. If it does, I cannot find it. ...more >>

A thirdparty application fills populates a SQL Server database, every 24 hours. It overwrites all prior data. Backup is set to Simple. It used to import all branches, but now we've changed it so only import certain branches. ( that is, a branch/office of the company) The amount of data has m...more >>