Answer Questions

• Umesh.Gandhi auditing no of connections made to the database

  Hi My application connects to 3 databases . I need to know how many connections are made by my application to each database There are two applications servers. Basically what i need is to know how many connection to each database from each application server. (that is how many connections from application server 1 to database 1,2 &3 and how many connections from applications server 2 to database 1 ,2 & 3) Can this be done .. How to do it Please help me in regard to this Thanks in advance. I would have a look at SQL Profiler, with this tool you will be able to run a trace on each of the databases and then count the connections to the database. Hi Tha ...Show All

• james_cline_ Comparing DateTime to UK Format

  sorry folks the other message was on the wrong board! Hello friends, I am trying to return all records between 2 dates. The Date columns are in DateTime format, and i am ignoring the timestamp. The user should be able to input UK Date Format (dd/mm/yyyy) and return the rows. This sql code works fine for American date format, but i get an error: converting from varchar to datetime when i put in a UK format. eg. 22/11/06. Please advise on this problem! many thanks! ALTER PROCEDURE SalaryBetweenDates ( @WeekStart datetime, @WeekEnd datetime ) AS BEGIN SET @WeekStart = (SELECT REPLACE(CONVERT(DATETIME,@WeekStart ,103),' ','-')) SET @WeekEnd = (SELECT REPLACE(CONVERT(DATETIME,@WeekEnd ,103),' ','-')) END BEGIN SELECT s.StaffNo,s.S ...Show All

• Harold-z80asmRules sqlserver 2000 isolation level & locks

  Hi , I am new to sqlserver family! 1) In SQLSERVER 2000 what is the default isolation level 2) DB: PUBS / Table: Employee Session1: Begin Tran Go Update employee set fname='thiru' where emp_id= 1 Session 2: Select emp_id,fname from employee <<< waiting.........>>> Session 3: select empi_id,fname from employee where emp_id = 2 1 record selected successfully Oracle returns the value for Session 2 query but SQLSERVER waits for the Session 1 transaction either to be comitted or rolledback. What happens exactly in sqlserver for session 2. thanks Thirumaran SQL Server 2000 doesn't have a row versioning support. Could you share your SQL script on how ...Show All

