Home > Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.
Need help on database
Sorry, I'm a newbie out there when it comes to creating database. I currently have an ASP.Net project which requires a database. I spent the past few days thinking about how to create a proper database for the application but to no avail. I...
Sorry, I'm a newbie out there when it comes to creating database. I currently have an ASP.Net project which requires a database. I spent the past few days thinking about how to create a proper database for the application but to no avail. I...
answer(1) view(910) status(
)
)
ms sql newbie... need some understanding!
hi guys, i have just started using mysql, as the host we were using conveniently dumped the OLEDB method of interaction, and therefore i had to change from a .mdb and using asp.net. i need to be able to query the database from enterin...
hi guys, i have just started using mysql, as the host we were using conveniently dumped the OLEDB method of interaction, and therefore i had to change from a .mdb and using asp.net. i need to be able to query the database from enterin...
answer(4) view(301) status()
)
xp_sendmail not working
i am having trouble testing my sql mail. i set everything up between my exchange client and my mapi settings...i can run the test connection in sql server 7, but when i write the test query to send an email message, the query analyzer says ...
i am having trouble testing my sql mail. i set everything up between my exchange client and my mapi settings...i can run the test connection in sql server 7, but when i write the test query to send an email message, the query analyzer says ...
answer(1) view(215) status()
)
sql server db connection
If my asp files and sql server database are on different server, how can I code the connection statement? can I do like this: strConn = "Provider=sqloledb;User ID='id'; pw='pwd'; Data Source=sql server name; Initial Catalog=db nam...
If my asp files and sql server database are on different server, how can I code the connection statement? can I do like this: strConn = "Provider=sqloledb;User ID='id'; pw='pwd'; Data Source=sql server name; Initial Catalog=db nam...
answer(2) view(551) status()
)
Query Data Option - DTS
Hi, Im connecting 2 sql servers one has source data the other is for publishing the data. When i use the query option on DTS i can put in a sql string, says its okay and also will complete successfully but i can't see any data being added ...
Hi, Im connecting 2 sql servers one has source data the other is for publishing the data. When i use the query option on DTS i can put in a sql string, says its okay and also will complete successfully but i can't see any data being added ...
answer(0) view(525) status()
)
DTS Help - What to do after DTS
HI, Im transfering data between 2 servers which seems to be a pain because it fails so i have to do it a couple tables at a time but do you have to do anything after your dts wizard says complete for you to see the data? Thanks Nick
HI, Im transfering data between 2 servers which seems to be a pain because it fails so i have to do it a couple tables at a time but do you have to do anything after your dts wizard says complete for you to see the data? Thanks Nick
answer(1) view(716) status()
)
Calling Stored procedure from MS Access
Hi I am trying to pass date parameters from MS Access form to stored procedure on SQL server . When I execute the code I am getting an error on "qd.execute " The error message is Number: 3065 Source : DAO.QueryDef Text: Can...
Hi I am trying to pass date parameters from MS Access form to stored procedure on SQL server . When I execute the code I am getting an error on "qd.execute " The error message is Number: 3065 Source : DAO.QueryDef Text: Can...
answer(0) view(385) status()
)
select statement help
I have a select query statement that is not producing the results i want. I am joining a table (B) to another table (A). Table A will always have one record, but table B may have 0 or more records. If table B has at least one record, one...
I have a select query statement that is not producing the results i want. I am joining a table (B) to another table (A). Table A will always have one record, but table B may have 0 or more records. If table B has at least one record, one...
answer(1) view(862) status()
)
simple connection question
I'm new to the SQL Server and asp realm, I've worked with Access, but needed more to my database interaction. Anyways, I'm trying to connect to my database and can't seem to get it to work. I set up a DSN, and my permissions all look ok. ...
I'm new to the SQL Server and asp realm, I've worked with Access, but needed more to my database interaction. Anyways, I'm trying to connect to my database and can't seem to get it to work. I set up a DSN, and my permissions all look ok. ...
answer(7) view(413) status()
)
Trouble using fn_get_sql to capture table changes
I created an trigger (on insert and update) on a table that uses the new fn_get_sql function that comes with SQL Server 2000 SP3. I use it to record who performed what transaction and when they did it. It looks like this: -------------...
I created an trigger (on insert and update) on a table that uses the new fn_get_sql function that comes with SQL Server 2000 SP3. I use it to record who performed what transaction and when they did it. It looks like this: -------------...
answer(1) view(790) status()
)
SQL Statement
May i know can i do this? Dim strSQL as String = "select count(*) as 'count' from Login where UserName = '" & txtLogin.text & "' and Password = '" & txtPassword.text & "' and '" & txtType...
May i know can i do this? Dim strSQL as String = "select count(*) as 'count' from Login where UserName = '" & txtLogin.text & "' and Password = '" & txtPassword.text & "' and '" & txtType...
answer(5) view(980) status()
)
Encryption
I want to do encryption of the password field in the database. I have read about the encrypt(), pwdencrypt(), pwdcompare() functions. Here are some questions that i am concerned about. a) Does using a standard SQL function that could be...
I want to do encryption of the password field in the database. I have read about the encrypt(), pwdencrypt(), pwdcompare() functions. Here are some questions that i am concerned about. a) Does using a standard SQL function that could be...
answer(1) view(140) status()
)
Update Trigger not working
Hi Friends, The following is the code for my update trigger: CREATE TRIGGER TransTrig ON TransTest after UPDATE AS If UPDATE(Status) BEGIN declare @status nvarchar(10); declare @audio nvarchar(20); select @status=status,@a...
Hi Friends, The following is the code for my update trigger: CREATE TRIGGER TransTrig ON TransTest after UPDATE AS If UPDATE(Status) BEGIN declare @status nvarchar(10); declare @audio nvarchar(20); select @status=status,@a...
answer(1) view(533) status()
)
Can't alter table
I am using the following code to (try to) insert a new column into an existing database but the response back from the response.writes are the two existing columns, no new one. Code: <!--#include virtual="/mmd/mmdnr/...
I am using the following code to (try to) insert a new column into an existing database but the response back from the response.writes are the two existing columns, no new one. Code: <!--#include virtual="/mmd/mmdnr/...
answer(1) view(145) status()
)
new in sql analysis server
Hi all: I install sql analysis server from my sql 2000 CD and I got error "unable to browse the dimension.unspecified error" why? please help! thank you.
Hi all: I install sql analysis server from my sql 2000 CD and I got error "unable to browse the dimension.unspecified error" why? please help! thank you.
answer(1) view(465) status()
)
Dot.NET Oracle database problem
Situation:<br>We抮e supposed to connect to the test Database(Oracle 9i) in a remote server from a local PC using VB.net.<br><br>The 2 providers we tested are:<br>Microsoft OLE DB provider for Oracle<br>Microsof...
Situation:<br>We抮e supposed to connect to the test Database(Oracle 9i) in a remote server from a local PC using VB.net.<br><br>The 2 providers we tested are:<br>Microsoft OLE DB provider for Oracle<br>Microsof...
answer(1) view(158) status()
)
Using instead of triggers
Hi, I'm trying to use a trigger to make sure no duplicates records would be added to my table (using sql server 2000). I've tried using the "instead of" trigger but for some reason it doen't work. The code is : Code: ...
Hi, I'm trying to use a trigger to make sure no duplicates records would be added to my table (using sql server 2000). I've tried using the "instead of" trigger but for some reason it doen't work. The code is : Code: ...
answer(1) view(530) status()
)
n00b: Question on SQL Query w/SUM
n00b to these forums. Hopefully I have found a place where I can get my advanced SQL whipped in to shape. Thanks in advance. 3 tables: Shopping_Carts Inventory Specials Long and short of it, I want to get a subtotal of the pro...
n00b to these forums. Hopefully I have found a place where I can get my advanced SQL whipped in to shape. Thanks in advance. 3 tables: Shopping_Carts Inventory Specials Long and short of it, I want to get a subtotal of the pro...
answer(0) view(785) status()
)
Attach DB problem
I am attempting to attach a database and I am getting the following error: Server: Msg 823, Level 24, State 2, Line 1 I/O error (bad page ID) detected during read at offset 0x000001f3400000 in file 'c:\code\data\ikb36pmm_data.mdf'. ...
I am attempting to attach a database and I am getting the following error: Server: Msg 823, Level 24, State 2, Line 1 I/O error (bad page ID) detected during read at offset 0x000001f3400000 in file 'c:\code\data\ikb36pmm_data.mdf'. ...
answer(1) view(154) status()
)
optimisticUpdate and blocking problems
The following sequence of events works fine using Websphere App Serv and SQL Server client gets update lock on table (ie pessUpdate) does a few updates starts new tran new tran does a read (optimisticUpdate) tran comits and first tra...
The following sequence of events works fine using Websphere App Serv and SQL Server client gets update lock on table (ie pessUpdate) does a few updates starts new tran new tran does a read (optimisticUpdate) tran comits and first tra...
answer(0) view(843) status()
)
Sql Trigger Problem
I have created the following trigger it is running successfully on my local sql server the trigger inserts a row in a child table if there is an insertion in the parent table simply enforcing RI. ok all fine BUT WHEN I EXECUTE THE ...
I have created the following trigger it is running successfully on my local sql server the trigger inserts a row in a child table if there is an insertion in the parent table simply enforcing RI. ok all fine BUT WHEN I EXECUTE THE ...
answer(0) view(319) status()
)
HELP! lock analysis
Hi, I get "Transaction (process id 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim" I getthis error when pid 51 is removing an EJB from the database. In other words it is p...
Hi, I get "Transaction (process id 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim" I getthis error when pid 51 is removing an EJB from the database. In other words it is p...
answer(1) view(28) status()
)
relationship setting in sql
hi, i m having a database which contain more than 3 table. i lke to get the value form 3 table and make it as one table. in first table using where condition i will pass two variable. it will filter and give a column call produ...
hi, i m having a database which contain more than 3 table. i lke to get the value form 3 table and make it as one table. in first table using where condition i will pass two variable. it will filter and give a column call produ...
answer(0) view(373) status()
)
Ms Sql Server
I want to know whether there is any method or way by which we can restrict the sa(SQL Server Administrator) to any one of the databases in MS SQL Server. I want urgent reply.
I want to know whether there is any method or way by which we can restrict the sa(SQL Server Administrator) to any one of the databases in MS SQL Server. I want urgent reply.
answer(0) view(729) status()
)
Importing SQL Database
Hi, I'm new to SQL Server ....can anybody suggest a way for my problem. For some reasons I had reinstall all my softwares in my system. So, before doing that I have taken a copy of the MDF file I created. Now, after re-installation...
Hi, I'm new to SQL Server ....can anybody suggest a way for my problem. For some reasons I had reinstall all my softwares in my system. So, before doing that I have taken a copy of the MDF file I created. Now, after re-installation...
answer(2) view(972) status()
)
Looking for recommendation for Stress Testing Web Based SQL Server applications.
Can anyone recommend any software for Stress Testing a Web application w/ a Sql Server back end?
Can anyone recommend any software for Stress Testing a Web application w/ a Sql Server back end?
answer(1) view(723) status()
)
Execute the SQL generated as a Resultset
Hi, I am writing following code: SET QUOTED_IDENTIFIER OFF Drop Table #T1 Create Table #T1 (UID int, Qid int, DL int) Insert Into #T1 SELECT QB.Unit_No,QB.QID,QB_MCQ.Diff_Level FROM QB INNER JOIN QB_MCQ ON...
Hi, I am writing following code: SET QUOTED_IDENTIFIER OFF Drop Table #T1 Create Table #T1 (UID int, Qid int, DL int) Insert Into #T1 SELECT QB.Unit_No,QB.QID,QB_MCQ.Diff_Level FROM QB INNER JOIN QB_MCQ ON...
answer(2) view(933) status()
)
Thumbnail with Database
Hi, I am making an Auto Dealer website. The dealer wants to post data about each vechicle along with a thumbnail image and larger image. The dealer will have a few hundred vehicles to sell at any one time. My intension.... was to cr...
Hi, I am making an Auto Dealer website. The dealer wants to post data about each vechicle along with a thumbnail image and larger image. The dealer will have a few hundred vehicles to sell at any one time. My intension.... was to cr...
answer(1) view(929) status()
)
Collation Conflict
I am getting the following error on a SQL Server with collation type of "SQL_Latin1_General_CP1_CS_AS" and all my tables are of the collation type of "Database_Default". The error is Implicit conversion of varchar val...
I am getting the following error on a SQL Server with collation type of "SQL_Latin1_General_CP1_CS_AS" and all my tables are of the collation type of "Database_Default". The error is Implicit conversion of varchar val...
answer(1) view(550) status()
)
HUGE problem - how to know how many rows changed in UPDATE ?
i'm running this: UPDATE COUNTER SET ID=ID+1 WHERE ID=5 i need to know if the UPDATE changed the record. any ideas? thank you.
i'm running this: UPDATE COUNTER SET ID=ID+1 WHERE ID=5 i need to know if the UPDATE changed the record. any ideas? thank you.
answer(1) view(332) status()
)
Programming
Related Pages
- [SQL Server 2005] No Report Manager after install SQL Express and RS
- Index
- server not found/access denied error
- Decimal value from database gets converted to int in app
- Struggling to figure out a query
- Stored Procedure Problems (2)
- Help writing SP to do search
- optimisticUpdate and blocking problems
- Download for sql server 2005/
- Code Help
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2008 by Infoqu. All rights reserved
Copyright 2007-2008 by Infoqu. All rights reserved