Btw, I am using SSMS 2008 on a SS2008 Db. Interestinly, when I access FinanceDev Db, via VS2008 using FinDevUser SQL Server login, I can create a data connection AND it shows me the 'fin' schema tables as I would expect.
i have two data base in two sql server instance and different computers and different places over the internet. I can create a stored procedure that does a select of a table from a database of a computer, and then insert the table in another database of another computer?
I'm building a simple C# stored proc in VS2010, Denali CTP1 (gulp). and Server 2008 R2. I have done everything that I know to do to deploy it - turned on CLR on the server, gave my self unsafe permissions - anything and everything I could think of.
What BizTalk is doing is generating a .Net assembly containing your schema as a .NET type. When .NET namespaces and types are the same it creates a few confusions.
Is there some sort of schema report you would like me to post so it can be reviewed. As a little background we were using access database and used the microsoft upsizing wizard to make the change to sql.
Teo Lachev's Applied Microsoft SQL Server 2008 Reporting Services is a great ressource and (until now) it also works for SQL Server 2005. But I'm still at my first steps of implementing the custom query designer.
The linked server is configured to use a common login to connect to the iSeries. The OLE DB initialization service failed to load. Reinstall Microsoft Data Access Components. If the problem persists, contact product support for the OLEDB provider.Cannot create an instance of OLE DB provider "IBMDASQL" for linked server"DB2".
When you first created your Linq To SQL class, and connected to your database and then started dropping tables on the Linq To SQL Design Surface, a pop-up window asks you whether you would like to connect directly to that database or create a local copy. I only know of that point to set it to use the database directly. Tuesday, July 24, 2007 7: ...
