Hello. I have to run many sql scripts each day. Sometimes I'll have 100+ scripts to run. The scripts always come in a folder numbered in the order they need to be run (001 - ScriptA, 002 - ScriptB, etc.). I've been running them all manaully one by one so that I can look for errors in the re...more >>

I am getting this error in the Event Viewer and the clients are unable to connect to the SQL server. What is wrong? PLEASE HELP!! Scott...more >>

I try to use SQL satatment to query data from SQL Server but I don't know why I need to increase 2 into the "intDay". If there no 2 increse the day will display is 3 not 5. Who can tell me what problems have. Thanks! ================================================= Public Function SetSQLString(...more >>

Hello everybody, one of our users gets an error message when trying to connect to our SQL Server database: Connection failed: SQLState: '28000' SQL Server Error 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL S...more >>

Hello there, I have a VB6 application that runs over a SQL Server 2000 Database. Sometimes (most recently) i get the folowing error: Run-time error -2147467259 (80004005) Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447 Expression: m_SizeRec > 0 && m_SizeRec ...more >>

Is there a way to connect SQL Query or Enterprise Mgr through a SSH tunnel. A remote user wants to do querys on a SQL2000 Server that resides at a remote Data Center. We don't want to do a full VPN, as the VPN server that is installed would open the user to the entire LAN. Thanks ...more >>

Hello, I am desperatly trying to export a table from my sql server. Using bcp I only have my csv file with . as decimal for all numbers (I also tried the export wizard of the sql console). Is there a way to obtain these figures with a comma , as decimal? The ddl of the table is below and numb...more >>

I am attempting to connect SQL to a SQL page. I get the following error: Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'SQLSERVER2\IUSR_SQLSERVER2'. /felice/index1.asp, line 18 The connect string works fine on my desktop as *.udl file. Any ideas? ...more >>

Is it generally true that local named pipes are better than TCP/IP? Are there any drawbacks? Regards, Per. ...more >>

I have Sybase 12.5.2 Database running in another domain. I am currently working in a different domain under SQL 2000. I need to call a stored procedure in Sybase by passing some input parameters and expect some outptu parameters. How to call a stored procedure in Sybase 12.5.2 from SQL 200...more >>

If you have one domain of application servers running win2000 and seperate user domains with no trust relationships accessing sql databases on the application domain what needs to be done rights wise and is this possible without connectivity issues. Currently these servers are standalone not ...more >>

Hello, I need to retrieve a value from linked server (oracle) and store it into a local variable of a stored procedure . The only solution that I have found is to use a tempTable (the query is parametrized so I need to create a string variable with the full query): ---------------------...more >>

Hi all. I join those who have installed sp2 and have lost the ability to communicate with sql server over port 1433. I have read all of the posts at this forum and have tried all of the fixes recommended. Microsoft's publication (841521) about running firewall.cpl and allowing sql server to ...more >>

Hi, I am getting Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. [SQLSTATE 28000] when try to run a RPC call from one sql server 2000 to an other sql 2000. I have setup/configure the remote server connection on both servers and they have the same sa ...more >>

Hi all! I have a SQL Server from which I need to query a view in a Oracle database. I have created a linked server connection to the Oracle machine. Oracle, version 9i, is running on Unix. Now when I try to use the linked server connection I have some problems. When I expand the linked server...more >>

Greetings ! We're surprise to see no reply to our original question about Object/Relational mappers. So no one as such architecture? We need this for our software since we made such a layer years ago but it doesn't perform as we expected. We're then looking for a commer...more >>

Is there a system table within SQL Server that will display information about the current connections made to the db? IE, username, IP they are connecting from, application they are connecting with, etc? Thanks in advance, - D *****************************************************************...more >>

Randomly, when trying to authenticate to a SQL server, whether via a mmc connection, or via a SQL Query Analyzer, several DBAs / analysts get the following error: "Unable to connect to server <servername>: Server: Msg 11, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]Genera...more >>

My SQL*Server 7 server was working fine this morning... All of a sudden anyone that is set up using DHCP to get IP Settings can't connect to any databases... If I change them to a static IP Address it works fine... Can't remember the exact message but it was something along the lines of ...more >>

Greetings; We're looking at O/R mapping technologies for being used between our C++ application and SQL Server. We're developping on VC6. We're currently looking at what the following product may offer: "Versant Open Access" Any suggestions ? Other ORM ? Thanks ! ___________________...more >>

Hi, (Sorry for the over-zealous cross posting - not sure which one to post to.) I need to get SQL server to receive certain mail and process it directly. If I go to SQL Mail in EM, properties it asks for a profile name to test, but there's none their. The server is question has a mail prof...more >>

Hi there, I have to transfer an existing SQL-Server with all his databases and users, to an new Server with Windows 2003. The new mashine has get the same computername and ip-adress as the previous mashine, so that the client pc's, wich access to the server with ODBC, after the switching, c...more >>