View Complete Post
I'll start off with the usual caveats.. new to the forum, new to programming, not a programmer by trade..just a dabbler
A little background..
I run a hockey pool for me and a few friends. I currently use Excel to produce everything. Every week I download a csv file from a stats reseller, update my pool, then run some macros to create web pages and upload those to my site. It works alright but I want to take my pool/site to the next level. So I decided to do a new site using ASP.NET and sql express.
My plan is to download an XML file from the same reseller and update my "Player" table every week with the "new" stats.
I used a Dataset, SqlDataAdapter, and the XML file from the reseller to populate my "Player" table in the beginning. It was pretty slick, pretty easy. My problem is I can't seem to figure out how to update my "Player" table with my new stats.
First I tried using the same Dataset/SqlAdapter but it threw a Primary Key exception, saying I couldn't insert that ID because it was already existing in the table. I can fill my dataset from the "Player" table change things and save it back to the "Player" table..but that's not what I want to do.
In my min
I want to set up an automated, silent install of SQL Server 2008 R2 Management Studio (not the express version) for some DBAs and developers. I have extracted the sql_ssms.msi file (~70 MB) from the x86 directory to install on Windows XP. I would like
to simply push and use this file instead of the entire 5.5 GB folder for the entire product.
I am using a configuration file for server deployment, but for client workstations, I don't want to do this. I just want to copy only the necessary files for SSMS and launch those. Is this possible? When I install sql_ssms.msi I get errors (Windows installer
4.5 and .NET 3.5 SP1 are indeed installed first).
I have SSMS 2008 (version - 10.0.2531.0)
Back end Microsoft SQL Server 2008 (SP1) - 10.0.2723.0 (X64)
I have DB_ddlAdmin role on a database
I can create/alter a table via sql script.
In the SSMS Database Designer (GUI), When I right click on the database >> Tables and select New Table I get the following error.
"You are not logged in as Database Owner or System Administrator. You might be able to save chnages..."
Then i get a screen where SSMS asks me to enter column names. When I enter column names and I can click on Save I get "Not a Table Owner" error. The table does get created but after that i can not alter it via Database designer (I can alter it via a alter SQL).
So Long story short, I can create tabels via DDL sql but not via the SSMS database designer. This from a technical view point might not be a big deal but for a business person not knowing SQL syntax will be a critical issue.
This was reported back on 06/2009 but can't imagine it still being a active bug
Under the Table: Programming with FileStreams in SQL Server 2008 There's always been disagreement about whether large blobs, such as document and multimedia items, should be stored in the database or file system. In SQL Server 2008 you don't have to choose; filestream storage provides the best of both approaches.Bob BeaucheminMSDN Magazine May 2009
There's always been disagreement about whether large blobs, such as document and multimedia items, should be stored in the database or file system. In SQL Server 2008 you don't have to choose; filestream storage provides the best of both approaches.
MSDN Magazine May 2009
New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.
MSDN Magazine February 2009
I'm trying to embed a flv in my web page and I don't have a clue how to do it.
I downloded and installed ASPNetFlashVideo and the tools do not appear in my toolbox.
So if anyone has a work around it would be greatly appreciated.
I have several css style sheets I want to work with. I have copied them into the appropriate directory structure in my project. The styles are applied correctly.
But the manage CSS styles tool bar on the left margin doesn't seem to work correctly. At one point I had generated a style sheet and worked with it there, but now it not only can't find the one it generated, but the attach style sheet link doesn't respond at all, nor does anything in this bar. Same deadness with the CSS Properties bar. With or without a style sheet loaded in the editor -- a style sheet that is active in the project such that when I run it, the styles are applied.
VB version of studio, running on Vista home basic.
PS, the design mode works a lot better than the professional version I use in my day job on XP and server 2003.
I need to get a list of programs/files that were installed when I was trying to install VWD 2008 so I can go through and remove them. The installation did not actually install the main part of the program so I can't start with removing Microsoft VWD 2008 (a folder was created in Program files but it is empty. I found this (below) but I'm not sure that it applies. I don't want to remove programs/files that are being used by other programs. (I can't just try to install again because there is not enough room on my hard drive)
This article applies to pre-Release versions of Microsoft Visual Studio 2008. For 2005 version of this document, see Uninstalling Previous Versions of Visual Studio 2005.
For best results, Visual Studio 2008 should b
I just installed SQL Server 2008 Management studio Express on my Vista machine. i tried connecting to local machine using :.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpressnothing is working, getting this error:-----------------------------Cannot
connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific
error occurred while establishing a connection to SQL Server. The server
was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating