hi,
please let me know how to refer to a row from a set of duplicated rows of a sql server database table.there are no primary keys/constraints in the table so as to refer it.Is there any thing like 'rowid' which we have in oracle?
thanks
sreeni
hi myself avii am developing one appilication in which i am using vb as front end andsql server 7.0 as backend. i all ready complete the full application andit installed it on my clients computer. but some times i need my clientsdata which is on his computer,so any one can help me to find out how do i connect to my clients sqlserver through internet i. e. how do i configure or use server networkutility / Client network utility. i need it very badly.plz help methose who r giving me their valuable help plz mentioned their email id sothat i can contact further
View 1 Replies View Relatedi have installated on my computer ms sqlserver 7 .I want to try sometransactions.Is it possible to connect as 2 or tree users just to simulateworking with many users?
View 1 Replies View RelatedHello All,
I am new to SQL Server. I would like to know how to format output using isql on SQLServer7.0
e.g.
I want this selection
CUST_ID CUST_NAME CUST_TYPE ADDRESS
----------- ----------- ----------- -----------
1 CUST 1 CREDIT RISK ADDRESS1
1 CUST 1 CREDIT RISK ADDRESS2
2 CUST 2 GOOD ADDRESS1
2 CUST 2 GOOD ADDRESS2
2 CUST 2 GOOD ADDRESS3
3 CUST 3 BAD ADDRESS1
to display like this
CUST_ID CUST_NAME CUST_TYPE ADDRESS
----------- ----------- ----------- -----------
1 CUST 1 CREDIT RISK ADDRESS1
ADDRESS2
2 CUST 2 GOOD ADDRESS1
ADDRESS2
ADDRESS3
You are help will be much appericated.
Thanks & Regards
Nitin.
how can i provide login id and password for each table in a database to avoid deletions and updations by other users.thanks.-sri
View 1 Replies View Relatedhi
we are taking incremental backup daily on sqlserver computer.we are using seagate backupexec ,suddenly
the back up of database files skipped .
saying
the itemMssql7datamaster.mdf in use -skipped
.....................................
...................................
normally we shedule this backup at midnight ,i am sure
that no body is using sqlserver ..
does any body know the reasony why it is skipping ,and how
to solve this problem.
thanks
bye
prasad
hi
we are taking incremental backup daily on sqlserver computer.we are using seagate backupexec ,suddenly
the back up of database files skipped .
saying
the itemMssql7datamaster.mdf in use -skipped
.....................................
...................................
normally we shedule this backup at midnight ,i am sure
that no body is using sqlserver ..
does any body know the reasony why it is skipping ,and how
to solve this problem.
thanks
bye
prasad
Hi
I have Windows 98
I had MSsql 7 installed and suddenly 3 days back I got error openconnection failed.
I reinstalled MSSql 7.0 in my machine now I have different problem
while installing when it comes to starting service it gets hang up for very long time and finally it says
Setup failed to configure the server. Refer to the server error
logs and cnfgsvr.out for more information
cnfgsvr.out file looks like this
Starting Service ...
An error occurred while attempting to start the service (1460)
SQL Server configuration failed.
can anyone figure out why sqlserver 7 cannot be started and it
remedy and send me solution to overcome
Thanks