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.
Connect to sql server using ole db provider
Using a javascript program i try to maintain a table defined in Sql server . Unfortunatelly the program can't update the table because the OLE DE PROVIDER cannot determine if you can write to each field . It returns for each field of the t...
Using a javascript program i try to maintain a table defined in Sql server . Unfortunatelly the program can't update the table because the OLE DE PROVIDER cannot determine if you can write to each field . It returns for each field of the t...
answer(0) view(220) status(
)
)
SQL Server Authentication
Hey, I'm trying to login to the SQL server using a SQL Server user name create in ConsolRoot\MicrosoftSQLServers\SQLServerGroup\Doma in\Security\Logins. The error I get when I try to logon is: The user name and password you entere...
Hey, I'm trying to login to the SQL server using a SQL Server user name create in ConsolRoot\MicrosoftSQLServers\SQLServerGroup\Doma in\Security\Logins. The error I get when I try to logon is: The user name and password you entere...
answer(0) view(802) status()
)
LIST the systems DSN existing of the PC (OBDC connections) with ASP
Hello. I need LIST with ASP CODE the systems DSN existing of the PC (OBDC connections), the conections and properties like goto into in win2k to: Star->Configuration->Control Panel->ODBC Connections For example show the text and ...
Hello. I need LIST with ASP CODE the systems DSN existing of the PC (OBDC connections), the conections and properties like goto into in win2k to: Star->Configuration->Control Panel->ODBC Connections For example show the text and ...
answer(2) view(532) status()
)
Login attempt being pointed to wrong database
I have created a new login, with username and password and given it datareader and datawriter permissions to a particular database. In my asp connection code I identify the database, username, password and go on to do selects and upda...
I have created a new login, with username and password and given it datareader and datawriter permissions to a particular database. In my asp connection code I identify the database, username, password and go on to do selects and upda...
answer(1) view(348) status()
)
Importing Data
When I import at table from a Microsoft Access Database to an SQL Server 2000 database the format of my data changes. The tables Im importing look like as follows: dbo_Classification Type Description 1 actively purchased full price 2 activ...
When I import at table from a Microsoft Access Database to an SQL Server 2000 database the format of my data changes. The tables Im importing look like as follows: dbo_Classification Type Description 1 actively purchased full price 2 activ...
answer(2) view(643) status()
)
SQL Server 2005 Reporting Services
Hey guys, I was wondering if anyone knew of any changes that will be made in the Yukon release of the SQL Server Reporting Services from the SQL Server 2000 Reporting Services. I understand that it was developed for Yukon, but released for...
Hey guys, I was wondering if anyone knew of any changes that will be made in the Yukon release of the SQL Server Reporting Services from the SQL Server 2000 Reporting Services. I understand that it was developed for Yukon, but released for...
answer(0) view(13) status()
)
Loop in TSQL
is there anything that would allow me (from inside a view or stored procedure) to run a stored procedure for each individual row in a select statement for example: if "select id from table" returns id -- 1 2 3 could i do some ...
is there anything that would allow me (from inside a view or stored procedure) to run a stored procedure for each individual row in a select statement for example: if "select id from table" returns id -- 1 2 3 could i do some ...
answer(1) view(407) status()
)
Changing objects
How can I change my objects from the name 'DSUSER.tblDOCUMENT' to 'tblDOCUMENT' all other DB's I've worked with has been in the second format. I don't know how it happened but this DSUSER. is in frount of all of my objects.
How can I change my objects from the name 'DSUSER.tblDOCUMENT' to 'tblDOCUMENT' all other DB's I've worked with has been in the second format. I don't know how it happened but this DSUSER. is in frount of all of my objects.
answer(2) view(103) status()
)
DTS: Output file, except when no records
Hi, I have a DTS package which exports the records in a view into a CSV file. However, when the view returns no records, the DTS package outputs a blank csv file. There must be a way of preventing this, i only want the file to be c...
Hi, I have a DTS package which exports the records in a view into a CSV file. However, when the view returns no records, the DTS package outputs a blank csv file. There must be a way of preventing this, i only want the file to be c...
answer(4) view(229) status()
)
Newbie needs help
I have set up SQL Server on a Windows 2003 Server, also running Sharepoint Team Services. However, I need to tell SQL server to do full text searching within file extensions other than the default. I really hope someone can tell me what...
I have set up SQL Server on a Windows 2003 Server, also running Sharepoint Team Services. However, I need to tell SQL server to do full text searching within file extensions other than the default. I really hope someone can tell me what...
answer(0) view(622) status()
)
How do I create an "input mask" in SQL server?
I tried the search engine but it only took me to the frontpage. So I had to create a new thread, I also searched through google but I only found input masks for Access. I only want to know how I create input masks in Microsoft SQL Server? ...
I tried the search engine but it only took me to the frontpage. So I had to create a new thread, I also searched through google but I only found input masks for Access. I only want to know how I create input masks in Microsoft SQL Server? ...
answer(1) view(596) status()
)
Query data by PART of an asp string value
Hi, I guess this issue is part SQL and part ASP - so hopefully I've posted it to the right forum (tell me if I haven't!). I'm setting up an ASP page where a column (randomKey) in a recordset (rsKeywords) drawn from a MSSQL 2000 table ne...
Hi, I guess this issue is part SQL and part ASP - so hopefully I've posted it to the right forum (tell me if I haven't!). I'm setting up an ASP page where a column (randomKey) in a recordset (rsKeywords) drawn from a MSSQL 2000 table ne...
answer(4) view(946) status()
)
query returning items that don't exist in another table
Hi I am really struggling. I want a query to return items from a main table that don't exist in another table. I have two tables. One is a navigation table and one is a table with html associating to the navigation. In an admin panel I want...
Hi I am really struggling. I want a query to return items from a main table that don't exist in another table. I have two tables. One is a navigation table and one is a table with html associating to the navigation. In an admin panel I want...
answer(2) view(701) status()
)
Aggregate Query
Hi I am stuck with a problem. consider this Name--NoOfHrs----Rate--SeqNo --X------10--------10----1 --X-------5--------12----2 --Y------10--------20----3 --Y------10--------10----4 I need to report it like this Name ToT...
Hi I am stuck with a problem. consider this Name--NoOfHrs----Rate--SeqNo --X------10--------10----1 --X-------5--------12----2 --Y------10--------20----3 --Y------10--------10----4 I need to report it like this Name ToT...
answer(0) view(442) status()
)
Temporary Tables
Does anyone know how to re-write this query so I can create a temporary table to insert information as oppose to inserting info into the Sclassnoprice table and deleting its contents each time. It is taking up to much space on the server b...
Does anyone know how to re-write this query so I can create a temporary table to insert information as oppose to inserting info into the Sclassnoprice table and deleting its contents each time. It is taking up to much space on the server b...
answer(5) view(570) status()
)
help with variable problem in IF statement?
hi, i'm completely stumped with this one. It is a simple test (via IF) for booking where it decides which path to follow. Or not so simple, even.. It keeps taking me to same bit. Have tried putting form value into variable. Tried rearrangin...
hi, i'm completely stumped with this one. It is a simple test (via IF) for booking where it decides which path to follow. Or not so simple, even.. It keeps taking me to same bit. Have tried putting form value into variable. Tried rearrangin...
answer(2) view(792) status()
)
Free tool to Backup/restore Databases via the web?
Hi i've tried a few remote administration tools including Microsofts own Web Data Administrator for SQL server... but none of them seem to do what is essential to me and that is backup/restore databases to a file. Could I perhaps do it u...
Hi i've tried a few remote administration tools including Microsofts own Web Data Administrator for SQL server... but none of them seem to do what is essential to me and that is backup/restore databases to a file. Could I perhaps do it u...
answer(5) view(801) status()
)
Copying Stored Procedures
I have and ASP.NET and VB.NET application that needs to copy selected stored procedures from one SQL Server to another SQL Server. The scenerio is that the user will select a source server from a drop down list then the source database from...
I have and ASP.NET and VB.NET application that needs to copy selected stored procedures from one SQL Server to another SQL Server. The scenerio is that the user will select a source server from a drop down list then the source database from...
answer(3) view(886) status()
)
MTS Server
Please can anyone suggest me few sites where i can get information about MTS Server.
Please can anyone suggest me few sites where i can get information about MTS Server.
answer(1) view(647) status()
)
SQL statement: finding highes, Distinct value
Hello, Im trying to create a query that selects the highest Unique value. I have come up with the following statement but it obviously selects all Unique numbers and displays them. Im looking to just display the highest. I tried adding Max(...
Hello, Im trying to create a query that selects the highest Unique value. I have come up with the following statement but it obviously selects all Unique numbers and displays them. Im looking to just display the highest. I tried adding Max(...
answer(2) view(998) status()
)
I only want the first 50 bytes of the filed :(
My database has chinese characters in. Eventually I need to only get the first 50 bytes of the data field, but somehow, I use len('==data==',50), it would catch 50 chinese characters which make 100 bytes ... can anyone help me? Thank you...
My database has chinese characters in. Eventually I need to only get the first 50 bytes of the data field, but somehow, I use len('==data==',50), it would catch 50 chinese characters which make 100 bytes ... can anyone help me? Thank you...
answer(1) view(639) status()
)
ID increments by one with current year in front of it.
I am trying to have a auto generated ID field updating by one count with each new record. That part I can do. However I need to put the current year in front of it. I would like to have it in this format. Year-00001 I.E. 2004-000...
I am trying to have a auto generated ID field updating by one count with each new record. That part I can do. However I need to put the current year in front of it. I would like to have it in this format. Year-00001 I.E. 2004-000...
answer(3) view(690) status()
)
MS SQL Convert function not working
I have just converted an Access database to a SQLServer one and now have the joy(!!) of changing all the SQL statements to make then compatible. In Access I had a Format function around a date, so now I am using a convert function which ta...
I have just converted an Access database to a SQLServer one and now have the joy(!!) of changing all the SQL statements to make then compatible. In Access I had a Format function around a date, so now I am using a convert function which ta...
answer(11) view(201) status()
)
please help with asp database connection 'login fails'
I've been trying to suss this for hours now with no luck at all. I'm trying to connect to a sql server database on a win2003 webserver running IIS6 (both IIS and sql server on same machine). I have set up the database and added a user 'CL...
I've been trying to suss this for hours now with no luck at all. I'm trying to connect to a sql server database on a win2003 webserver running IIS6 (both IIS and sql server on same machine). I have set up the database and added a user 'CL...
answer(5) view(218) status()
)
No log operation
Hi I have a database with full recovery model. Every night at 11.00pm performs full backup, and dayly every 3 hours performs differential backup, and trasnactional log backup performs every 15 minutes during a day. I am interested what...
Hi I have a database with full recovery model. Every night at 11.00pm performs full backup, and dayly every 3 hours performs differential backup, and trasnactional log backup performs every 15 minutes during a day. I am interested what...
answer(1) view(829) status()
)
Using the count function with TOP
Hi there, Can anyone help me out of my misery? This statement does not work and i don't know how to fix it: "Select top 50 SID, count(Criteria) as A from ScoreResults where Criteria = -1 and ScoreResults.ID in (Select ID from Pla...
Hi there, Can anyone help me out of my misery? This statement does not work and i don't know how to fix it: "Select top 50 SID, count(Criteria) as A from ScoreResults where Criteria = -1 and ScoreResults.ID in (Select ID from Pla...
answer(2) view(79) status()
)
Hosting server regional settings in US, I want them in FR-CH !
Hi, My hosting server has American regional settings (dates are mm/jj/yyyy hh:mm:ss XM) and, since I have swiss visitors, I would like to view my dates as jj.mm.yyyy hh:mm:ss I could make a function to display it in swiss format, but it w...
Hi, My hosting server has American regional settings (dates are mm/jj/yyyy hh:mm:ss XM) and, since I have swiss visitors, I would like to view my dates as jj.mm.yyyy hh:mm:ss I could make a function to display it in swiss format, but it w...
answer(4) view(709) status()
)
Data Type int and AutoNumber
In SQL Server I am creating a table for a database and I have two fields Type and Description. The Type field is an 'int' datatype and is the primary key. I am writing asp code to add a row to the database using the details from a textbox...
In SQL Server I am creating a table for a database and I have two fields Type and Description. The Type field is an 'int' datatype and is the primary key. I am writing asp code to add a row to the database using the details from a textbox...
answer(4) view(621) status()
)
Stored Procedures - Temporary Tables
At present I have been designing a lot of stored procedures which are inserting data into a number of tables. However by doing this i am taking up a lot of space on the server and have been told to design temporary tables instead. My stor...
At present I have been designing a lot of stored procedures which are inserting data into a number of tables. However by doing this i am taking up a lot of space on the server and have been told to design temporary tables instead. My stor...
answer(6) view(120) status()
)
Sql 2000 Reporting Services
Is it possible to dynamically change the column and page headings in SQL 2000 Server Reporting Services? For example, if I have a report that provides a summary of sales forr the first quarter of 2003 and 2004, can I use that same report f...
Is it possible to dynamically change the column and page headings in SQL 2000 Server Reporting Services? For example, if I have a report that provides a summary of sales forr the first quarter of 2003 and 2004, can I use that same report f...
answer(0) view(817) status()
)
Programming
Related Pages
- [SQL Server 2005] Force Encryption Login not working
- Data File Crashed!!! Could not redo log record
- DataGrid for data input from user in ASP.
- What is the image format
- An agent to connect Mysql to MsSql
- URGENT: Stored procedure
- If statements
- [SQL Server 2005] Log files
- Updating hindi data through java program
- Database design. Need 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