Is it possible to run a SQL Server 2005 job from an asp.net intranet page? I've been opening up SQL Server 2005 and manually running this and thought it would really be convenient if I could just click a button on a web page instead.
View 2 RepliesI have been tasked with creating an intranet site and have been able to do everything so far (leaves the door open wide, I know ) EXCEPT get the username that the person is logged in as under their own computer.
<system.web>
<pages styleSheetTheme="Black"/>
<customErrors mode="Off"/>
<compilation debug="true" urlLinePragmas="true"/>
<authentication mode="Windows" />
<identity impersonate="true"/>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
</system.web>
Under my master page I am doing this:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Environment.UserName.Length > 0 Then
username.Visible = True
username.Text = Environment.UserName
Else
username.Visible = False
End If
End Sub
All I am getting is the ASP account name....what am I doing wrong??
I 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 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 have made a web service using asp.net and i want to install/upload at intranet server how can i do that..
View 1 RepliesIs it possible to call (Post to) a Method in a ASPX (Code behind) page via HTTP endpoint in Sql server 2008/2005.
View 1 RepliesI was asked if I could make some kind of alert to pop up 3 different statuses, a green light for - server good, a yellow light for - the server is experiencing technical difficulties and not may be running properly and a red light for - server is down.
So how would I go about doing that in an employees Intranet page so they can see if there is problems with the server if they are trying to log in and work.
I know they work with Visual Studio 2010 and probably work with IIS - so just in case if they work with Apache.
I am having great issues trying to debug a page on a web application used internally on an intranet. When entering the page the "Security Information" Pop Up Box appears. The whole application is running under https.
To try and debug the issue, I have used Fiddler, and looked at the urls for every component, javascript, css, images, and user control components. Everything I have seen from Fiddler shows that the urls start with required https! So, I am completely confused why this message should be shown - it appears everything the page is posted back.
I am running a test page on a local server that I want only to be available to comouters that are running on the LAN. However, My web page can be accessed over the internet, how can i stop this?
The page is running on a Windows Server 2003 pc using IIS 6.0
I 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 convert sql server 2000 database into sql server 2005 database. I am using sql server 2005 express.
I am trying by taking backup/Restore method, but it not work.
I need help making selections on my installation of SQL Server 2005 Developer Edition onto my Laptop (the only computer in my house). I need to develop a couple of different databases and use them from my Visual Studio applications. Then I will upload the SQL databases and the Web Applications to GoDaddy for deployment to general public.My question is that installation is asking me questions I honestly don't know how to answer because I am using a different SQL this time around after reformatting my hard drive"
1. Do I use Default or Named Instance?2. Do I use the Built-In System account or a Domain User account?3. If answer 2 is Domain User then I am in trouble because I don't think I have a Domain, and I don't know what one is. Where would I find the user name, the password, and the domain?
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 RepliesCould anyone tell me the features comparision between sql server 2000, 2005 and 2008 in the table format like below. sql server 2000 features | Extra features added/supported in 2005 | Extra features supported in 2008
View 2 Replies assist me rectifying the error in following sql stored procedure?
Sql Query:- [Code]....
I have created the above Stored Procedure for inserting datas into any table but while I execute the above proceedure its throwing some error.
I am using Sql Server 2005,My table structure is below.
Create Table ComentTable(id int,coments varchar(4000))
insert into ComentTable values(1,'sanjay I don%27t Know Tamil Language')
insert into ComentTable values(1,'sanjay I don%27t Know Kanar Language')
how to write storeprocedure update coments column replace %27 to '
I have one asp.net 2.0 application with MS Sql 2005 database.. As i deploy this database with client Machine.. now what i need is i need to take a backup of MS Sql 2004 database.. so is that any free tool is available which take daily backup...
View 16 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 RepliesIn machine XPSP2, I tried to install SQL SErver 2005 express edition (downloaded from the microsoft site) - after mode selction form (Windows/SQL server authentication) - system restarted, automatically.Again restarted, Again restarted,Again restarted,Again restarted,a 1000 times or more.finally I unplugged the system from the UPS
View 2 RepliesI want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
OLE DB provider "SQLNCLI" for linked server "xx.xxx.xxx.xxx" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
View 1 Replieswt is the difference b/w sql server 2000 sql server 2005
View 4 Replies