Answer Questions

• Mike Greenway how to find invalid objects --After DDL changes

  Hi I have a SQL Server 2005 database running. When I run some ddl changes, I want to find all the procs/objects that get invalidated because of object not found error..... Is there any way that I can look up in sysdepends or other tables to find information about this. Regards Imtiaz You can query the system view sys.syscomments for any procedures or functions that reference the objects. The text of each is stored in sys.syscomments.text. ...Show All

• punchycool Getting messages sent while JDBC Driver calls stored procedure

  Hi. How can I get the messages sent by the server while I'm executing a stored procedure via the JDBC driver I need to get my own debug messages (done through the print() function) and also standard server messages (such as "x row(s) affected" or results from SET STATISTICS TIME ON ). Is this possible Many thanks. Carlos Hi Carlos, These messages come back as warnings. You need to call Statement.getWarnings to retrieve them. See http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#getWarnings () for usage. Hope this helps. --David Olix JDBC Development Hi David. That didn't work for me. I am using SQL Server 2005 ...Show All

• Avi_harush SSIS Import/Export flat file

  Firstly, I hope this question isn't asked too frequently but I found no existing reference to this situation.... I had a bunch of stored procedures in SQL 2k which imported and exported data to and from flat files using TEXTPTR, READTEXT, UPDATETEXT etc... The flat files were continuously changing so the filepath was a parameter for the sp. The reason I used the pointer to flat files is because I didn't want to load the files in memory before commiting them ie. with TEXTPTR and UPDATETEXT I can import a 1Gb binary file 80000 bytes at a time and keep (precious) memory usage down. I was accessing this procs from a C# application. Since these methods are going to be phased out by the guys at MS what is the best way of importing/exportin ...Show All

• ksharma_deepak RDA with Identity column.

  Hi Everyone: I am new to Mobile programming. I am now working on a mobile project. I encounter an issue when I sync the data: cause I can't modify the schema, so I have to use RDA instead of Merge replication on sql server 2005. However, There is an identiy column on each table I will pull them down to local mobile database. And I will use those identity columns to connect tables. Even worse, the photo's new name will combine the photoID which is an identity column. There would an issue, if i sync data, the photoID would be same on different local mobile databases. And there would be generate same identity value when users sync data. How can I avoid those issues If you have any good ideas, please help me out so that I can meet ...Show All

• ntsoo Real World: Backup Strategy and implementation, how?

  Real World: Backup Strategy and implementation, how A quote: “Real World: Whether you back up to tape or disk drive, you should use the tape rotation technique. Create multiple sets, and then write to these sets on a rotating basis. With a disk drive, for example, you could create these back files on different network drives and use them as follows: //servername/data1drive/backups/AWorks_Set1.bak. Used in week 1, 3, 5 and so on for full and differential backups. //servername/data2drive/backups/AWorks_Set2.bak. Used in week 2, 4, 6 and so on for full and differential backups. //servername/data3drive/backups/AWorks_Set3.bak. Used in the first week of the month for full and differential backups. //ser ...Show All

• Hooper Trying to use the results of a case statement in my select list in my WHERE clause?

  I am fairly new with SQL and still learning. I have used a case statemtent for a column in my select list and want to use the results of that statement's field in my WHERE clause but it is not working for me. Here is the code I have so far: SELECT l.loanid, p.investorid, l.duedate, case when pc.duedate >= l.duedate then pc.duedate end as RateDueDate , pc.interestrate FROM loan l inner join participation p on p.loanid = l.loanid inner join paymentchange pc on pc.loanid = l.loanid where p.investorid = '12345' and RateDueDate is not null order by l.loanid, pc.duedate I want to put the results of this case statment in my where clause like highlighted above but it is not working because RateDueDate is not an actual column in the table. ...Show All

• moontube DTS- Destination Column Name has spaces causing error

  I am using Advantage ODBC 6.2 to connect to a Advantage Data Server to push data from a SQL table into this server.  I can view the data from the ADS with DTS and I can insert data by using "Insert into TempTable ("Last Name","First Name") values ('test','test)" from a Execute SQL Statement. The issue is when I build up a DTS package to pull from SQL into the Advantage ODBC, I get a "missing closing ")"" error.  I have narrowed it down to the column names in the destination table having spaces (Last Name, First Name, and a bunch of others.  DBA 101 here).  How do I beat this I have tried editing the destination column names in disconnected edit by adding the double quotes but get a "Column Name '"Last ...Show All

