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.
Change SQL default date
i have encounter sql date problem on 2 computer 1st one read as dd/mm/yyyy and current machine's sql read as mm/dd/yyyy .................................................. .................. how do i change the 2nd machine's default ...
i have encounter sql date problem on 2 computer 1st one read as dd/mm/yyyy and current machine's sql read as mm/dd/yyyy .................................................. .................. how do i change the 2nd machine's default ...
answer(0) view(236) status(
)
)
SQL Server error '80040e14'
Hi I'm getting this error in my search.asp Microsoft OLE DB Provider for SQL Servererror '80040e14' Line 1: Incorrect syntax near '/'. /include/search.asp, line 184 Am not sure where the error is....am fairly new at asp so p...
Hi I'm getting this error in my search.asp Microsoft OLE DB Provider for SQL Servererror '80040e14' Line 1: Incorrect syntax near '/'. /include/search.asp, line 184 Am not sure where the error is....am fairly new at asp so p...
answer(2) view(373) status()
)
what if no results are found in SQL
Built a search/results page using dreamweaver and ASP. newbie to ASP. When i search for a miss-spelled parameter or a parmater that does not match any records in my SQL database i get a 500- internal server error....yes show friendly h...
Built a search/results page using dreamweaver and ASP. newbie to ASP. When i search for a miss-spelled parameter or a parmater that does not match any records in my SQL database i get a 500- internal server error....yes show friendly h...
answer(1) view(462) status()
)
MS Access or MY SQL????
Asp.net using MS Acess or My SQL I was just wondering if anyone could give me some advice on which database to use. I have to create a buying site in ASP.Net and was going to use MS Access for storing all my data in, but ive been looking ...
Asp.net using MS Acess or My SQL I was just wondering if anyone could give me some advice on which database to use. I have to create a buying site in ASP.Net and was going to use MS Access for storing all my data in, but ive been looking ...
answer(6) view(794) status()
)
How to change the COMPUTER NAME in SQL Server 2000 manager???
Hi PLEASE, I really need help. I have installed SQL Server 2000 Developer version on my Windows XP Professional. After I ran the "Enterprise Manager", under the "SQL Server Group", it must be my COMPUTER NAME (ie. a...
Hi PLEASE, I really need help. I have installed SQL Server 2000 Developer version on my Windows XP Professional. After I ran the "Enterprise Manager", under the "SQL Server Group", it must be my COMPUTER NAME (ie. a...
answer(6) view(88) status()
)
Products Database design
Hello, I have a few questions about the design of a products database. Basically, we are creating a database that will store listings of products, similar to the way eBay stores their auctions. I am not trying to duplicate their datab...
Hello, I have a few questions about the design of a products database. Basically, we are creating a database that will store listings of products, similar to the way eBay stores their auctions. I am not trying to duplicate their datab...
answer(2) view(124) status()
)
Retrieving Files from sql server
Does anyone have any ideas as to how I could extract a file (.pdf) which is stored in a sql server table and save it in a file system? The pdf's need to be stored in the database so that I can restrict access to them to their respective cl...
Does anyone have any ideas as to how I could extract a file (.pdf) which is stored in a sql server table and save it in a file system? The pdf's need to be stored in the database so that I can restrict access to them to their respective cl...
answer(0) view(361) status()
)
Connecting to wrong DBase
I have created a web site in asp.net with an ms sql database. I wanted to transfer it across to a laptop. I did this and changed the connection string in the site so that it would connect to the laptop server but the laptop keeps trying to ...
I have created a web site in asp.net with an ms sql database. I wanted to transfer it across to a laptop. I did this and changed the connection string in the site so that it would connect to the laptop server but the laptop keeps trying to ...
answer(1) view(399) status()
)
Stored Procedures & ASP?
Is it possible to reference and use stored procedures with SQL (or even Access) and ASP? Would there be any advantages to this? What about disadvantages? It seems like you could have a completely modifiable website, running only one .a...
Is it possible to reference and use stored procedures with SQL (or even Access) and ASP? Would there be any advantages to this? What about disadvantages? It seems like you could have a completely modifiable website, running only one .a...
answer(4) view(376) status()
)
Table/View Descriptions
I'm using SQL Server for my DB and MS Access as my client. When I connect to my DB I get table names, but nothing else. How can I view my created dates and especially, how do I view the descriptions for my tables/views/functions in my Acc...
I'm using SQL Server for my DB and MS Access as my client. When I connect to my DB I get table names, but nothing else. How can I view my created dates and especially, how do I view the descriptions for my tables/views/functions in my Acc...
answer(0) view(388) status()
)
intermittent 'unspecified error'
I'm getting an 'unspecified error' when i'm trying to open a recordset in MS SQL Server 7. I noticed that when I open the Enterprise Manager, '\\server is not known to be running' after I click yes and start restoring my latest backup. wh...
I'm getting an 'unspecified error' when i'm trying to open a recordset in MS SQL Server 7. I noticed that when I open the Enterprise Manager, '\\server is not known to be running' after I click yes and start restoring my latest backup. wh...
answer(0) view(404) status()
)
SPACE and REPLICATE help needed
Hello, I am building a bill of material where based on the level each part is in the bill of material I want to add a number of leading spaces to the output. I can't seem to be able to add the number of spaces as the output comes out wit...
Hello, I am building a bill of material where based on the level each part is in the bill of material I want to add a number of leading spaces to the output. I can't seem to be able to add the number of spaces as the output comes out wit...
answer(0) view(435) status()
)
Copy a Table to a New DB
Hello All! Can anyone tell me how to copy a table from one DB to another in MSSQL 2000? I am mostly concerned with the structure and not the data. Both DBs reside on the same server. Regards, Michael
Hello All! Can anyone tell me how to copy a table from one DB to another in MSSQL 2000? I am mostly concerned with the structure and not the data. Both DBs reside on the same server. Regards, Michael
answer(2) view(42) status()
)
ODBC Drivers error '80040e14'
I keep getting this error on my asp page; i think i need to change the value, but!!! am pretty new to this. I would appreciate if someone would help. Microsoft OLE DB Provider for ODBC Driverserror '80040e14' [Microsoft][ODBC SQL Serve...
I keep getting this error on my asp page; i think i need to change the value, but!!! am pretty new to this. I would appreciate if someone would help. Microsoft OLE DB Provider for ODBC Driverserror '80040e14' [Microsoft][ODBC SQL Serve...
answer(4) view(221) status()
)
creating a SQL Query
Hi friends! I am facing a difficulty in creating a query in SQL. I have a table name as master which has fields ------------------------------------------------------------------ pid | pretailPrice | pourPrice | cat -------------------...
Hi friends! I am facing a difficulty in creating a query in SQL. I have a table name as master which has fields ------------------------------------------------------------------ pid | pretailPrice | pourPrice | cat -------------------...
answer(4) view(452) status()
)
Free SQL database hosting services.
I'm looking for a place to host an SQL database for free. I've tried the two most popular that have been recommended to me (freesql.org and unlimited-sql) which are either a) not accepting registrations or b) no longer in service. If anyb...
I'm looking for a place to host an SQL database for free. I've tried the two most popular that have been recommended to me (freesql.org and unlimited-sql) which are either a) not accepting registrations or b) no longer in service. If anyb...
answer(0) view(706) status()
)
Default Value
Hello there, i would like to know if there is a way to set a field in my SQL database table so it inserts a value every time there is a new record in the table. I mean something like the option in MSAccess 'Autonumber' or 'Autonum...
Hello there, i would like to know if there is a way to set a field in my SQL database table so it inserts a value every time there is a new record in the table. I mean something like the option in MSAccess 'Autonumber' or 'Autonum...
answer(2) view(15) status()
)
Lost SQL 6.5 sa password
Is there a way to change the this password, I need to move the databse to a different server. Thanks for any help. Eugen
Is there a way to change the this password, I need to move the databse to a different server. Thanks for any help. Eugen
answer(1) view(503) status()
)
How to Remove a Validation
I converted a database from Access to SQL Server. the Default value for one field in the access database was set to >0. Now the the database is SQL Server and I do not know how to change the >0 setting for one field in one of the ...
I converted a database from Access to SQL Server. the Default value for one field in the access database was set to >0. Now the the database is SQL Server and I do not know how to change the >0 setting for one field in one of the ...
answer(5) view(212) status()
)
Count without Group By
I have a working SQL statement that returns record information from a records table as well as the number of items in the items table linked to the records table. The Query looks like this: SELECT mn_records.*, count(mn_items.parentRecor...
I have a working SQL statement that returns record information from a records table as well as the number of items in the items table linked to the records table. The Query looks like this: SELECT mn_records.*, count(mn_items.parentRecor...
answer(1) view(847) status()
)
SQL Server 2000 Designing HOT CBT !!
I am selling Transcender series Transtrainer SQL Server 2000 Database Designing and CBT Nuggets series Exchange 2000 Administration at almost free price. Contact me at: URL
I am selling Transcender series Transtrainer SQL Server 2000 Database Designing and CBT Nuggets series Exchange 2000 Administration at almost free price. Contact me at: URL
answer(0) view(301) status()
)
Connection To Ms Sql (login Failure!!!)
Im current working on this example in my ASP.NET Book. Creating a ADO.NET Shopping Cart for a Bookstore. A Database to store all books. Stored procedures (MS SQL 2000) parameterized queries (MS Access 2003) for all add, update, delete, and ...
Im current working on this example in my ASP.NET Book. Creating a ADO.NET Shopping Cart for a Bookstore. A Database to store all books. Stored procedures (MS SQL 2000) parameterized queries (MS Access 2003) for all add, update, delete, and ...
answer(1) view(708) status()
)
SQL Decimal
Hi! I'm Bhong Amandi and new in ASp Programming. How can I add SQL Decimal fields using ASP? because my code erro say's its invalid type. Thanx and more power
Hi! I'm Bhong Amandi and new in ASp Programming. How can I add SQL Decimal fields using ASP? because my code erro say's its invalid type. Thanx and more power
answer(0) view(313) status()
)
Help writing SP to do search
I have tables that store data for Patients and Diagnosis information. Diagnosis Table dgID Primary Key dgName Patient Table ptID Primary Key ptAdmissionDate ptLastName ptFirstName ptAdmittingInte...
I have tables that store data for Patients and Diagnosis information. Diagnosis Table dgID Primary Key dgName Patient Table ptID Primary Key ptAdmissionDate ptLastName ptFirstName ptAdmittingInte...
answer(1) view(794) status()
)
SQL server address?
Is there any to find out the name of the SQL server that a particular DB driven website is using? (example: www.mysite.com is pulling info from WhatSITE.com)
Is there any to find out the name of the SQL server that a particular DB driven website is using? (example: www.mysite.com is pulling info from WhatSITE.com)
answer(3) view(406) status()
)
Disabling the List Box Until all Records are Dispalyed
I am using MS Access ADP front end and SQL in Back end. I have a form that is bounded to a Table with 20,000 records. That form has a list box in form Header Section where users select the record and it displays in Detail Section. The forms...
I am using MS Access ADP front end and SQL in Back end. I have a form that is bounded to a Table with 20,000 records. That form has a list box in form Header Section where users select the record and it displays in Detail Section. The forms...
answer(1) view(256) status()
)
linking form to ms access database
Hey! I'm trying to link the responses from a survey to my pre-existing MS ACCESS database. The survey consists of radio buttons, checkboxes, and a couple of text boxes. I would like for each checkbox to be read in seperately. Currently, if ...
Hey! I'm trying to link the responses from a survey to my pre-existing MS ACCESS database. The survey consists of radio buttons, checkboxes, and a couple of text boxes. I would like for each checkbox to be read in seperately. Currently, if ...
answer(0) view(464) status()
)
insert picture to sql Database
hi everybody..hi a todos. I need sample code to insert picture to sql Database with ASP or store procedure from sql. My problem is the following one, I have the workers photos and want to extract them they're credentials simultaneously ...
hi everybody..hi a todos. I need sample code to insert picture to sql Database with ASP or store procedure from sql. My problem is the following one, I have the workers photos and want to extract them they're credentials simultaneously ...
answer(2) view(491) status()
)
Converting an Int field to an indentity
Is it possible to convert an int field into an identity field without losing any of the previous values in the int field? Simon.
Is it possible to convert an int field into an identity field without losing any of the previous values in the int field? Simon.
answer(6) view(728) status()
)
Upsizing Access to SQL - Can't add new records
Hello, I have some asp pages that used to update an access database. I have uploaded the access database to sql server and changed lots of things in my code and databases including the connection string, date delimiters (# to '), databa...
Hello, I have some asp pages that used to update an access database. I have uploaded the access database to sql server and changed lots of things in my code and databases including the connection string, date delimiters (# to '), databa...
answer(5) view(166) status()
)
Programming
Related Pages
- Connecting SQLServer to Access2000
- Update multiple records in storedprocedure!!!
- SQL Server equivalent of Oracle's NVL?
- Query Question
- Database Filesize Maintenance Question
- HELP! lock analysis
- How to improve this code?
- Cannot paste my text into column
- Static IP public address
- errors in enterprise manager
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