|
It sounds to me like you have installed the freely available version SQL Server Express 2005, not the full version of SQL Server, is that correct?
By default, unlike the full version of SQL Server, this does not come with SQL Server Management Studio, which is used to create databases and enter SQL queries.
You can either open a command prompt and type sqlcmd -S.\SQLExpress -E to get a command prompt from where you can enter SQL statements against your database.
Or, you can download the freely available SQL Server Management Studio Express, which gives you a graphical interface to do all this (recommended).
Get it here: http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en[^]
Hope this helps,
Roel
|
|
|
|
|
Thank you yes it was help but I'm sorry to interrupt again I saw your link and I want to donwload "Microsoft SQL Server Management Studio Express"
if I download it Can I sure that I will not problem to work with sql 2005(of course my intent is like previous ) ?
|
|
|
|
|
As far as I know, the only time it will not work is if you have the full version of SQL Server Management Studio installed already, which for you is not the case (otherwise you would not have to install this one.) So, just go ahead and try.
Roel
|
|
|
|
|
Hi again,
I download and install SQLServer2005_SSMSEE it seems like sql 2000 It has query is it like query on the swl2000(of course not excatly) now I have another question I install vs2005 that it has sql server and also install your link do I need to install other things for sql or these are enough.
Thanks for your help and your good info
|
|
|
|
|
I guess so. Maybe the next step would be to buy a good book on database programming with Visual Studio?
Roel
|
|
|
|
|
Your answers are helpful for me (I have two book about sql not they are for sql 2000 most for programming database)may I ask if i have any problem on the sql2005 in next?
Thank you.
|
|
|
|
|
SQL Server 2005 is fully backward compatible with SQL Server 2000, if that's what you mean, so whatever works on SQL Server 2000 will (in most cases) work fine on 2005. If you want to take advantage of some of the new 2005 features, do some research online or get a 2005 book.
Roel
|
|
|
|
|
This is probably an error caused by the service not being started.
“Some have an idea that the reason we in this country discard things so readily is because we have so much. The facts are exactly opposite - the reason we have so much is simply because we discard things so readily. We replace the old in return for something that will serve us better.”--Alfred P. Sloan
|
|
|
|
|
Hi Jerry,
Its on the memory sqlserver.exe and it shows run but when I tired (I said on the first message) I cant see any databses.but I remove vs2005 and installed again please see my last post to roel_v,Where can I enter sql statements like Query on the Sql2000
|
|
|
|
|
Download the SQL Server Managment Studio.
“Some have an idea that the reason we in this country discard things so readily is because we have so much. The facts are exactly opposite - the reason we have so much is simply because we discard things so readily. We replace the old in return for something that will serve us better.”--Alfred P. Sloan
|
|
|
|
|
Thank you Mr Jerry Hammond for your help
|
|
|
|
|
My company is using a third party software designed by other private company. there is a point where there is data redundacny on our tables and it requires me to do the data cleaning. i thought it would be better to fix the incorrect field with the procedure with those filed require a common value. i decided to write a procedure to update those files where there is an mispelled of words. and i have to run that query everyday, i was wondering if the Trigger would help here, if maybe i put my Procedure inside the trigger and when ever a user enters wrong info , it can be triggered?
Help i dont know what option to do am using SQL 2005
Vuyiswa
|
|
|
|
|
Something to think about here. It is rarely a good idea to "fix" data from a trigger - how would you handle it? On an insert only - then what happens if the row is updated; ah, so you include the update. All of a sudden, you've got a cyclic reference, where the record is updated which fires the trigger.
Why not use a SSIS job to accomplish this? It could be run daily, and would take care of records that have been inserted/updated.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
am not that broad am still learning but can understand much and know much ca you tell me what is "SSIS"?
Vuyiswa
|
|
|
|
|
SQL Server Integration Services. Effectively the replacement for DTS. Google SSIS examples[^] for some decent examples on how to use it.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
|
Hi All,
I need to deallocate normal variable that has been declared in Stored Procedure in SQL Server.
So how i could achieve this?
Thanks in advance,
Rachit Damani.
|
|
|
|
|
rachitdamani wrote: I need to deallocate normal variable that has been declared in Stored Procedure in SQL Server.
I don't understand what you mean by this. Why would you want to deallocate a variable?
|
|
|
|
|
Can you explain this little bit more, if you want to just reinitializes various variables used in SP then use set statement with variable...
Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
http://jaiprakash.blog.com/
|
|
|
|
|
rachitdamani wrote: I need to deallocate normal variable that has been declared in Stored Procedure in SQL Server.
Will be automatically deallocated when it is out of scope
|
|
|
|
|
Hi There,
Is there a way in which Sqlserver can notify the dotnet application when a new column is added . i believe we can not use Query notifiaction here(correct me if i am wrong) .i am using sqlserver 2005 and dotnet 2.0 .
if anybody have an idea of how to do this or know any link in this regard,please share with me.
Hope i am clear
Cheers
Deepak
|
|
|
|
|
If you are using MS SQL2005 then I think this should be possible with notification services.
Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
http://jaiprakash.blog.com/
|
|
|
|
|
Howdy All
I'm new to C#, recently converted from Java. I'm still learning the coding differences.
One that I have seen around a fair bit is data access code. Below is a code fragment for accessing a database. Normally (in Java) I would use try/catch/finally for surround the connection etc. In C# the using statement works well for cleaning up the connection (if I understand it correctly). In bold I have added code that handles and logs the exception then throws it up to the next tier. I don't see many (or any) examples with a try catch block inside a using statement (the bold code). Is there reason for this?
Any advice for writing DAL code (not using datasets)
public static bool Delete(int supplierID)
{
int result = 0;
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
SqlCommand myCommand = new SqlCommand("sprocProcSupplierDelete", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(Parameters.SupplierID);
myCommand.Parameters[ParameterNames.SupplierID].Value = supplierID;
try
{
myConnection.Open();
result = myCommand.ExecuteNonQuery();
myConnection.Close();
}
catch (SQLException e)
{
...
...
throw;
}
}
return result > 0;
}
Thanks heaps for any help
|
|
|
|
|
Quinten.Miller wrote: I don't see many (or any) examples with a try catch block inside a using statement (the bold code). Is there reason for this?
Possibly they don't want to handle the exception at that point.
Also, remember that much example code will leave out exception handling to improve the clarity of the code that is being shown. Whether that is a good thing or not, I don't know.
From my own point of view. I normally find that at this point in my code I can't do anything with the exception so I just let it continue to unwind. I don't log it at this point because the call stack is too short to be useful also - it will show me from my DAL method into the ADO.NET code, but it won't show me what called the DAL method and that is often more useful in tracking down a bug. So, I let the stack unwind a bit before logging anything.
|
|
|
|
|
I advice you to use
try
{
myConnection.Open();
result = myCommand.ExecuteNonQuery();
}
catch (SQLException e)
{
// handle exception
...
// log exception
...
throw;
}
finally
{
myConnection.Close();
}
This is a good using of try/catch/finally. Using statement dispose object which created after using in
body of statement.
Return to innocence
|
|
|
|