Answer Questions

• Renata Yasa Putra how to modify this sql code

  Hi, I want to transfer some data from the table in Excel to a table in Access. I need to execute a command which involve a sql code. But it seems this sql code is not correct. con.Execute( "Select * INTO ImportSales From [Sheet1$] IN 'C:\Documents and Settings\yzhang\My Documents\intern\Sales Analysis Report\Input.xls' " ) ImportSales is a table in my Access database which i have already created the connection. the error me ...Show All

• Coniah inserting date through "insert" query-urgently

  when i add a date(Like 15/8/2005) through insert query it adds date as "1/1/1900" which make troubles for me. so please tell me that solution i am executing this query from "Query Analyzer" of SQL Server 2000   Creative wrote: i have a "Employee" table of my database when i run this query from vb or query analyzer, it runs successfuly but the date which i want to inset will not be as same as i defined. it writes as 1/1/190 ...Show All

• govdba The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

  In custom forms authentication for ReportServer, I hvae the following entry <authentication mode="Forms"> <forms loginUrl=" https://<externalwebsite>.com " name="<customname>" timeout="60" path="/"> </forms> </authentication> <authorization> <deny users=" "/> </authorization> <identity impersonate="false"/> ...Show All

• Philippe Leybaert SQL Server 2005 data export wizard did not transfer stored procedures

  OK, I got the data transferred, but now  SQL Server 2005 data export wizard did not transfer stored procedures. .. I am transferring from SQl Server Express 2005. Just trying to get the starter kit working, it used to be easier... Please help Well, I miss the old "Export" option too. One way to fix the "hundreads of databases" is when you click on the Connect tab/database engine in SQL Server Manager, click on options and select ...Show All

• WorkTimer Kill an user process with script

  Hi all, I am writing a script to kill any process connect to the user database before daily restore job in DR machine.  For testing, the script is getting the spid from sysprocesses and sysdatabases and store the specific spid which accessing the user DB into cursor and sp_who spid.  HOwever, if I change the sp_who to kill, it shows error.  Anything wrong in such script   Thanks in advance Thanks! This works jus ...Show All

• John Michael Miller Creation of credentials and certificates to protect a DB

  Hi, i want to know if its posible to create credentials or certificates in order to protect a SQL 2005 data base. Because if someone Buckups one of my DBs from my server, and try to restore it in orther server i dont want they to see my DB information because he dont have the correct credentials or certificates for it. This is posible . if is, How i do it Best Regards. Unfortunately, that particular feature doesn't currently ...Show All

• Rene Landgrebe YTD calcs using BI Time Intelligence very slow

  Using the BI Time Intelligence Wizard I have built some Year to Date calculations but they make the response time very slow. If the query is just for the default Current Period member the response time is fine, but including the calculated YTD member will slow it down so as to be unacceptable - far more than 12 times as slowly. What is interesting is if you choose all the individual months of the year, then the YTD figure will be returne ...Show All

• msdnmember SQL Server cannot start

  Hi there, Here's what I get in my error log: 2006-03-13 00:33:11.93 Server TDSSNIClient initialization failed with error 0xd, status code 0x4. 2006-03-13 00:33:11.93 Server Error: 17182, Severity: 16, State: 1. 2006-03-13 00:33:11.93 Server TDSSNIClient initialization failed with error 0xd, status code 0x1. 2006-03-13 00:33:11.93 Server Error: 17826, Severity: 18, State: 3. 2006-03-13 00:33:11.93 Server Could not start the network libr ...Show All

• Dmitry G. ForEach Config validation errors

  I have a Config file for a Data Flow that is utilizing a Configuration file. I have specified in the Configuration file to capture the Directory and FileSpec for the ForEach Enumeration. When I open the package, I get the following error: Warning 1 Warning loading ISOTypeLoss.dtsx: The package path referenced an object that cannot be found: "\Package\Foreach TC03 File.ForEachEnumerator.Properties[Directory]". This occurs when an attem ...Show All

• Chango V. - MSFT Capturing Processing Status and Progress Messages

  When you use BI Dev Studio or SS Management Studio to process an Analysis Services database or object, there's a nice dialog box that shows very robust status and progress information. Is there any way to capture this information if you are processing something programmatically   Specifically interested in both the ability to capture and display this information to a user when processing via a custom application.  Also interested in wh ...Show All

• rocky_don Complicated Query with Subs for Grand Total

  I'm trying to get the syntax right below.  Know that what I'm trying to do is correct (I don't want to explain why or the entire thing but just need help with correcting the syntax issues on the join and stuff: Errors: Msg 156, Level 15, State 1, Procedure IT_Get_ProjFee_GT, Line 205 Incorrect syntax near the keyword 'INNER'. Msg 156, Level 15, State 1, Procedure IT_Get_ProjFee_GT, Line 213 Incorrect syntax near the keywo ...Show All

• arongpan SQL Server Reporting Services - data extension 'XML'

  The reports based on XML is perfectly displayed in development Environment. But than uploaded to Server, the following occurs: An error has occurred during report processing. An attempt has been made to use a data extension 'XML' that is not registered for this report server. Help needed, thank you. Yes, SQL Express Advanced Edition is restricted to relational data sources. Chec ...Show All

• James Risinger DTS Migration

  I try to migrate DTS package to SSIS. Within one DTS package AAA, it calls another DTS package BBB with inner variable. I successfully migrate the BBB DTS package. For my AAA package, I replace the DTS_Execute_Task_2000 with Execute Package task. But how do we pass the inner variable parameter There is a Execute DTS2000 Package Task that allows you to do this. -Jamie Is there a way not to use DTS2000 Packa ...Show All

• akula hari New Service Broker blog

  Remus Rusanu has started his own blog titled "Service Broker Conversations." You can access it here . His first example shows how to build a pub-sub service using Service Broker in SQL Server 2005. ...Show All

• Sudipto Schemas, Users, Logins, Database Roles, Application Roles

  Hello, I am new user of SQL Server. I have some problems with these words. I want to make my database works in my specified permissions. I will specify permissions with schemas and these schema wants an owner. I want this owner should be my user. When creating a user it needs a valid login. I am selecting my login and it occurs and error says this login has an different user. I am specifying permissions with roles. But i can't make associa ...Show All