• polymorphicx Ug! Replicated tables missing Default Values and Identities.

  Ok, so I must have screwed something up. I have several databases set up for transactional replication to another instance of SQL Server 2005 for fail over purposes. Today, I restored one of those replicated databases to my development machine and discovered two surprising problems: 1) The Default Values settings in the replicated tables are missing. They are there in the publishing tables, just as they were before I set up replication. However, they are not in the subscribing tables. Now, this is not such a big issue, since I tend to send all default values in insert queries as necessary. 2) The second problem is a more of an issue, since I use auto-numbered Identity columns in my tables (yes, I know that's just plain lazy...). ...Show All

• kholling Query Help

  I have this scenario. What will be my query Table: Account#, Name, RMR, Billing_Date, Invoice# 1000, Dave, 50, 5/1/2006 ,10 1000, Dave, 50, 6/1/2006 ,11 1000, Dave, 50, 7/1/2006 ,12 1000, Dave, 50, 8/1/2006 ,13 1000, Dave, 50, 9/1/2006 ,14 2000, Al, 50, 5/15/2006 ,15 2000, Al, 50, 6/15/2006 ,16 2000, Al, 50, 7/15/2006 ,17 2000, Al, 50, 8/15/2006 ,18 3000, Jim, 50, 8/10/2006 ,19 3000, Jim, 50, 9/10/2006 ,20 3000, Jim, 50, 10/10/2006 ,21 I use this query to calculate revenue sharing. Account hit for revenue sharing after we bill the 4 th billing month. In this case for Account# 1000 qualified after 8/1/2006 , 2000 – 8/15/2006 and 300 ...Show All

• Chris Langsenkamp An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue

  Hi Guys, Can anyone help me with this error An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source ...Show All

• Greg Withers Transact sql 2005 Code changes

  Have there been any updates to sql 2005 transact codes, because I tried to use some transact code that I used in sql 8.0 and in sql 2005 on the same database and it did not work. Here is the code I used Select p.pub_name, e.fname + ' ' + e.lname "Employee name", e.job_lvl from publishers P inner join employee e on p.pub_id = e.pub_id where e.job_lvl > 200 my fault I made a mistake nevermind. ...Show All

• Adam Tappis - IMGroup XML to Database Save Data

  I have written the following Stored Procedure for Saving data from XML file to Database where the Database is SQL 2000 select Sp_CoCode, Sp_Year, Sp_DocType, Sp_DocNo, Sp_Prefix, Sp_PkNo, Sp_Location, Sp_AdNo, Sp_DocDate From Trn_SalePur order by Sp_pkno desc Update Trn_SalePur SET XmlCol =( SELECT * FROM OPENROWSET( BULK 'C:\Test25102006.Xml', SINGLE_BLOB ) AS x ) WHERE IntCol = 1 GO I am Gettting Error As while I am trying to execute the code: Server: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'BULK'. Where My XML File contains following details: <Trn_SalePur> <Trn_SalePur Sp_CoCode="C05" Sp_Year="Y004" Sp_DocType="PU" Sp_DocNo="1418" Sp_Pr ...Show All

• Serapth SSIS package execution error

  While executing the SSIS package from visial studio it is running. If we execute from Integration services - - -> stored packages - - - -> msdb - - - -package name, the package gets executed. But when scheduled through jobs it gives the following error in history "Execution as user. <user name > The command line parameters are invalid. the step failed" command line looks like this " /DTS "\MSDB\Maintenance Plans\Package1-HYUNDAI" /SERVER tvmwindev02 /CONNECTION "10.10.1.52.upsframis";"Data Source=10.10.1.52;Initial Catalog=upsframis;Provider=SQLOLEDB.1;Integrated Security=SSPI;Auto Translate=False;" /CONNECTION DestinationConnectionOLEDB;"Data Source=mscoe.db.ust ...Show All

• Jobr77 Deployed Application isn't connecting to SQL Server

  When deploying my application that uses sql server it doesn't connect to the server. I checked the connection string & it's ok the server instance is the same. The computer name isn't the same & i use the .\SQLExpress as the data source. I get an error saying 'sqlserver does not allow remote connections error 26 locating server / instance specified'. Since computer name is changed, can you try to recreate the data source again When creating a datasource, you can verify that if the datasource is ok to connect to the server. Another thing to look at is that if computer name is changed, the servername might not be valid. Can you run select @@servername to v ...Show All

• Cesar Francisco How many ways are provided by Microsoft to import data into SQL Mobile database?

  SQL Mobile database seems to not provide import/export utilities. I think using Publication/Subscription is one of the solution, is it right Also, besides typing insert statement manually, there are any other ways to transform data to the SQL Mobile database Or simply read it into a dataset and the write it with the XMLWriter. Here is some sample code for doing the INSERT that was written in a previous post (near end) http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=926140&SiteID=1 There are no formal Import or Export programs/utilities for SQLCe at this point and there is no bulk copy class in the SqlCe namespace. Yes, you can setup a SQLCe database as a subscriber in a Merge repl ...Show All

• LKeene Error: 18456, Severity: 14, State: 11.

  i am new to sql server 2005 express. I am trying to set up xp embedded database. I am trying to allow remote access to a central xp embedded database. i have the database on the sql server machine. i am using the component database manager toll on a remote machine so that i can connect to the remote xp embedded database. when i try to connect to the db through sql server i get the following error in the log file. 2006-09-12 17:15:10.18 Logon Error: 18456, Severity: 14, State: 11. 2006-09-12 17:15:10.18 Logon Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX] where HOSTNAME is the hostname of the pc that sql server 2005 is running. XX.XX.XX.XX is the ip address of the client which is running component da ...Show All

• Jon Limjap Failures in installing SP1 on top SQL Server 2005

  I am trying to apply SP1 on top of SQL Server 2005 and it keeps failing. I have a default instance and a named instance on the machine. The named instance disabled when I tried installing the pack. Then I enabled the named instance and tried the pack. This time the default instance failed as usual but the named instance was successful. The log is as follows ( when I attempted when the named instance 'TEST' was disabled ): ANy suggestions / insights Thanks. -chiraj 12/13/2006 12:23:18.661 ================================================================================ 12/13/2006 12:23:18.661 Hotfix package launched 12/13/2006 12:23:20.021 Product discovery successfully completed during the install process for MSSQLSERVER 12/13 ...Show All

• vijil Including SQL Server Express as a nested MSI install

  I'm working on an MSI-based install that installs a suite of applications. One of the applications requires SQL Server 2005 Express to be installed or already on the machine, but if the user doesn't want that app installed, I don't want to have to bother with the SQL Server issue; however, if that app is to be installed and SQL Server is not already installed, I want to be able to have it installed automatically during our install in order to make it easier for our end users. The obvious answer to this is to launch the SQL Server Express install as a nested MSI install at the appropriate point in our install. Since the SQL Server install is so complex, I was wondering if this would work if I were to launch the SQL Server install's setup.ex ...Show All

• rm2000 Regarding Installation of SQL Reporting Service

  Dear Friends,            This is narendran. I want to install the SQL Reporting Service. I am facing some problem. Here Microsoft SQL Server 2000 Enterprice edition installed one server. I am trying to installed the Reporting Service another one system. During the Installation I am facing the following errors. During the Installation: Installer ask some options... that are SQL Server Instance name:...........                 that in combo box First problem:- Combo box is empty, Here I am gave the database server system name assume "kersql" Name :................. text box.... what am i suppose to do here ...Show All