I have spent considerable time trying to debug this one without success. I have a database which runs on my client's SQLServer 2000. It contains a scalar-valued text function which works fine. Using the same function definition in the same way on MSDE it returns the wrong result. I a...more >>

Hi all, I wonder if someone could explain to me why the script below runs fine against an SQL2000 server but fails with: invalid object name 'People'. against an SQL2005 server. The connection to the database works fine. If I supply the wrong password I get a login error message. Here ...more >>

OK folks -- I give up. I have a default instance installed under XP and it is working just fine. I try to upgrade it to SP4 and consistently get a message that says the product is not installed. The syntax I am using is as follows: c:\downloads\microsoft\msde\setup.exe /upgradesp sqlrun ...more >>

Hi, I get the error 206 not autorized to create db in Master ??? I tried to find the error in the msdn but nothing, any one have a suggestion ? Thanks Paolol ...more >>

Hi Is there a way to get a limited number of rows results from a select query ? like select top 50 * from mytable returns only the first 50 records, but what if a want to get records 50 to 100. (I woulk like to spread the results over multiple pages.) I would like to avoid to have a...more >>

I've migrated a desktop VB6 application from MSDE 2000 to SQL Server 2005 Express. Data access functions work correctly, but terribly slow. Beyond all adjustements that can be made to the server, I've noticed that all the queries and commands launched by my app run magically fast when I do the f...more >>

I've migrated a desktop VB6 application from MSDE 2000 to SQL Server 2005 Express. Data access functions work correctly, but terribly slow. Beyond all adjustements that can be made to the server, I've noticed that all the queries and commands launched by my app run magically fast when I do the...more >>

I have two Osql scripting questions for windows? 1. How can I get my OSQL script to output to a CVS file. Such as "select * from itemtable" 2. How can I create a osql backup script to will name the backup filename system_date.bck. This way I have a backup for each day by date. Thanks Da...more >>

Hi the SQL Express 2005 database liti is 4GB, right? Does this apply for each database separately or for all DBs registered? Also which file size is monitored (mdf only or mdf+ldf) Thank you ...more >>

Hi, I have the below script: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Applications_CreateApplication]') AND type in (N'P', N'PC')) DROP PROCEDURE ^^^^^^^^^ What do i write afte...more >>

How to duplicate a database from one PC to another (remote computer) over the internet ? Arthur ...more >>

Hello, How can I check the size of a SQL express 2005 database ? Thanks Dag...more >>

I keep getting Error 10061 upon connecting to the remote server through LAN and local IP I use SQL authentication and TCP/IP. Can someone sugest any soutions ? please Arthur ...more >>

I have installed MSDE2000 on my pc and am trying to set it up so I can connect remotely. I'm trying to run svrnetcn.exe, so that I can configure TCP/IP and Named Pipes. Instead of opening the program, I get a message: "The operation completed successfully." (with a "0" in the title bar). ...more >>

I'm an osql newbie and I want to simply display the table names in the database. I'm used to oracle where we'd enter "select * from all_tables;" what's the equivalent line in osql? ...more >>