we just re-did our server a few days ago, and ever since, i keep getting this error: Server: Msg11004, Level 16, State 1 [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context. To solve this problem, I have to re-boot my computer, however, I would a better solution cause it happens...more >>

For MS SQL Server 2000 and Delphi 5, I would like to access and change global variables within a DTS package. I can access the package and execute it, but I'm unclear on the syntax for actually changing the global variable. Any help would be much appreciated. ...more >>

We have several remote users connecting through Terminal Services getting following error: System Message 6024: Error opening data base with specified SqlServer: <ServerName>. Possibly the server's limit on workstation connections has been exceeded. In Enterprise Manager the maximum conne...more >>

hi all, I writes the following procedure which is update the specific table according to given parameters. But I have no idea why it is giving error like Server: Msg 2812, Level 16, State 62, Line 35 Could not find stored procedure 'Update Browser_tbl set Browser_Desc = 'New Browser' Whe...more >>

Good day.. There is one question... I do select* from "any_table_name" option(fast 50) This all I write in Enterprise Manager's SQl Query Analyser, but anyway EM me returns records only after it has loaded all records.. I don't fill things, that how I understood, must does 'option(fast...more >>

We have a need to connect Oracle 8.1.7 running on Solaris Unix to AS400 Data residing on a V5R1M0. I know we can use a gateway product, but can we also use ODBC running on the Solaris box? Has anyone done this? -- Posted via http://dbforums.com...more >>

Hello, I have an Access 2000 application wich uses SQL Server linked ODBC tables running on Windows 2000 Pro, with the SQL Server running on Widows 2000 Server.. It is a multi-user system with up to 5 users, connected to the server machine through a Samba network. The application has worke...more >>

I get the following error when connecting to Analysis Services Server as a client. My machine the client's Operating system is Win 2000 Professional. The server is intalled on a Win 200 Server. When I try to register the Analysis Server, I get the following error.. "Cannot connect to repos...more >>

I have a question on when and where we should create connections to SQL. I have a base class that handles all data access and dishes up connections etc as needed. I initially had a class level connection object that all general dataacess methods used to execute against. This introduced a proble...more >>

Is there a way to install the SQL client on a windows XP Pro workstation? Thanks...more >>

I got the following interview question which beats me: How to insert rows into a table without triggering the active insert trigger of this table? Does anybody know the answer? Thanks....more >>

hi, 1988@@57@@5185 I want to split upper value in three deferent column and want values like this col1 = 1988 col2 = 57 col3 = 5185 is there any why to split this value in desired fashion? Thanx Farhan Iqbal ...more >>

Hi all, When right-clicking on a table in Enterprise Manager 2000 and selecting Open Table...Return all rows I initially get a Results pane (which is normal) and when I press toolbar button for Show Diagram Pane all that I see in that pane is: * (All Columns) - just one option for that table....more >>

Ok, I finally figured out SQL somewhat. I cannot upsize all of my databases using the upsize wizard provided with Access 2000. I can upsize some database, but most importantly, not the one I need to upsize. Does anybody have any idea why some would upsize and some wouldn't? Could it be a p...more >>

Hello All Can any one help me out to create Jobs and Run Jobs on Sql- server Agent which is in the Management Folder. Thanks ...more >>

Hi All Is there any why to know filegroup name object wise. Mean which object is belong with which filegroup. Thanx in Advance Farhan Iqbal ...more >>

We have a C/S application, but our Client DB will not be connected with the server fulltime. In this case what kind of SQL server (LITE) we can use on our client machines to have synchronized the Data Bases with the serve master DataBase using a dial-up connection one hour per day or even ...more >>

Hello All I Need to get various Databases into ConsoleRoot\Microsoft SqlServers\SQLserver Group of SQL-Server Enterprise Manager.I could get this in Query Analyzer Thro Object Browser,But how to get in ConsoleRoot\Microsoft SqlServers\SQLserver. Please Do reply ASAP Thanks...more >>

I am having code that inserts a records in to a table by reading from a flat file. The Problem is that when first time it enters into the loop it Reads and Inserts the record correctly then it commits also but when it enters Second time it reads data but while inserting it generates erro...more >>

The BOL mention that a hash join creates a "hash table" to resolve the join. But what is a hash table ? it is just like a temporary table ? Additionaly, could you give any recommendation about links, books or articles that widely explain the different join algorithms ? Thanks in advance,...more >>

hi, I want to know that, at what time I was last restore my database. have any idea. Thanx Farhan Iqbal ...more >>

(Been reading other messages on this subject but could not find an answer, that is why I'm posting this. Please note, although I have posted to several groups, I've set follow-to microsoft.public.sqlserver.security in case I posted to where I shouldn't have, sorry if I have). Using + ASP.Net...more >>

If you are migrating the SQL Server software and associated application databases from one machine to another does Microsoft allow you to run SQL Server on both machines simultaneously for the period of time necessary to complete the data migration? I found verbage to this effect under th...more >>

I have a string field in a table and it's content is 1,2,3 when i order by this fiels the result is 1,10,11,12,2,3 how i can convert in order by the field to numeric and if i can't how i can resolv this problem....more >>

We have been using, as per business specs, SQL 7.0 & xp_sendmail to lotus notes client 5.0.8 for sql mail into notes. Upon upgrading to SQL 2000 this does not work as before. Have tried other options and am aware that the other options may work better, but for now must stick with business ...more >>

Hi Does any body know a sql statement that would retrieve the table names within a database. Kindly note that I just want to retrieve the list of the tables within a database... Thanks Jamie Waters.. ...more >>

Hi, I guess this is the right group to ask this question. I have a problem with response time inside SQL server enterprise manager. I have installed SQL Server 2000 Developer edition. I reinstalled it several times and nothing changed. For example clicking '+' to 'Databases' (to expand it an...more >>

Hi, I am posting to this group because I have a problem. There is a system that is build to provide a database access across the internet and uses C to deal with queries on the Microsoft SQL server. The problem is that the database does not work on windows 2000, whereas on every other windows ...more >>

My plan is to run SQL Server Enterprise on the same computer as my development environment (PowerBuilder). Since I am not connecting to the database from PB, it looks like I have not installed SQL Server correctly. I selected the option to install "client and server" and not "client tool...more >>

The type library has the following constant values: SQLDMOObj_UserDefinedDatatype = 1 SQLDMOObj_UserDefinedFunction = 4096 However on returning, for example, child dependencies for a table through a call to EnumDependencies, functions are being returned with a type of 1. However, if I ...more >>

I have linked a server called OSERV in enterprise manager. The following works fine in Query Analyzer Select * From OSERV..OSERV.EAME_PRODUCTS_COSTS As A Where A.PRODUCT_CODE = 20001 However this will not select * from openquery(OSERV, 'select * from EAME_PRODUCTS_COSTS') What is the ...more >>

Client is MS Access 2000. Server is SQL Server 2000. Is there any way of knowing which users are connected to SQL Server at any one time i.e. Machine name, User Name etc If this is not an existing feature of SQL Server 2000, can anyone provide the method/s that can be used to access this...more >>

Hi, After i loaded informatica power center on my machine. i am not able to open ms sql server\ Enterprise Manager, getting the following msg. --------------------------- Microsoft Management Console --------------------------- Snap-in failed to initialize. Name:Microsof...more >>

Ok, I just set up Microsoft SQL Server 2000 Standard Edition. I have it on a server running Windows 2000 Server. I then put it on one computer running Windows 2000 Pro. When I open an Access database and I try to run the upsize wizzard to convert the database into SQL I click tools -> d...more >>

Hi there, Just wondering is there anyway to secure a MSDE mdf file, so if it got stolen, no other MSDE will be able to attach and open databases in it. Can it be password protected? I tried to stop the MSDE on a desktop machine and copy a mdf file to another machine, and I was able to atta...more >>

Hi I have very little understanding of SQLserver issues. I have been trying to write a program that reads data from one SQLserver and shows the results on a webpage. To accomplish this task I have "compt1" which has the SQLserver 2000 on it and "compt2" were my IIS and webpage is located with...more >>

Hi,, I am curious to get some popular well-known clients name Besides MS access to get connected to to MS SQK servers for data modification, update, and etc, etc...... Thanks in advance.. Jaxy... ...more >>

Is there a way to call a Web Service from a stored procedure?...more >>

Hello there, I'm hoping someone can point me in the right direction. I am in the process of building a multi user database that will house contact information and needs to have strong search capabilities. I've built an Access front end and was going to link to an Access back end. I'm thi...more >>

Does anyone know how an application running on HP-UX can access a SQL Server database? I have an application running running on HP-UX that needs to access a SQL Server database over TCP/IP. Is there a dbnetlib or something similar for HP-UX?...more >>

I have 11 tables and fire query on them with joins as right and inner joins between them.The data is in lakhs (5 lakhs). The query gives connection time out even in enterprise manager. I tried different optimisation techniques as Index tuning wizard and all. What should I do to solve this connec...more >>

Hello there, I hoping someone can point me in the right direction. I am in the process of building a new database system that will be used by no more than five users in our company. It will house contact information and needs to have very robust search capability. My initial thought was t...more >>

We have some SQL 7 servers and some SQL 2000 servers. I have loaded the client utility for SQL 7 and SQL 2000 on my workstation. I have connected to one of the SQL 7 servers through Query Analyzer and was successful in doing a query. Are there any problems with only loading the SQL 2000 ...more >>

Hi, At One of our PC (Windows XP) we are using a VB Application and which is connected to the SQL Server Remotely through VPN Setup. The Application works fine for some forms and Fetches the records from the database but on some of the forms either on insertion or displaying the records ...more >>

I'm new to SQL server. I installed SQL server on windows 2003 server. And I installed the client on my windows Xp workstation. When I try to connect with the SQL server, it gives error message: LOgin failed for User(NUll) Reason: not associated with a trusted SQL server connection. ...more >>

Does anybody know when SQL Server came to a market? Thank you. Lilia Roumiantseva...more >>

Hi, If i install a 1 User licence on a SQL Server and write an application that connects as that user, do i require a license for each machine that uses the Database i have written. Note: it will probably be in MSAccess format. i.e. if each user uses the same login, can i connect thr...more >>

Hi, When i try to retrieve text data from the front end client i get some of the characters as junk. For example: my column contains the following data Actual data Everyone&#8217;s life is cool.... The result set i get on the client is Everyone<some special character>s life is cool.....more >>

I would like to backup/restore my database from my client application. What can I do ? Thanks in advance...more >>

Is it possible (or will it be possible) to extend stored procedures using .net languages (not C++)? ...more >>