Answer Questions

• Mahesh kumara sql Server Connection Error

  we had 2 servers. Not able to conenct with 1 from 2 as well as 2 from 1. and we have 2 more servers 3 and 4. from 1 and 2 we are able to connectwith 3 and 4. we checked for tcp/ip enable are not in the configuration manager. And in the server properties remote conenctions allowed or not. How to solve this Error: cannot connect with the server.TimeOut expired. yes i am able to ping. both are in the mixed mode only. both are in the same domain. HI, 1. are you able to ping from server 1 to server 2 and vice versa 2. What is Authentication Mode of these servers!!! 3. Are both servers in same domain 4. Have you refer Microsoft KB , 914277 How to configure S ...Show All

• ImagineTech Mirroring ASPState

  Hello Does any one have any information on how to mirror the ASP.NET 2 ASPState database we have set the connection string to allow custom DB and failover partner but this is still not working. Regards Matt. Hi Kaloian, The problem that we are having is that the ASP.NET connection does not get re-routed to the failover partner after auto-failover. This is the connection string that i am using. <sessionState mode="SQLServer" sqlConnectionString="data source=Test; Failover Partner=Test2; initial catalog=Credit; user id=State;password=password" cookieless="AutoDetect" timeout="61" allowCustomSqlDatabase="true" /> The databs ...Show All

• Dharmbir Scheduling Info.

  Hi I am using RS 2000. Currently I am scheduling the job by manually giving the date, time. Is there any possibility to make it as data driven so that I can configure each user with different timings. Regards, Venkataraman M You can create multiple data driven subscriptions to run at different schedules for different users or user groups. You can filter users for which the subscription is run in data driven subscription query. ...Show All

• Jianchun Zhang No Debugging and logging when a single script task is executed

  Hi, I cannot execute a script task in the VBA code window. I cannot debug or log if I run a single script task from the right click Execute Task . Every time I have to run the entire package in order to be able to debug. What am I missing appreciate a help. Gulden try disabling all the other tasks and/or containers except the script task. then, execute the package. Gulden wrote: Thank You.. I guess it is the only way.. If memory serves correctly, yes, it IS the only way. We hope this will change in the future. It certainly SHOULD be changed! -Jamie Thank You.. I guess it is the only way.. ...Show All

• etcheverrjc Database mirroring

  Hi, Is there a way to automatically mirror/backup a SQL Express database with a SQL Server 2005 licenced system They will be on seperate machines on the internet. I have done manual backup and restores but would like to allow constant updates to allow both databases to be synchronized. I read that the SQL Server 2005 version has a mirroring facility but I also read that this is not possible in the Express version. What other (automated) options do I have Thanks Andrew Hi Andrew, SQL Express does not support Mirroring but it can serve as a Witness for other Mirrored servers. You can automate backup, or any other scriptable action, by generating a .sql script file and then using Windows Task Schedule to create ...Show All

• nhaas SQL Server Management Studio Express setup

  I'm trying to install the SSMSE vor SQLEXPRESS, but I get the message Setup has dedected a version of SQL Server Management Studio on this machine.... etc. I have removed the SQL 2000 Enterprise manager , but the message still pops up. Looking for a good soul now for helping me out Thanks Have you installed Management Studio of a lower version Would you check Control Panel --> Add/Remove program, Click "change" on SQL Server 2005 and see the report. Then you can make sure whether SQL Server Management Studio is still existing. Or you can check Start --> All Programs --> SQL Server 2005 to make sure whether the menu item still exists. ...Show All

• saAction Problem with SQLAgent Running SSIS Package "...package execution failed..."

  I am trying to run an SSIS package from the SQL Agent. I am able to execute the package manually from VS2005 and SQL Server. When I try to run the package from the agent, I get the error "The package execution failed.  The step failed." VS2005, SQL Server, and the SQL Server Agent are all installed on my local machine and running from the same account. I only have one step in the job and it doesn't include any scripts. Are there any permissions I need to set for the agent What am I missing -Stephen I added domain admin privilege to my account and still the same error. Oh the world of DTS was so much simpler... I'm having the same ...Show All

• stallion_alpa hi, Unable to get SQLCMD utility to work properly.

  I try to go to a command prompt to get this to run right with no luck. Is there something that I am not doing right It gives me the help library, but thats about it. Also, I have dealt with Oracle in the past. And was wondering is there a way to access the SQLCMD utility on a workstation with a login of some kind --David hi David, SqlCMD accepts a list of parameters as described in http://msdn2.microsoft.com/en-us/library/ms165702.aspx and at http://msdn2.microsoft.com/en-us/library/ms170207.aspx you can find a tutorial about it's use... usually you open a command prompt window and provide the appropriate connection parameters, like c:\Document and settings\user>sqlcmd -E -S.\SQLExpress this tries a trusted conne ...Show All

