Answer Questions

• ajay_verma Generating a cached copy of the report

  Is there a way to programatically determine if a report should be generated from the cache or run against real-time data I have a situation wherein I would need to programmatically figure out if the datasource needs to be a cached version or real-time data based on certain options that a user defines (not report parameters)... any help would be very appreciated. Not before running the report, but afterwards you can look at the ExecutionDa ...Show All

• José Eloy Problems with remote SQL 2005 server and excel as an input source

  Hello, I am trying to write my first couple Integration Services packages using SQL 2005.  My configuration is a workstation running windows xp professional, and a windows 2003 server that is running the SQL server. Anytime I run a package that accesses the remote server from my workstation, the job fails with an error code.  The workstation cannot seem to run a package to load data to the remote sql server.  Why is thi ...Show All

• Tenly Problems with SQL express

  Hi all, hope someone can help I am trying to do the follwing: take a backup of the reporting services on my sql server 2005 and moving it to an sql express edition. All is good and the only problem is when trying to restore the keys. i am using the command rskeymgmt /a /f c:\\key.snk /p **** When i trried this on the sql develpoer edition all was good ( the source server) but on the destinatio server which is a sql express editi ...Show All

• shainer0531 environment variables

  Well, having only one disk partition, and only one directory, and running only one application probably ROCKS too, at least for that one application :) But if you're unfortunate enough to be required to use multiple applications, you might be saddened by certain aspects of environment variables, such as them living in one globally competitive namespace, or them being not covered by the NT security model (AFAIK). But I grant you, that they solv ...Show All

• guoguowenzi system error 126

  I'm getting this error when trying to run Query Analyzer Server Msg 160 , Level 16 , State 1 . Specified driver could not be loaded due to system error 126 (SQL Server) This is a new SQL Server 2000 install on a PC that has had different versions of SQL Server installed previously, including 2005. I'm assuming this has to do with an incomplete uninstall. Is there a fix or workaround for this I a complete novicebut am also recieve ...Show All

• Steve10 How to transfer data from a SqlServer database to a SqlServer Express database

  Is there a way to transfer data from a SqlServer db to a SqlServer Express db. I tried to use the backup file of SqlServer, but this file is not valid for SqlServer Express. Or there any alternatives thanks, Henk Paul, Thanks for your respons. The message I get is the following: <begin> TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Restore failed for Server 'cp431306-a\SQ ...Show All

• Ted. How do I use SQL Server 2005 Express for a backend to a web site forums

  I have installed SQL Server 2005 Express Advanced Edition. I wan to use it as a database backend for a Web Site I am building which will use the Snitz Forums ASP web. How do I se this up to work with the Snitz product Yes I am new to databases and have never set up one for use in a web application or site before. I am grateful for any assistance or tutorials which can be given to help me accomplish this task. It will all depend on ho ...Show All

• Arnar Vilhjalmsson SP_help_revlogin

  Dear Folks, I am in the process of migrating side-by-side from 7 to 2005 and I am wondering if the same sp_help_revlogin will work from 7 to 2005. I want to keep the same pwd, sid etc or do I need to use SSIS (Integration Services). Thanks Hmm... I can't find any information on sp_help_revlogin (or sp_helprevlogin) in either 7.0 printed documentation or 2005 online. Is that really a Microsoft stored ...Show All

• Torsten Pietrek Question about Jump to URL function

  Hi ! When using the Jump to URL function, is it possible to open the URL in a new page instance of doing a redirect Thanks ! I've found how to do it. I didn't know we could use javacript in report but it seems that it work so i added a window.open and now it's working fine. How exactly can I add that to my report It is exactly the function I need - I tried adding it to t ...Show All

• VanDamMan Whether probably to receive metadata about a status of cubes, by means of SQL inquiry to SQL Server

  Someboy help me to receive the status of cubes's metadata info via SQL Query. I've been analyzing this problem for two weeks and found several solution for example ActiveX (ADOMD.Catalog) or other programing solution, bat I want faund SQL solution this problem. Information Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service ...Show All

• RickLa Doing a SELECT on a different field than the field in the GROUP BY

  I'm using SQL Server 2005. I've got table tblSaleAddresses which looks something like this: AddressID   SaleID   Address1                  Address2                .....    DateEffective ------------   -------   -------------------       ---------------------             --------------- 1 ...Show All

• kgdavis SqlCommand Return and Output Parameters Not Working, but Input does?

  The foolowing code I cannot seem to get working right. There is an open connection c0 and a SqlCommand k0 persisting in class.The data in r0 is correct and gets the input arguments at r0=k0->ExecuteReader(), but nothing I do seems to get the output values. What am I missing about this System::Boolean rs::sp(System::String ^ ssp){ System::String ^ k0s0; bool bOK; System::Data::SqlClient::SqlParameter ^ parami0; System::Data::S ...Show All

• lololon SQL Server Integration Services Clustering

  Hi All, Does SQL Server Integration Services support clustering. Thanks & Regards Yes. Go here: http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx -Jamie ...Show All

• Arkman5 Solution Explorer and SQL Server

  I am a Visual Studio .net developer and understand Solutions and Projects in VS.net.  Nevertheless, it appears that the paradigm of using Solutions Explorer in SQL Server is not exactly the same.  That is, in Visual Studio you can't get anything done without creating a solution first.  In SQL Server, it is entirely possible to get a lot done without a solution and the ability to create and make use of a solution seems almost an af ...Show All

• Noreykav SQL Server Express Edition (DTS wizard)

  Hi I have a quick question. where I can find DTS wizard in SQL Server Express (Evaluation version). Actually I want to transfer data from Excel sheet to database. Please let me know. Thanking You Anshu The DTS Wizard is not included in Express ...Show All