I have created sample database in my SQL server 2005 database.Now i want that database should be password protect when i click on SQL SERVER DATABASE FILE. how to set password when anyone click on my sample database file it will show enter password field to enter into the database.
View 4 RepliesHow could one set a password on a database in Sql server 2005 & 2008
View 3 Repliesi was attaching northwind database with sql server 2005 so while attaching it gives me an error an exception occured while executing a transct -sql statemnet or batch ,unable to eon physical file "C:sql server 2000 sample database orthwnd.mdf"
View 6 RepliesI am a new-bie in Asp.Net.I am working in a project where I need to store an attachment which will be uploaded by the user in radGrid into Sql server 2005 database.After storing this attachment, I have to retrieve this attcahment and show the same to the other users in radGrid so that they will be able to download the attachment and see that.How should I do that?what kind of datatype would it be?
View 2 Repliesi had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql
View 2 RepliesI used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
View 3 RepliesI have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 RepliesI want to view '*' in Database in password column
View 1 RepliesI'm using ASP.NET 3.5 and Visual Studio 2008 C#.
I'm creating a website and currently making tests for registration. I've manage to create a registration form in the web site and save what the user inputs in the textboxes into a sql server 2008 database.
One of the fields is Password. What I want know is how do you save the password into the database but the database stores it encrypted. That way I'm just able to see the password encrypted. Then when I make a log-in form how to validate the password input by the user with the encrypted one and give a succesful login.
Migrating SSIS package from SQL Server 2005 to SQL Server 2008
View 1 RepliesPrevious developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
How can convert DTS package from SQL Server 2000 to SQL Server 2005
View 2 RepliesDoes anyone know, what is difference between SQL Server 2000, 2005 and 2008?
View 3 RepliesI have created my database in SQL Server 2005 Enterprise Edition and now planning to tranfer this databse to another server, But this other server is SQL Server Standard Edition, So if i try to attach my database which is created in Enterprise Edition will get sucesully connected to Standard Version ? or i will get any error message or i am doing something wrong ? This situation is fine or Version should be kept same ?
View 2 Replieswt is the difference b/w sql server 2000 sql server 2005
View 4 RepliesThe sites that I've got are still in classic ASP. I know this is a good reason to move to .net but I don't want to have to redo all the sites yet.
So here is the problem:
[Code]....
When I have "On Error Resume Next" no erros get posted and everything runs just fine, the pulls from the database work perfectly. But as soon as we take On error resume next we start getting the following erros:
err#424err desc:Object requiredsql:SELECT Name,URL,Title FROM tblMenu WHERE Parent_ID=1 AND Deleted=0 ORDER BY SortOrderScript Name: /index2.asp
I have a web applicaton run at godaddy hosting and have a sqlserver 2005 database hosting also by godaddy .From 1 week My web site hacked , by putting a strange script at all my .ASPx and the same strange script at all my database row.after that I remove the permission and make only permission of view filesand after that yesterday my web site hacked again by the strange script??? but my files didn't hacked .I scaned all my web sites files with updated antiviruse and with malware application but they didn't find any thing
View 5 RepliesIs there any way to alter or modify the synonyms in SQL Server 2005 (either using SQL Server Management Studio or T-SQL)
View 1 Replies1 - Visual studio 2008 is already installed with sql server 2005 express edition installed implicity with it.
2 - Sql server 2005 management studion Express Edition is already installed.
3 - Today, I downloaded the one with Advanced Services and installed it but it did not compledte installation
A) [URL]
B) [URL]
C) [URL]
D) [URL]
let say i have 2 table (PARENT and STUDENT table)
the structure for both table are
STUDENT
PARENT
student_id (PK) parent_id (PK)
student_parent (FK) parent_status (the value is either ACTIVE OR INACTIVE)
- parent_id is refer by STUDENT table as a foreign key
- now i want to inactive the status for parent
- i want my system pop out a message something like "The parent you want to inactive is refer by a student, inactive is not allow"
- is it any constraint in SQL Server 2005 to help me check whether parent it is refer by student table? The concept i want to use is something like delete constraint in SQL Server 2005 mean it is not allow to delete a person who is refer by a student in STUDENT table.
The users of my webapplication are validated using database connection. This requires each user is a sql server database user. While logging their validity is checking by trying to create a connection using userid and password entered by the user. If connection opens successfully, it is a valid user. I also have a page in application to change the password, where sp_password is used to updated database password.
string connectionString = ConfigurationManager.AppSettings["DBServerName"];
//try to create a new connection dynamically using user id and password
connectionString = connectionString + User ID=" + userId + ";Password=" + password;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
}
The problem is after i change password, and logout and try to login, i am able to login using old passwd also. The line of code which creates and open connection succeeds with both old and new password. If i stop and run the application again this works.
I'm using an ODBC connection to connect a SQL 2005 database to my ASP.NET app in Visual Web Developer Express. I'm finding that the expected functionality that tutorials review does not work for ODBC connected databases the same way as it does for SQL databases created in the Web Developer. For example, I can't use stored procedures because the option to create one is disabled in the Web Developer, and if I create the stored procedure in SQL Server Management Studio Express, it doesn't show up in Web Developer because Web Developer only finds the system stored procedures, not the user-defined ones. I've seen other cases as well where database management options in Web Developer don't work with ODBC databases.
Am I missing something in my setup, or is there an inherent limitation with ODBC connected databases? Or, is this a limitation with using the Express versions of these development tools?
i am tring to connect to my db in sql server 2005 :) and have some problem with it.the error that i get is : Keyword not supported: 'datasource'.the line that i have an error is :
[Code]....
my code is simple:
[Code]....
Where can you download Northwind for SQLServer 2005? I tried this but there is no Northwind after the install... [URL]
View 1 RepliesIm using MS SQL 2005 as my database for asp.net application.. now i want to asign Static ip address to ms sql server 2005 to access all over the world... so would u plz tell me step by step to configure static ip to ms sql server 2005..
View 9 Replies