Answer Questions

• N2O SSIS Training

  Does any one knows the best training avaliable for SSIS where a person can learn from scratch how to use SSIS for data warehouse brian, i ran into problems running some of the examples in your ssis book. would you mind answering a few questions at your convenience Thanks for info. I have a number of small videos available for free at http://www.jumpstarttv.com . S ...Show All

• Chris Haas connecting to sql server from mobile device

  How can I connect to sql server from a mobile device the server is on pc and my app is on the device. I want to perform commands and stored procedures which will be performed online on the pc and get immediate results. is there any way of achiving that hmmm it sounds as if something is missing on the device like a library. Try testing it on the emulator and see if you get the same error That usually m ...Show All

• none_1234567890 Object Explorer/Server Explorer Error

  I have just installed the released VS2005 as well as the released SQL2005.  When ever I try to browse my SQL Server with either the Object Explorer in MS SQL Server Management Studio or the Server Explorer in VS2005 I get the following error: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM componen ...Show All

• Jay Jones SQLPrepare and SQLExecute returns Permission Denied in SQL 2005

  I am trying to determine what has changed in SQL Server 2005. We have a application that has used this SQLPrepare and SQLExecute pairs for several years now and all of the sudden on 2005 it fails with a -1 error. Code Sample: odErr = (ODErr)SQLPrepare (hstmt, (PTR)gODCDA->sqlStr, SQL_NTS); if(!odErr){ odErr = (ODErr) SQLExecute(hstmt); } The Statement was "Select * from dbo.tbl1234 where 1=0" This is a standard way we use to get a ...Show All

• dondi81 No support for SQL Server Authentication and SSIS !!!!

  Hi I want to manage my servers from a central location and have the ability to manage my packges too.  Unfortunatley my servers are across domains which means I have to use SQL Server Login, which isn't a bad thing.  However for some bizzare reason I can't connect to Integration Services using this method, only windows authentication which is a complete pain in the butt from a management stand point as I have to copy packages to var ...Show All

• BryanHood assigning datasetname dynamically to a report ?

  Hi friends am new to reports in VS2005. how can i assign a datasource dynamically to a report. i know how to do add datasource in desgin mode to a report.(i.e i create a new datasource and drag and drop it on to report). but in my case i need to take some parameters from users and create a dataset with relavant data and show it in a report. i cant find any documentation or samples for it. Thanks for your help. BTW its winform application and i w ...Show All

• glorfindel_i510 Encryption of Data in SQL05

  My current experience is with access and sql2000. In my current application, I compress/encrypt my data prior to storing in my database. Does the new verion of sql support compression/encryption and if so can you please point me to any links which discuss. thanks, Fred Herring I have read that encryption is available for SQL 05. I have also attempted encryption on a column. What are some good examples and practices when usi ...Show All

• Amit Basu Visual studio interface EXTREMELY slow

  Hi folks, I'm working within VS2005/Business Intel studio environment. I've got one master package, which loads about 18 sub-packages as tasks. After openin the master package (and waiting 5-10 minutes for the packages to open and validate), maneuvering within the IDE is nearly impossible, it is so slow. Context menus can take 30 seconds to open. Certian operations, like closing a window, seem to hang the environment. Does anyo ...Show All

• Monique2005 Toggling Visibility on a Snapshot not working

  I have a clean SQL 2005 install, with SP1 installed. It is connecting to a TeraData warehouse. I have create a few reports that Toggle the Visibility and they have seemed to work just fine. Until I render them from a snapshot (the problem doesn't exist with a cached copy). Once I render from a snapshot the ability to toggle the hidden rows goes away. It looks as if it is going to show the rows then returns to it collapsed state. The Report ...Show All

• GOEran print report on win 2000 machine

  I have created a series of reports using reporting services every hing works fine ie they are accesable via the web or via vs.net 2005 windows app however when accessed via a machine running win2K sp4 the report fails to print, initialy i'm asked to install sqlServer then error 'An error occurred trying to get current window' any ideas any ideas where i can get the QFE ...Show All

• Efren Molina How do I find IDENTITY columns on Table using T-SQL

  Is there a query I can write against an INFORMATION_SCHEMA or against the system tables to determine if a column is an identity column Found it, a little obscure: SELECT obj.[name], col.[name], col.[colstat], col.* FROM [syscolumns] col JOIN [sysobjects] obj ON obj.[id] = col.[id] WHERE obj.type = 'U' AND col.[status] = 0x80 ORDER BY obj.[name] Does anyone know a way of doing this using an INFORMATIO_SC ...Show All

• Moutso login windows authentication problem

  Hi, I have a problem with sql server 2005 express, when i try to connect to an sql database it says login: is not a trusted connection to an sql database. I have gone into reg edit and changed the authentication setting from windows oly mode 1 to mixed mode 2. It still has the same problem, does anyone have any idea what the problem may be kind regards Chris J Did you restart the service HTH, Jens Su ...Show All

• webdeveloper_smriti Login failed for user ''. Reason: Not associated with a trusted SQL Server connection

  Hello, here we have 2 developers, one developer has sql 2005 in his machine, the connection string has Integrated Security=SSPI, that developer can connect to the application, the other user gets that error when he tries to execute the application froms its own IIS. The sql server has windows authentication, I want that the application uses one account, I tried to create one account, and give db_owner to it on the database, then I changed the ...Show All

• MasterCM extracting the specified record no of records from database table

  hi all, I need to select the no of records on the basis of specified range of records. In oracle i found rownum, i could not find it in sqlserver. how the data are extracted from the huge records.. I have used temporary table,map the table primary key to the next table with identity but i dont find it good. I need to ignore the insert the data in next table or craeting new table having the rowid ... Is there some other best wa ...Show All

• Edgar Stiles Migrating form access to SQL

  I am facing problems in migrating my application from Access to SQL. Few of the fuctions like CBDATE (userdefined functions) are not working. Please let me know how to overcome this problem. Thanks Ah yes, you are most probably correct. In that case, I presume he will have to write an analagous function in SQL to correct that, with the same name and return type Hi Manas. I am unaware of a fun ...Show All