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.
MDB in password protected directory
Hi <br>I use ASP , ADO <br>I have an access file in a password protected directory.. when I use the connection string : <br><br>strCon="Data source=" & server.MapPath("FilePath/FileName.mdb") ...
Hi <br>I use ASP , ADO <br>I have an access file in a password protected directory.. when I use the connection string : <br><br>strCon="Data source=" & server.MapPath("FilePath/FileName.mdb") ...
answer(1) view(43) status(
)
)
DataGrid for data input from user in ASP.
<b>HELLO</b><br> I"m making a purchase detail online form, in this regard, how can I use dataGrid for getting inputs from user (for mulitiple rows in one form)
<b>HELLO</b><br> I"m making a purchase detail online form, in this regard, how can I use dataGrid for getting inputs from user (for mulitiple rows in one form)
answer(1) view(88) status()
)
Displaying a multiple tables recordset
Does ANYONE know how to display a record from a recordset which consists of multiple tables?I've already tried <font style="color:990000;">rs.fields("tablename.fieldname").value </font>and about a zillion oth...
Does ANYONE know how to display a record from a recordset which consists of multiple tables?I've already tried <font style="color:990000;">rs.fields("tablename.fieldname").value </font>and about a zillion oth...
answer(1) view(865) status()
)
Problem with CONTAINS and Free-text
Hiya, I'm trying to use the following to search 4 fields in total, 2 in one table two in another and return them as one recordset. strSQL = "SELECT id, tableID, tagline, content FROM tblNews WHERE CONTAINS (tagline, '" &...
Hiya, I'm trying to use the following to search 4 fields in total, 2 in one table two in another and return them as one recordset. strSQL = "SELECT id, tableID, tagline, content FROM tblNews WHERE CONTAINS (tagline, '" &...
answer(0) view(935) status()
)
Webshop currency problem
Hi! I'm trying to build a shop using an MS SQL database, but I have a little problem. I have all the prices in the databases as money type. (ex: 234,45). When I display the price list into my asp pages then I receive the number into th...
Hi! I'm trying to build a shop using an MS SQL database, but I have a little problem. I have all the prices in the databases as money type. (ex: 234,45). When I display the price list into my asp pages then I receive the number into th...
answer(0) view(844) status()
)
Problem finding match with MS SQL/ASP query
For some reason since migrating to a MS SQL database the following always returns no results: 'Open a recorset to check whether or not filename is already in use Dim objRS Set objRS = Server.CreateObject("ADODB.Recordset"...
For some reason since migrating to a MS SQL database the following always returns no results: 'Open a recorset to check whether or not filename is already in use Dim objRS Set objRS = Server.CreateObject("ADODB.Recordset"...
answer(1) view(432) status()
)
cross database join
A query running fine in QueryAnalyzer creates an error "Invalid object name" when run through a Java connection. The object in error is a table in a database other then the one connected to. Why is this a problem from Java? I a...
A query running fine in QueryAnalyzer creates an error "Invalid object name" when run through a Java connection. The object in error is a table in a database other then the one connected to. Why is this a problem from Java? I a...
answer(1) view(222) status()
)
SQL & Access
hi, currently i m using MS Access (Table, Form, Query & Report), i would like to migrate to SQL server whereby i just want the back-engine to be SQL(table & data) and maintain using MS Access for interface (Form, Query & Repo...
hi, currently i m using MS Access (Table, Form, Query & Report), i would like to migrate to SQL server whereby i just want the back-engine to be SQL(table & data) and maintain using MS Access for interface (Form, Query & Repo...
answer(3) view(859) status()
)
automated procedure in sql server
i'm trying to set up a table in sql server that will automatically update based on the date. basically, i want to display a list of dates for a year, given a set interval. when one date passes, i want its status set to inactive, and a new d...
i'm trying to set up a table in sql server that will automatically update based on the date. basically, i want to display a list of dates for a year, given a set interval. when one date passes, i want its status set to inactive, and a new d...
answer(1) view(204) status()
)
Creating database user and connecting with it
I want to create two users for my MY SQL database. One will be for the general public, which will allow whomever to perform SELECT queries only i.e. view the data. The other user will be for admin purposes and will allow for SELECT U...
I want to create two users for my MY SQL database. One will be for the general public, which will allow whomever to perform SELECT queries only i.e. view the data. The other user will be for admin purposes and will allow for SELECT U...
answer(1) view(208) status()
)
Connecting to databse problem
Hey, I'm fairly new to web programming...I'm using MySQL, ASP, And VBScript...NOT PHP!! I have set up a connection between the database and dreamweaver...the database has 1 table with 1 field that is just a string named "message."...
Hey, I'm fairly new to web programming...I'm using MySQL, ASP, And VBScript...NOT PHP!! I have set up a connection between the database and dreamweaver...the database has 1 table with 1 field that is just a string named "message."...
answer(3) view(147) status()
)
additional problem deleting dbs ( publication)
hi now i'm able to delete any dbs even if other user are connected, but if there is a replication (publication) concerned with this dbs it won't delete so how can i find out with sql-dmo whether there is a replication installed on this dbs...
hi now i'm able to delete any dbs even if other user are connected, but if there is a replication (publication) concerned with this dbs it won't delete so how can i find out with sql-dmo whether there is a replication installed on this dbs...
answer(1) view(198) status()
)
newbie
can anyone explain to me how to connect to a mysql database from an asp file using VBScript from within dreamweaver MX? I'm not sure I understand what a connection string is or DSN/ODBC...thanks! mikell
can anyone explain to me how to connect to a mysql database from an asp file using VBScript from within dreamweaver MX? I'm not sure I understand what a connection string is or DSN/ODBC...thanks! mikell
answer(1) view(260) status()
)
wanna check whether dbs is in replicationmode
wanna check whether dbs is in replicationmode so i thought that calling dim tester as string server.ExecuteWithResultsAndMessages("sp_helpreplicationdboption 'dbsname' ", , tester) would help me but tester is always "...
wanna check whether dbs is in replicationmode so i thought that calling dim tester as string server.ExecuteWithResultsAndMessages("sp_helpreplicationdboption 'dbsname' ", , tester) would help me but tester is always "...
answer(0) view(151) status()
)
table in ascending order?
How do I order a table in ascending order? the code below works fine until the ActivityID goes above 9! the code below orders the data in the table in the following way 1,10,2,3,4,5,6,7,8,9 as you can see when I add 1 to the last ...
How do I order a table in ascending order? the code below works fine until the ActivityID goes above 9! the code below orders the data in the table in the following way 1,10,2,3,4,5,6,7,8,9 as you can see when I add 1 to the last ...
answer(2) view(626) status()
)
Scripting a DTS package
Is it possible to script a DTS package so that it can be recreated on another server? I know you can output a DTS package to a structured file or to VB (6.0?) code, but I want to script the DTS package in the same way that a table or stored...
Is it possible to script a DTS package so that it can be recreated on another server? I know you can output a DTS package to a structured file or to VB (6.0?) code, but I want to script the DTS package in the same way that a table or stored...
answer(1) view(749) status()
)
Moving data from one SQL table to another
Hi, I am new to using SQL and I wonder if someone could give me a bit of assistance. I need to be able to move records from one SQL table to another, but I also need to read the previous entry in one of the columns and increment the num...
Hi, I am new to using SQL and I wonder if someone could give me a bit of assistance. I need to be able to move records from one SQL table to another, but I also need to read the previous entry in one of the columns and increment the num...
answer(2) view(521) status()
)
wanna delete sql database
i wanna delete an sql database with sqldmo even if someone uses this database, how can i realize to force the delete?? greets nobby
i wanna delete an sql database with sqldmo even if someone uses this database, how can i realize to force the delete?? greets nobby
answer(2) view(251) status()
)
Help with datepart in SQL/ASP
Can you use datepart in an SQL query within an ASP page. The following code gives the following error when I try and use the record set Error Type: ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been dele...
Can you use datepart in an SQL query within an ASP page. The following code gives the following error when I try and use the record set Error Type: ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been dele...
answer(2) view(752) status()
)
relocating datafile in sql server
hi friends, could any one please tell me how to relocate datafile in sql server? TIA Anand
hi friends, could any one please tell me how to relocate datafile in sql server? TIA Anand
answer(1) view(820) status()
)
Unattended Installation
i generate one installshield.iss file with this switch: (k=Dk) install mode desktop (k=Rc) invoke an unattended installation \x86\setup\setupsql k=Kd k=Rc Great create setup.iss in c:\windows the problem if i use lines below to...
i generate one installshield.iss file with this switch: (k=Dk) install mode desktop (k=Rc) invoke an unattended installation \x86\setup\setupsql k=Kd k=Rc Great create setup.iss in c:\windows the problem if i use lines below to...
answer(0) view(68) status()
)
Connect to Remote Servers with IP Addresses only
Unable to connect to server 206.xxx.xxx.xx : Server: Msg 17, Level 16, State 1 Server Does not exist or access denied. If i go to QA and just type in the IP Address in to the SQL Server dropdown box at the first screen and enter use...
Unable to connect to server 206.xxx.xxx.xx : Server: Msg 17, Level 16, State 1 Server Does not exist or access denied. If i go to QA and just type in the IP Address in to the SQL Server dropdown box at the first screen and enter use...
answer(5) view(902) status()
)
Table Info
I'd like to get a snapshot of a table's data, including the column names...i've been doing it manually, but it's getting to be a lot of work...I know there has to be a simple way to do this, anyone have suggestions? Thanks JJ
I'd like to get a snapshot of a table's data, including the column names...i've been doing it manually, but it's getting to be a lot of work...I know there has to be a simple way to do this, anyone have suggestions? Thanks JJ
answer(0) view(966) status()
)
When should I use IDENTITY field ?
Hi all. I'm going to create a big DB that will hold important info (the usual stuff - Clients, Products, Orders...) I wonder where should I use the IDENTITY field, for example - on Orders I will have Order_ID... (and where does...
Hi all. I'm going to create a big DB that will hold important info (the usual stuff - Clients, Products, Orders...) I wonder where should I use the IDENTITY field, for example - on Orders I will have Order_ID... (and where does...
answer(2) view(577) status()
)
xp_sendmail missing
I am trying to set up my sql mail for creating automated emails...i have everything set up correctly, but i can't test it because i dont have the "xp_sendmail" stored procedure in any of my sql databases...anyone know where i can ...
I am trying to set up my sql mail for creating automated emails...i have everything set up correctly, but i can't test it because i dont have the "xp_sendmail" stored procedure in any of my sql databases...anyone know where i can ...
answer(1) view(142) status()
)
Replication Between Different Versions of SQL Server
Hello, We are trying to set up replication between different versions of SQL Server (7 & 2000). This is how the 2 servers are now setup: DB1 - External web-server w/SQL Server 7 DB2 - Internal server w/SQL Server 2000 REPLICA...
Hello, We are trying to set up replication between different versions of SQL Server (7 & 2000). This is how the 2 servers are now setup: DB1 - External web-server w/SQL Server 7 DB2 - Internal server w/SQL Server 2000 REPLICA...
answer(0) view(992) status()
)
MS SQL Server 7 access is denied in EM after SP4
A connection could not be established to "Server Name" - Access denied ConnectionOpen (CreateFile()).. Please Verify SQL Server is running and check you SQL Server registration properties (by right clicking on the GAMMA node)...
A connection could not be established to "Server Name" - Access denied ConnectionOpen (CreateFile()).. Please Verify SQL Server is running and check you SQL Server registration properties (by right clicking on the GAMMA node)...
answer(1) view(807) status()
)
Do I use a Stored Procedure?
I need to know if using a stored procedure is the way to go for a recordset I'm atempting to do. I have two tables and the datasets look something like this Table 1 ID Date Info 1 10/01/03 blah 2 10/2/03 ...
I need to know if using a stored procedure is the way to go for a recordset I'm atempting to do. I have two tables and the datasets look something like this Table 1 ID Date Info 1 10/01/03 blah 2 10/2/03 ...
answer(3) view(788) status()
)
Fetch Page
How do i fetch a page so that i can pass it into the HTML parser to load the data into SQL database?
How do i fetch a page so that i can pass it into the HTML parser to load the data into SQL database?
answer(0) view(668) status()
)
Crystal Report accessing MSSQL
First the situation Windows 2003 server Windows XP Workstations SQL 2000 Crystal 8.5 All of the above have the latest downloads and patches to the best of my knowledge Reports have been written for some time and worked on Win 20...
First the situation Windows 2003 server Windows XP Workstations SQL 2000 Crystal 8.5 All of the above have the latest downloads and patches to the best of my knowledge Reports have been written for some time and worked on Win 20...
answer(0) view(266) status()
)
Programming
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