• AJB123 SQL CE Trouble in Visual Basic 6

  I use SQL Server 2005 Compact Edition RC1 with Visual Basic 6.0. connection provider that i use is Microsoft.SQLSERVER.MOBILE.OLEDB.3.0. for database management i use SQL Server Management Studio. some query can't execute in visual basic but in sql management studio, that query can run very well. for example: 1. select KodeSatker, KodeSatker + ' - ' + Nama as Nama from TMSatker where len(kodesatker)=3 order by KodeSatker 2. Select a.kdprog, a.nama, b.kodesatker + ' - ' + b.nama as SKPD, a.nonurusan from TMProgram a left join TMSatker b on substring(a.kdprog, 1, len(a.kdprog) - 2) = b.kodesatker 2 query above can run in sql management studio, but in visual basic 6.0, that query have an error. error msg:run time error '2147217887 (80040e21)' ...Show All

• Participant Database Performance Halts

  Hi, I have been running a reporting App on an SQL 2000 server, which reads from one large table (roughly 80 million records which grows at around 2 million records a week). However, it would seem that when multi-users try to access the App and the one large table is Read from using 1 database user name up to approximately 25 times, the system would slow to a halt. Essentially, each request on the App would be a new connection to the SQL database using the same database user name. Recently, we have been running into performance issues since we have increased the number of users for the App. What would be causing this slow down and what could solve this problem >>Do you have indexes on the t ...Show All

• Spence-FHS Error when file is saved to PDF

  I am calling a procedure that will save a file to PDF. It runs successfully. When I go to look at the PDF, I get a message, "Acrobat reader could not open 'Doc.pdf' because it is either not a support file or because the file has been damaged." This is how I'm calling the procedure: SaveFile(Dts.Variables( "varSSRS_URL" ).Value.ToString() + " /TestReports/MyReport&rs:Command=Render&rs:Format=PDF" , "C:\" + "MyReport.pdf" ) I'm with Rafael. I cannot find a SaveFile function when searching in an SSIS script component. Ok...thanks ifaber wrote: I had issues with the variables because I ha ...Show All

• PMA Reporting Services Failed Install

  Hi all, I have an SBS server that I tried to installed SQL Server 2005 Express edition for some testing/dev work (non-production server here) and although SQL installed, the reporting services component failed with the following. -------------------------------------------------------------------------------- Machine : RAND Product : Reporting Services Error : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation. -------------------------------------------------------------------------------- Machine : RAND Product : Microsoft SQL Server 2005 Reporting Services Product Version : 9.1.2047.00 Install : Fail ...Show All

• robear Sub Query Whoes

  The stored procedure gives me what I want, which is a ranking with points for each store in the company based on certain fields, <u>but I also want to compare this week's vs. the same week last year transactions</u>. I thought I could just do another select command, but it's not working. The same I did use, worked fine on it's own - but when I insert it into the already existing code, it dies... any suggestions would be greatly appreciated. Signed - newbie ;-) =====SAMPLE STORED PROCEDURE==== SELECT TransID, StoreNo, StoreName, TotalPoints, TotalTransactions,   RANK() OVER (ORDER BY TotalPoints DESC) AS Ranking   FROM (    -- SubQuery Starts here   select WeeklyReports.TransID, WeeklyR ...Show All

• Kaisor SQL Everywhere SLSErver to SQLEv without SSI & IIS

  Due to client requirements i have found it necessary to write an application that moves data from SQL Server to SQLEv To do this I open the SQLServer table and using a FOREACH Statement track through the table I then cast each of the fields I require into a variable Each record then calls and INSERT INTO statement to insert the data into SQLEV One serious problem is how do I get round NULLs ie if contents = ( string )ditem[ "CONTENTS" ]; returns a NULL it crashes So I want something like IF ditem[ "CONTENTS" ] = NULL contents = "" else contents = ( string )ditem[ "CONTENTS" ] It is very slow the insert statement takes about .7 of a second (although it does ...Show All

• H_K capture line of flat file [Error]

  Hi, I have a flat file with several rows of entire type in one of the rows a string comes and when it goes away to guard in the BD it falls, since I can know in that this row of the flat file the string This isn't currently possible. If you want to change that, go here, vote, and add a comment: Row numbers added to pipeline ( https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=131335 ) -Jamie PastillaReturn wrote: Hi, I have a flat file with several rows of entire type in one of the rows a string comes and when it goes away to guard in the BD it falls, since I can know in that this row of the flat file the string Sorry ...Show All

• Prestidigitation Post 2005 SP2 install, no script component can be edited.

  Anyone starting to see "Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)" after installing SQL Server 2005 SP2 on x86 machines   Second, how can it be fixed After installing SP2, the script component editor will not edit script components created in pre SP2 releases. (I also have Visual Studio 2005 SP1 installed). The script TASK editor will start, but when attempting to open a script COMPONENT in the VSA editor, a script component created for pre-SP2 packages, the following error dialog occurs. Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio) This same error dialog has occurred on multiple computers, none of them are running Vista (rather Windows XP SP2). All of the pre-existen ...Show All