Only Title

Answer Questions

• biz-admin Error attempting to import from Excel

  Here is the error: TITLE: SQL Server Import and Export Wizard ------------------------------ An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. ------------------------------ ADDITIONAL INFORMATION: Exception has been thrown by the target of an invocation. (mscorlib) ------------------------------ The connection type "EXCEL" specified for connection manager "{55E5636D-F ...Show All

• Jan Dytrych Problems with adding database samples

  I have installed the documentation and samples and the management studio for sql 2005 express edition, but when trying to work through the samples, I get this error message, for some reason I can't include the Adventure works db. Whatn I'm I not doing right Please can someone help! 1> SELECT name from sys.databases 2> Go name -------------------------------------------------------------------------------- ------------------------ ...Show All

• Andrew Timberlake-Newell Subfolders

  I know you can create sub folders in report manager, and then move reports into them. Is this a good idea since report designer cannot deploy to sub folders, and then you are left with deleting and moving, which throws off your subscriptions. Am I missing something Thanks! You have several options: - report designer supports deployment in a specific folder - you can move reports around (not delete/recreate) which keeps sub ...Show All

• hotmailman customizable report model ?

  Hi friends we created report model for our clients to create reports using report builder which works fine. we have a situation now , as we've different clients for e.g.,individual doctors, hospitals etc., so we need to have smart report model which hides some entities/attributes if client is individual doctors or hospitals. what i mean some entities and attributes are unique to a particular type of client. so we want to hide some entities/attri ...Show All

• Avner SSMSE Install Issue

  Hello, Forgive me if this is a repeat question... I have installed SQL 2005 Express Edition onto a completely new Windows XP service pack 2 machine, and would like to install SQL Server Management Studio Express.  However, when I try to execute the downloaded file, it flashes a command window, and goes away - nothing running, no processes in task manager.  I tried right clicking on the executable and choosing 'Run as..'  When I do ...Show All

• rainvt connect to S400 using SSIS

  Dear all In my server had instaledd driver for ibm ole db connection "IBM DB2 UDB for Iseries IBMDASQL OLEDB Provider " and "IBM DB2 UDB for Iseries IBMDARLA OLEDB Provider " and "IBM DB2 UDB for Iseries IBMDA400 OLEDB Provider ". If i using dataflow and make connection with oledb and make query using query builder it's succesfully, but if i click column or OK or preview button display warning "cannot retrieve the column code page info from t ...Show All

• Prasad Kolte Remot_Backup

  How can i take a backup of remote sql server and that .bak file will save on my local system is there any T-sql code for it Connect and login to the remote SQL Server, and run: backup database myDb to disk = 'pathToMyLocalDisk\myDb.BAK' -- edit This assumes that the remote SQL Server is able to reach your local disk over the network, and also have permissions to write there, however. /Kenneth ...Show All

• jaycee Display of reports on browser with Custom Assembly

  Hi friends, We are using SQL Server Reportin Services 2005 (SSRS) for development of our reports instead of Crystal Reports. As per our clients requirement we want to make all reports dynamic eg. whatever background color user select should appear for that report etc etc. So for this we have written one function and created DLL for that. Now we are refering that DLL in all our reports as Assembly Name in Reports \ Report Properties \ Refer ...Show All

• DawnJ sql mobile database connection on a desktop application

  Hello, Was wondering if its possible with VS 2005 to create and populate a SQL Server Ce database on the desktop Reason why I'm asking is it takes a very long time (~40 minutes) to process xml and insert the values into the sdf database on the Pocket PC. I would assume it is much quicker to create the database and insert records on the desktop. Any suggestions would be appreciated. Thanks I have addressed this issue for SQL CE 2.0 b ...Show All

• Ricky Wen - Microsoft Output Columns in Script Shape -- Object Reference NOT Set

  Hi there, I'm getting an error in ascript transform shape. When I try to write a value to an output column I'm getting an error saying the object reference cannot be set. So my code looks like this - Row.OutputColumn = True Any ideas A couple things to check 1) Is "OutputColumn" already added to your Script's output column collection 2) Is it ReadWrite If you hav ...Show All

• Mike_maul Loading a column by name (via Variable, etc.)

  This is kind of a tricky behavior, but in my current SSIS package I have a situation I am unsure of how to fix. I have a column joined in my set of working rows that has a value which is the name of another column. For example, if I have the Columns ID, Name, City, State, and CopyFrom, the CopyFrom column will be any one of the values "Name", "City" or "State." What I want is to create a new Derived Column (call it in this case CopiedValue) th ...Show All

• dseydel Advanced Series Express vs Express

  Can someone tell me the difference between Express and Advanced Series Express --- are there different limitations Why would I use one over the other -- thanks! But still free right You're just creating these edition to minimze by footprint -- can you tell free means a lot to me :) Yes, the Advanced Edition has more capabilities. -- Robert Thanks -- I take it they ar ...Show All

• Donald D. Drake - MSFT turn off default filter

  Hi Friends i need ur advise on filters. am using sql server 2005 standard edi. in report builder whenver users add field from entity i want to add default filter. as our data has 2 types of records (active and inactive). so whenuser creates a report using report builder i want to display active records only by default. this part i managed to do it by adding "filter" attribute on the entity which works nicely. but if user wants to see ...Show All

• Jonathan Clark How to restor the table after deleting the rows?

  Hi there, I accidently deleted some rows from a table in SQL Server Enterprice manager. How can I restore these rows Thanks a lot. Yolande Usually you restore the last database backup and all the incremental log backups (if necessary).  But this only works provide you have been taking database/log backups. ...Show All

• Bill Rose SOLVED!

  (Cross post from newsgroup) Attempting to implement Windows authentication between trusted domains. . . I have a domain trust set up between two domains connected via persistent vpn: REMOTE and HQ sqlserv is: HQ\SQLSERV (SQL 2000 server) client machine is: REMOTE\MACHINE1 (SQL 2005 tools) I sucessfully added user REMOTE\User1 to system admins on HQ\SQLSERV I can login via Remote Desktop from REMOTE\MACHINE1 to HQ\SQLSERV and open SQL2000 Qu ...Show All