Are Action Filters, model binding & validation new features in MVC?

am having a problem with SSRS dropping columns from the datasource if the cell in the first row is blank. Is there a configuration setting that causes this? I don’t want to crete a dummy first row that has something in every column in order for the reports to work. The data is coming in…

hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver… i believe every thing should be fine. I have check the access permission for that user. that is not the…

I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however when I try to access it, I…

Does anyone know of an efficient way to import DBFs into SQL Server 2008 (besides the “import into Access, then import the Access files into SQL server-method”)? I don’t work with SQL Server much, but I do it enough to have had this problem before (to be exact, it seems I have this problem once…

Today marks a new contest around IT Knowledge Exchange. The Lowdown (i.e. The Rules**) Every member who earns 500 knowledge points in the next 4 weeks (between today and Wednesday, February 16th) will be entered into a drawing for 5 names. You must have a completed profile including a photo or avatar to be eligible…

When I add a new data field in a Stored Procedure, how do I make the new field available to the Crystal Report?

How can I remove the password from a password protected SSIS package? I need to access its source code, but as soon as I try to open it I get the window: Enter Password. I don’t know the password. This package was created by an employee who left the company a couple of years ago.

I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when going to the pull-down menu, nor does it recognize it when I key in the instance name. We are…

Say I want to derive the following: Select ID, F1 from table Union Select ID, F2 from table Union Select ID, F3 from table Union … etc until F10. Is there smart and easy way so that I can just provide a list: F1,F2,F3,…,F10 and somehow be able to have the select statement loop through…

Say I want to derive the following: Select ID, F1 from table Union Select ID, F2 from table Union Select ID, F3 from table Union … etc until F10. Is there smart and easy way so that I can just provide a list: F1,F2,F3,…,F10 and somehow be able to have the select statement loop through…

I am getting an error while running a qurey for excuting against OLE DB provide’ADSDSOobject’ Please advice Thanks Rajaa

I am getting an error while running a qurey for excuting against OLE DB provide’ADSDSOobject’ Please advice Thanks Rajaa

I have a positional flat file which I need to load contents into a SQL table. I’ve created an SSIS package and will need to call a VB script to parse the file but since I’m new at VB and SQL I need some assistance creating the VB script. There are 4 fields in the…

I need help translating a ruby script to SQL query. I’m a SQL noob. Help please. [em]here is the script.[/em] require “rubygems” require “ruport” SQL = <<-EOS SELECT     tv.ApptDate, tv.PatName, tv.PatFirst, tv.PatLast, tv.Phone, tv.ApptTime, tv.Provlast, tv.ProvFirst, tv.ProvTitle, tv.Clinic, tv.Age, tv.Notes FROM (  /* SECOND LEVEL, this brings out cliniccode from the main query so we…

Example: last 3 columns are write, rowcount,reads [table] [tbody] [tr] [td]75072[/td] [td]SQL:StmtCompleted[/td] [td]UPDATE UserHdr SET LastActivity = ’29-Aug-2010 01:23:24 AM’ WHERE UserKey = ‘M’[/td] [td]205[/td] [td]2010-08-29 01:23:24.393[/td] [td]The FactorSoft Program[/td] [td]12695[/td] [td]2010-08-29 01:23:24.407[/td] [td]0[/td] [td]1[/td] [td]2[/td] [/tr] [/tbody] [/table]

I need to insert the contents of httplog (which is basically http://xx.xx.xx.xx/httplog) into a table in SQL Server 2005 Express. How can I do this? Can I read the contents of httplog directly into the table (with a varchar 1000), or I need to use third party software?

how to connect the sqlserver 2005 database in power builder

Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

I have a DTS job that failed on my SQL Server, but it doesn’t have a failed message in the job history. I checked out our DTS package log, and it is empty. How can I troubleshoot this DTS job failiure?