Answer Questions

• Rob Zare schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportservices

  Hi, I'm  trying to create a report using xml. I have followed the example in SQL 2005's tutorial and got an error message saying unable to execute url. I have checked url and its works fine in my browser. I thought it might have be the schema and tried to find the above on microsoft's site but to no avail. I just wondered if anyone has any ideas how I can solve this         ...Show All

• khoshnawf installing sql server 2005 on windows server 2000

  Is there a problem doing this or will it run fine. Windows 2000 Service Pack 4 is a supported platform. Thanks, Samuel Lester (MSFT) ...Show All

• yossi t Getting data from all SQL Servers in a Domaine

  Hello I successfully used ADSI and WMI to get to following Information: a list of all servers in a domain the OS installed and if it's standart or enterprise edition a list of all products installed (such as 'Microsoft SQL Server Desktop Engine (SHAREPOINTPORTAL)',' Microsoft Windows SharePoint Services 2.0', and many more) and their version numbers Now I'd like to know how to find out if it is a standart/ enterprise edition wi ...Show All

• Iktikhan ETL from multiple Access databases -SSIS?

  Howdy Folks, I have an ETL project that I want to ask a question about. I want to loop through a folder containing several Access databases, and extract and load each one into a single SQL Server 2005 database. The table layout is the same for all the Access dbs, as well as the SQL db. The number of Access dbs in the folder, their records, and their names will change. Is there a way i can use the SSIS Foreach tool to move through the folder ...Show All

• Bryan Janes Adding vertical space between rows

  I am trying to create a mailing labels report but can't seem to get any vertical space between the rows.  I see a cellpadding setting but nothing equivalent to cellspacing.  Can anyone help me out Thanks. Try adding a text box, turning off can increase and can decrease in properties, under advanced, choose format, and work with the 'amount of space to leave on each side of report item. Also try addi ...Show All

• ChangXU INSERT Not Working via Emulator SmartPhone WM 5.0

  It would be great to get some feedback on this, I've wasted nearly the whole day trying to figure it out. I've created a simple test database called test.sdf. It contains a few tables but no data. My plan is to populate the database programatically; however, the INSERT command does not seem to be working correctly. I can see that the data actually gets added to the database when I add it and iterate over it programatically (using SqlCeCommand ...Show All

• Tom Nguyen-Marsh MSFT How To Avoid Table Scan

  Hello All, Is their any way I can avoid a Table Scan by modifying the follow WHERE clause WHERE tbl_mis_Dashboard.loan_active_flg = 1 AND [tbl_mis_Dashboard].[loan_create_dt] between DATEADD(dd, DATEDIFF(dd,0,dateadd(mm,-13,getdate())), 0) And getdate() The field loan_create_dt is indexed on the table tbl_mis_Dashboard. The query returns approximately 256K records which is appropriate and necessary. Thanks all, Orlanzo ...Show All

• barty72 ???msn

  msn This group operates in english, Could you please use a english character set that everybody can have a look at your problem HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Tola Omicron phone format expression

  what will be the phone format expression , in my db i have phone stored as 3105491234 and i would like the phone format to be like this (310) 549-1234  - thank you This is because regular expressions cannot parse nulls. Replace the " Fields!Phone.Value " part of the expression with e.g. iif(Fields!Phone.Value is Nothing, "", Fields!Phone.Value) -- Robert first thanks for the reply i get this i ...Show All

• MrShadow Create stored procedure wizard in 2005?

  Where is the create stored procedure wizard in SMS 2005 that we had in 2000 ! The templates are nice, but they show syntax only.  The 2000 wizard created insert update and delete stored procedures based on the table structure.  Regards Richard   Looks like it has been removed, which is a real shame. The templates aren't much use to me - I know how to write SQL, but they are tedious when ...Show All

• BostonBakedBean recover a stored procedure

  If I can't connect to my database and my test server requires a reinstall of SQL Server 2005, how can I get my one stored proc out of there and back it up if I can't even connect to my database   Is there a file that is created that may have this   I know it's probably stored in master or something but not sure if it can be recovered. Before reinstalling the SQL Server, make a copy of the database files (.MDF and .LDF) in which y ...Show All

• Leyan SSIS transformations "when data exceeds available memory"

  I've read that SSIS tries to do all transformations in memory as a way of enhancing processing speed. What happens though if the amount of data processed exceeds the available RAM Are raw files then used (similar to staging tables) or is an error generated Barkingdog Actually neither, although at some point an error may be generated but the dataflow task will swap buffers to disk in an internal form ...Show All

• Jraven One question in T-SQL, who can tell me???

  hello, I'm doing work on sql server I write one procedure， but it cannot run correctely,the code as following: CREATE PROCEDURE ResidentRegister @nickname varchar(50), @flatID int, @residentName varchar(50), @sex tinyint, @birthday datetime, @state varchar(30), @mobileNo varchar(11), @IDCard varchar(30),@IDCardType smallint,@email varchar(50),@password varchar(50) AS DECLARE @return int /* the return values */ DECLARE @residentID int /* ...Show All

• pico1079 Failed to acquire connection / The AcquireConnection method Failed

  I am running the Sept CTP.  I have created a SSIS package that pulls data from a text file and inserts into a database.  When I run the package on the DB server it runs fine.  I have moved the package the the web server (we are attempting to kick off the package from a web site) and we get connections errors. We are running the package using dtexec from the command line. The 1st time we got The AcquireConnection method call to ...Show All

• the black knight cannot convert between unicode and non-unicode

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I bel ...Show All