• cdolor sp_issues

  hi i have the following sp. i want to be able to create a view from the sp that will store the data that can be retrieved with the select statement my sp returns me. if the table exists, it should be dropped i suppose, because columns may vary. now i also want that enough info be stored to retrieve information again from the view, that i can map the records back to their original form how do i set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo] . [sp_DetailedBill_byPono] @payment_or_bill nvarchar ( 2 ), @pono nvarchar ( 25 ) AS BEGIN SET NOCOUNT ON ; DECLARE @fieldname varchar ( 10 ) DECLARE @stmt varchar ( 4000 ) DECLARE Fields CURSOR FOR SELECT A ...Show All

• Frederik Vanderhaegen Errors: SQL Reporting Services with CRM 3.0

  Good Day All ... I am currently trying to install CRM 3.0 onto one of our test servers. I have managed with no problem to get everything ready for installation ... but having a problem with reporting services. On the system requirements results page i have green for everything but reporting services. ERROR; Specified Reporting Services Reports Server http://XXXXXX/ReportsServer was not found. I have reporting services installed, can someone please give me some direction on where to go from here to get this up and working. Thanks Thanks for all of your help. Works fine. Thanks Again ... Great Advice!! Do you habe any Sharepoint Server installed on the machine or any other program which tries to bind port 80 to i ...Show All

• Eileen Ewen How to create Vertical Partioning

  Hi All, I setup a Transactional replication between SQL Server 2000 and SQL Server 2005 via wide area network . The intial snapshoot failed because run into problems on a table with column 379 columns. How do ceate Vertical Partioning a table on Publication Thank you. TJ_1 You can take a look at How to: Define and Modify a Column Filter (Replication Transact-SQL Programming) http://msdn2.microsoft.com/en-us/library/ms146925.aspx Gary Try again, it should be working now. Gary The link is not working!! ...Show All

• Michael B. Price Copy database with full-text index

  Hi, Can anyone please explain the proper precedure for copying a SQL Express database between two instances I am accessing the database without problems from a local web application. And I want to copy the database to a SQL Express instance on another server, running the same web application. I run into two problems every time I copy: 1) Orphaned users. I have to drop the database users and the re-map the server users to database users. 2) The full-text indexes are not available after copy, so I have to drop and re-create the indexes and the catalog. And I suspect there's an easier way.. Regards, Jens Erik Hi Jens, The behavior with users is expected. Users and Logins are indelibl ...Show All

• TELII Date query problem

  Why there’s a problem with the folloe select statement: SELECT * FROM table1 WHERE ISNULL(DATE_FIELD) DATE_FIELD is a datetime field of the table table1. There’s an error that this function need 2 arguments, but I find in th help that is only one of them. How can I do that hi, ISNULL(a, b) is a function to replace "a" with "b" in case of "a" being NULL.. it's equivalent to CASE WHEN col_A IS NULL THEN b END operation.. what you are looking for is the .... WHERE DATE_FIELD IS NULL .... comparison... http://msdn2.microsoft.com/en-us/library/ms191270.aspx regards ...Show All

• aragon127 ODBC Excel Driver

  dear all: I used ADO to connection excel file(excel2003); below is the source code: Dim Conn,Driver,DBPath,Rs, defaultPath defaultPath=Replace(xlsFile, "\VQAUser.xls", "") Set Conn = Server.CreateObject("ADODB.Connection") Driver="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & xlsFile & ";Extended Properties=""Excel 8.0; HDR=yes;"";" Driver="DBQ="&xlsFile&";DRIVER=Microsoft Excel Driver (*.xls);UID=admin;UserCommitSync=Yes;Threads=3;SafeTransactions=0;ReadOnly=0;PageTimeout=5;MaxScanRows=8;MaxBufferSize=2048;FIL=excel 8.0;DriverId=790" Driver="DRIVER=Microsoft Excel Driver (*.xls);DriverId=790;DefaultDir="&de ...Show All

• .NET Developer Creating Stored Procedures Based On Variables

  Hi There, I would like to know if for example i have some tables in my DataBase and i need from each table to get for instance, the Name by the ID, how can i make only one procedure which use parameters and variables so i can use this SP to get the Name By ID for all the Tables Thanks You would have to use dynamic SQL in the stored procedure. Assuming all you tables had a unique column named ID and an associated column named NAME, you could create a simple procedure like: Create Procedure GetNameByID( @tableName varchar(100), @ID int ) AS Begin Declare @sql nvarchar(1000) Set @sql = N'Select "NAME" From ' + @tableName + N' Where ID = ' + Convert( varchar(10), @ID ) ...Show All