Recent update: 2008-3-21
In Microsoft SQL Server Management Studio Express you can right click on "Stored Procedures" under a database in the object explorer and the resulting Context Menu offers a selection called "New Stored Procedure". If you select "New Stored Procedure", a Stored Procedure Template Document is ...
806 byte By
VBFan at 2008-3-6
Hi all, I′m a real SQL rookie and after two days of intensive research and reading of dozens of articles and web pages a bit confused about all that knowledge concerning database technology ... and I only want to do something very easy ... Now, my question is, how can I produce a diagram from ...
580 byte By
VBFan at 2008-3-5
Hi all, I′ve installed SQL Server Express 2005 as part of the installation of Visual Basic Express 2005. When I tried to run the Starter Kit "WebLogAnalyzer" comes the following error message: "Warning 1 The referenced component 'Microsoft.ReportViewer.Common' could not be found. " Now I′ve ...
Hi I have installed SQLExpress. Whenever I boot my PC (XP Pro SP2) I get the following error just prior to logon: "Your SQL Server installation is either corrupt or has been tampered with (Error generating instance ID from name). Please uninstall the re-run setup to correct this problem." I ...
788 byte By
xprs at 2008-3-1
I'm trying to update my database table from my dataset. In the following statement, the ? represents the "size as integer" of the SqlDbType of DateTime and I can't fiqure out what to put there. command.Parameters.Add("@ItemDate", SqlDbType.DateTime, ?,"ItemDate") In the following statement I ...
I have a database table called Qlinks, with two columns, URL and Name. This table is displayed on a form also called qlinks, in a details view. When I try to save data after i've deleted a row of the table, O get a yellow po-up telling me that the InvalidOperationException was unhandled. The ...
630 byte By
chr at 2008-2-27
When I create a database with the administrator acount on the server in SQL 2005, it adds and I can see it (and the system databases too). Then I added a user accout (Windows Auth), and connect to the database from the new accout, but I can't see the database I just created myself with the ...
1625 byte By
JohnVB at 2008-2-26
I have installed Visual Basic 2005 Express and SQL server 2005 Express.I am reading the ebook: "Microsoft Visual Basic 2005 Express Edition - Build a Program Now" that you download when you register the products (it is a PDF file named 6-2213-2.pdf)Page 139 of the book (or 151 in the file) is ...
I have a table with 23 columns. 8 columns are not always filled by users and so valued to default. Would this affect the overall performance of querying this table? Should I separate those 8 columns and link with a one-to-one relation?</P> Thanks</P>
BonjourYou'll have to be gentil with me, because until today I had never worked with MS SQL (I was developing with Access).Scenario & question:I have installed a phpBB forum running on MS SQL on my clients server. Since Saturday this forum just won't load anymore. I have tested the ...
Hi everybody, Which Edition of Sql server can run on XP with utility to create table like query analyzer and enterprise manager? Also for viewing the records. By the way, free or evaluation copy only for windows XP OS. Please specify details. Thanks. den2005 </span>
With MSDE 2000 you are limited to 8 machines and it is recommended to use SQL Server if you are planning on have more than 8 machines in a machine pool. Since SQL 2005 Express does not have the workload governor, would it be a valid substitution for the SQL Server 2005 for the purpose of logo ...
583 byte By
ths at 2008-2-22
I have an application that uses Acces as a backend and VBA as front end. Application is secured and is supplied on a CD with setup.exe. Can I use VB 2005 and MS SQL to achieve the same? Would I be able to package my application with all the neccessery files (assuming that client does not have ...
I've installed SQLExpress on two machines. Both with no problems, except on one machine I noticed the following error w/in Events -Applications: FCB: : Removealternatestreams: Operating system error 6 (The handle is invalid) occurred while creating or opening file 'C;\Program Files\Microsoft ...
Hi, I attended the Technet Ready to Launch event and obtained the dvd set, but when I tried to install the sql product, the software won't take the product key (the key is the same as the studio product). Anyone experience the same? </span>
502 byte By
Cuzco at 2008-2-20
A couple of us are trying to use the SQL Server 2005 Virtual labs at http://msdn.microsoft.com/sql/ . We complete all the prelim steps successfully but when we click on "Start the Lab" we get a blank page with "No Connection" in the middle. The clock ticks and the system thinks we are doing the ...
726 byte By
Roland at 2008-2-20
I am trying to write to the Express SQL database using the My Movie Collection sample in VS2005. It seems to work fine while the program is running but when I restart the application all of the entries in the database are gone. What do I need to do to actual put the data in the database? ...
HiI create a database in SQL Express using the Microsoft SQL Server Management Studio Express, with tables etc.I connect to it from my VB Express .NET application. Any changes I make, like adding a new table from VB .NET Express causes all the tables to 'vanish' when viewing the Database in ...
I just installed the 90 day VS2005 Professional Edition - prior to this I was using VS2005 Beta 2 - I have a database on a remote server that I have been using in VS2005 Beta 2 with no problems - In VS2005 Beta 2 I succesfully ran aspnet_regsql against this database and set up connection ...
536 byte By
ssfftt at 2008-2-17
hi i am new to mssql db stuff. I just developed my first VB.NET application and it uses a mssql database which is hosted locally on my development machine. I built the deployment msi file for my application which can be installed easily on client machine, but have no idea how to move the mssql ...
We’re in the process of assessing the content that exists to help people learn and use SQL Server Express. This includes demos, tutorials, whitepapers, Webcasts, Starter Kits, and any other type of content you could imagine. So this is a great chance to TELL US WHAT YOU WANT! We’ll integrate ...
I migrated my SQL Server 7 database to the new SQL Server 2005 that I installed on my PC. I have classic ASP programs on my PC that used to access the SQL Server 7 database. However, global.asa and these ASP programs can no longer connect to the new SS 2005 database.The access to the SS 2005 ...
563 byte By
achalk at 2008-2-15
I have created a user in SQL Server Management Studio Express. However, whenever my ASP.NET application tries to connect I get the errorCannot open database "ABC" requested by the login. The login failed. Login failed for user 'Fred'.If I change my login string to Integrated Security=SSPI it ...
2459 byte By
RRRSr at 2008-2-15
I am having problems with making data connections to the same DB from various express developer tools:I have downloaded most of the Express family:Sql Server Express 2005 (SSE)Sql Server Mgmt Studio Express 2005 (SSMS)Visual Studio C# 2005 Express (VSCS)Visual Web Developer Express 2005 ...
Hi,I've installed the following on my Windows 2000 sp4 system.VS studion 2005 standard editionSQLServer ExpresssSQLSever Express management tools.I know the SQL server is working as I can get to it from the management tools. I've successfully created a DB, made tables, and done selects.My VS ...
This is a true newbie question. I want to search an entire table for a string. Is there a way to do the equivalent of:SELECT * from <db.table> WHERE(*) LIKE '%<some string>%'The WHERE(*) is my attempt to say search all columns. That's apparently not legal in SQL so my question is ...
Hi there,I'm using a DataBase for tests, but now that it's completed and I erased all it's contents, I verify that the mdf file of the database have 40 MB, but I don't have any data on it. It's that because whene the database grow's, then never comes dow to a small size?I whant upload the ...
I downloaded visual studio express including c# and sqlserver express. I can't ue the database. Is there some setup procedure? </span>
Hi, I’m new to sql ex 2005 and have a couple of questions I can’t find the answers to. Q.1 I am working with VS web dev ex 2005 and I’m trying to backup my db, is it as simple as copying the .mdf file? Or should I create a text file, or something else? Q.2 How do I view the content of the ...
240 byte By
SailFL at 2008-2-13
This may not be correct request but I have SQL Server Management Studio Express. How do I connect the Adventure Work Database to the console? How do you use Access to connect to the SQL Server Express? Thanks for your help. </span>
480 byte By
WoodyS at 2008-2-12
I assume this is the best forum for this quesiton; if not, please direct me.I have noticed that I can add (for example) a text file to a misc folder in a SQL Server project by dragging and dropping the file from Windows Explorer onto the Misc folder inside the SQL Server project. Is this the ...
1604 byte By
WoodyS at 2008-2-11
I am a Visual Studio .net developer and understand Solutions and Projects in VS.net. Nevertheless, it appears that the paradigm of using Solutions Explorer in SQL Server is not exactly the same. That is, in Visual Studio you can't get anything done without creating a solution first. In SQL ...
According to the MSDN, in SQL Server 2000"When you select a data type, length is defined automatically. You can increase or decrease the length property only for a column with a data type of binary, char, nchar, varbinary, varchar, or nvarchar. For columns with other data types, the length is ...
I cannot install the new version of sql 2005 because it will not install when the beta version is installed. However when I try to uninstall the beta version it says it needs .Net framework 2.0. I have .Net framework 2.0 and so I am stuck with what to do next. Ideas anyone? </span>
Help!I saw the Visual Studio 2005 beta and got that sent out to me. That had some SQL server trial on it. Everything was hunky-dory until microsoft put the free express editions on the web and i downloaded them. I Uninstalled the Visual studio beta and sql server but in the wrong order. I go to ...
I have a varchar field that contains both numeric and text data. I need to pull <strong>only numeric, non-null values</strong>. I am fairly new to SQL, so I applogise if this is a really basic question. Thanks. </span>
I installed VS 2005 & SQL Server 2005.When I use SQL Server Management Sudio, I can create a new database in SQL Server 2005, but when I try to create a new table in that database, I get the following error: "Class does not support aggregation. Microsoft.Sqlserver.Sqltools.VsIntegration"any ...
hi, my RTM install of VS2005 (Standard) doesn't seem to offer 'Database Project' as a type of project. Net effect is that when I attempt to open an existing .dpb i get a dialog with "Make sure the application for the project type (.dbp) is installed" When I installed VS2005 & SQL2005 I ...
I'm relatively new to SQL Server. I have spent some time in Enterprise Manager for our SQL Server 2000 instances. We are testing SQL Server 2005, and I found that I was able to register 2000 databases into the new SQL Server 2005 Management Studio.My question: Why not switch immediately to SQL ...
3056 byte By
Sayeed at 2008-2-7
I am trying to install SQL 2005 in a 2-node Windows 2003 cluster. I have tried both upgrade and fresh installation, but got same error. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows: ...
1017 byte By
Jocky at 2008-2-6
Hi,I have a question that I hope someone can help me with.I' have installed VS2005 Beta 2 on my XP machine. I've also installed SQL Server 2005 and uninstalled SQL Express (though the instance still seems to appear even though it no longer works!)So basically I'm trying to get VS2005 to work ...
958 byte By
sulmau at 2008-2-6
Hi,I'm totally newbie in this age of coding / development & need to start to jump-in in this part of IT & need help that how to start / learn client / server database development either web based or something like this using sql2000 / vs2003.net ( vb ect. ). I know that there r new ...
752 byte By
Bike at 2008-2-5
On the web site for MS SQL Server 05 Express the description at the top of the page says, "Transfer any database created in SQL Express to other editions of SQL Server 2005." http://msdn.microsoft.com/vstudio/express/sql/powerful/How do you transfer a database from SQL Express to SQL Server ...
258 byte By
dwhsix at 2008-2-5
(SQL Server Express 2005) sqlcmd will connect to the local SQLExpress server just fine if I give the -S parameter: SQLCMD -S .\SQLExpress but is there any way to have it default to that so I can just say: SQLCMD ? Thanks, dwh </span>
Hi, I'm new to SQLServer and I would like to know how I store times without dates! I simply want to store a duration which has no concept of a date, but I cannot seem to find a data type that does the job. Am I missing something obvious? Cheers, Roy </span>
Please can anybody help me in fixing this error I am getting on ASP page while accessing ASP database page using an SQL server database.I am using Windows 2000 Service Pack 4 with Internet Exp. 6. The system also has developing software VB6 and IIS. It is connecting well with VB application but ...
1618 byte By
JohnVB at 2008-2-4
I have installed Visual Basic 2005 Express and SQL server 2005 Express.I am reading the ebook: "Microsoft Visual Basic 2005 Express Edition - Build a Program Now" that you download when you register the products (it is a PDF file named 6-2213-2.pdf)Page 139 of the book (or 151 in the file) is ...
To use the front end tools in SQL Manager on the database at my ISP I want to connect directly from Server Management Studio ( Or Server explorer i VS). I have enabled TCP/IP without succes. My installation is based on SQL Server Developer Edition and VS 2005. With my previos ...
How do you set a user name and password on a SQL Express database created using the data explorer in VB2005EXP?When I try to tell it to use a user name and password (as opposed to using Windows logons), I get an error saying that the name I used isn't trusted.How does one change access ...
Is there some type of resource that tells you what all the Data types are and what they are used for. For example, whats the diffrence between Nvarchar and Char? Things like that. Thanks!