[font="Tahoma"]What is the error message you are receiving while connect to the table from asp.net??[/font]

Hi,

You can refer the below link, Chad has explained about this proc.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=265432&SiteID=1

Hi,

You can use Identity command. Example shown below.

CREATE TABLE tmp(empno Identity(1,1))

In the above example the column empno is used as identity and hence whenever a data is entered into the...

Hi,

In DSN at the server text column type servername in FQDN format or use IP address as shown below and configure the correct port number.

Ex.)

server.mshome.net

or

10.125.85.3

Hi,

Can you post the setup summary here??? Is SQLserver already installed or this is the first time you are installing??

Hi,

Welcome to sqlservercentral 🙂

Yes you are correct, SQLExpress also provides GUI to alter or to enter data's into table. For SQLExpress you need to download & Install SQL server management...

Refer the below link,

http://support.microsoft.com/default.aspx/kb/241267

Is primary server up??? Try start db mirroring once again. There may be problem with the end points. Try sending packets through the endpoints configured

Anu,

If you are using SSMSE then you can do the following

1.) Open SSMSE, connect to SQL express

2.) Press ctrl+shift+f

3.) enter the query and execute , then a window will pop-up...

Hi,

Try the following

1.) Update the statitics

2.) Create index based on the procedure

Hi Petey,

In which version of SQL you are facing the error, developer edition or in sql express????

Pls try the following

To change the authentication mode to SQL

1.) Change the registry value...

Use the below command to find out the DML and DDL triggers available in a database.

Run the command in a database

[font="Courier New"]select name as 'Trigger Name',case parent_class when 1 then...

Refer the below link, i think this may help you.

How to Rebuild System Databases in SQL 2005

There are High availability solutions available in SQL, use any one of these solution to handle such DR situations. These business critical solutions, i.e some of the data may not...

Refer the below link.

Moving SQL2005 db to SQL2000 db