Is there a way to use the SQL Model (dbml) builder in VS2010 using SQLServer2000?
It works fine in VSExpress2008 + VS2008 but throws an "Upgrade SQL to 2005" error in VS2010 which seems a tad unreasonable.
Hi All
we are working on a users apllication using Access2003(VBA) as software language and SQL Server 2005 as database.
We are using ADO method and we encounter a problem.
when users create new record in a ADO Screen and they want to save the record after implementing it they receive this error :
error -2147217873 violation of primary key constraint 'PK_ '.Cannot insert duplicate key in object 'Pk_...'
Any help will be appreciated
Thanks in advance
hi, im using vb.net and mssql 2005 to create an application. i was told i should rather use sqllite as i want my application to be a standalone one with embedded database. can someone please provide me with a step to step tutorial on how to create a standalone application with an embedded database. Sorry im quite new to this. thanks to reading and answering.
Microsoft in their infinite wisdom have seen fit to remove the useful "Draw Grid" and "Snap to Grid" checkboxes in the report properties dialog that were in VS 2005 but are not in VS 2008. I'm assuming they put that functionality elsewhere but I can't find it after going through what seems like every menu option available. Does anybody know how to turn on the gridlines?
Hi,
How can I find out all the stored procedures that are calling a particular user defined function in SQL Server 2005.
Or how to assign a defult value to a parameter in a user defined function so that when a stored procedure calls that function and does not pass any value to that parameter function assumes the default value.
Regards,
Abhishek jain
I was reading the book "Expert C# 2005 Business Objects".
The book describes various base classes to be inherited by various classes to solve real-world problems.
But the book does not provide examples of all those classes.
Can anyone give me all of those examples (with reason) to better understand CSLA?
For example, Which real-world objects are to be considered as Read-only Root Objects (Student/Product/Order, etc.)? And Why?
I'm working on a report in SSRS 2005 that is a questionnaire with yes/no answers. Trying to get a checkbox on the report. Have tried using windings for the font and an iif statement to set the character, but that doesn't come out correctly when exporting to PDF. I'm using local reports, not from a report server.
Has anyone found/made any decent color themes for Visual Studio 2010?
My VS 2005/2008 themes seem to be getting mangled in the upgrade process. I'm accustomed to using the ever famous Oren Ellenbogen's Dark Scheme featured on Scott Hanselman's blog, but the upgrade process has made it downright butt-ugly. Does anyone have any gems they'd like to share?
This is wierd, but all of a sudden the `ExpectedExceptionAttribute' quit working for me the other day. Not sure what's gone wrong. I'm running VS 2010 and VS 2005 side-by-side. It's not working in VS 2010. This test should pass, however it is failing:
[TestMethod]
[ExpectedException(typeof(ArgumentNullException))]
public void Test_Exception()
{
throw new ArgumentNullException("test");
}
Any ideas? This really sux.
The report is runnig fine in Visual Studio 2005 but fails when I deploy it on IIS. It prompts, the report you requested requires further information. I think it needs to get installed some service pack either of SQL server client, or of Crystal Reports. Please suggest.
I have a .NET client that needs to connect to a remote SQL Server over the WAN, is it possible to compress SQL traffic between the client and the server?
I am using .NET 3.5 and SQL Server 2005 and greater.
How do I output/log the sql being executed behind the scenes by the Entity Framework in an asp .net mvc application? In my case I'm using a Sql Server 2005 database.
I found this question Linq to Sql logging, but I'm trying to figure out how to do this with the entity framework v1 and asp .net mvc 1.0. Any one have any ideas on how?
Reports against an SSAS 2005 cube with Currency formatted measures. In Cognos 8.2 a $ is properly displayed. In Cognos 8.4 an * is displayed instead of a $. Have you encountered this problem, and how have you worked around it?
I have heard positive things about Eclipse RCP (Rich Client Platform) - does Microsoft has similar plugin UI framework available? I found an article from the Eclipse.org marketing director where he states:
"An organization that is 100% Microsoft probably won't/shouldn't consider Eclipse RCP."
A colleague pointed out that this article was posted in 2005, so i was wondering if Microsoft has a competing product by now, and if not, why not?
From Visual Studio 2008 Command Prompt I run this command to generate .vcproj file:
>qmake -spec win32-msvc2008
And get a warning message:
WARNING: Generator: MSVC.NET: Found more than one version of Visual Studio
in your path! Fallback to lowest version (MSVC.NET 2008 (9.0),
MSVC.NET 2008 Express Edition (9.0), MSVC.NET 2005 (8.0),
MSVC.NET 2008 (9.0) in path, MSVC.NET 2008 Express Edition (9.0) in path)
For this project I use MSVS 2008 Professional. Actually the generated .vcproj file works well, but what is the warning message about?
Using a SELECT statement in MS SQL 2005 TSQL, and no source table, just variables as listed below...
@FirstName varchar(20)
@LastName varchar(20)
@ZipCode varchar(5)
...what syntax will build XML resembling the following?
<XMLDATA><REC FirstName="JOHN" LastName="SMITH" ZipCode="98052" /></XMLDATA>
I am generating a reports using SQL Reporting services 2005. I need to protect the protect the reports(pdf and excel) with the password while the user is exporting the report to to excel or pdf.
Is there any way to protect the report.
Our application tends to be running very slow recently. On debugging and tracing found out that the process is showing high cpu cycles and SQL Server shows high I/O activity. Can you please guide as to how it can be optimised?
The application is now about an year old and the database file sizes are not very big or anything. The database is set to auto shrink. Its running on win2003, SQL Server 2005 and the application is a web application coded in c# i.e vs2005
Hello,
I was trying to achieve count up timer with this jquery plugin.
As I am newbie on this, I really don't understand their documentation.
What I want to display is. I want to display counter which counts from 1st January 2005 till current date. Example of output display is
5 years 5months 5hours 5seconds (seconds will be keep counting)
Please kindly help me by posting snippets to achieve. Thanks for your time and greatly appreciated.
Hi...
I have my installer and is working fine.
What I want to add more is that I want to show the work done by installer on installer screen (Example, installing Microsoft SQL Server 2005, we get the files being copied, moved, registry entry created,......)
Similarly I want to show this on my installer.
So can anyone help me on this to how to show all these at runtime on installer screen.
Thanks,
Sunil
I am Developing Windows Form Application in .Net, I want to insert selected rows value of Gridview into database. First Column of my GridView is Checkbox, when user check one or more checkbox from gridview, i want to insert values of respective rows into Database.
In Web application i done this using DataKeyNames property of GridView.Want to know how to do it in Windows Form Application. I am using Visual Studio 2005
I used SQL Server 2005 for my small web application. I Want pass parameters to SP .
But there is one condition. number of parameter that can be change time to time.
Think ,this time i pass neme and Address , next time i pass name,sirname,address ,
this parameter range may be 1-30 ,
Please send any answer if you have,Thanks
Hi,
I have master SQL server with DB Central and a lot of satellite SQL servers with DB Client. I need to collect data from log tables(LogTable) on Client(each client has own ID in log table) to one big table on Central(LogTableCentral).
Data must go only from Client to Central
On each Client I want to have only data for this Client
I need solution with minimal amount of work on client side because of count of clients
Central is MS SQL server Enterprise, Clients are MS SQL server 2005, 2008
Thanks a lot
EDIT: data can be collected periodically(for example: every day at 01:00)
I know the following:
asp.net webforms, mvc, sql server 2005/2008, web services, and windows services.
I want to expand so I can be a little more versatile.
What things should I be focusing on? (this is general guidance, with a web focus)
I am thinking:
SSIS
windows workflow
sharepoint
What other common skills should I know that seem to be go well with what I know already?