I want to install SQL Server 2008 Enterprise Edition to Windows 7 Professional Edition. I tried many times, but it also failed. Is it possible to do that? Anyone has successful to install on this case? Best regards, On ...
I see this on our stage system, after it has been up for 2-3 days. "The server failed to resume the transaction. Desc:39000000ef." (with desc:xxx increasing every time). The stack trace shows System.Data.SqlClient.SqlException: The server failed to resume the transaction. Desc:39000000ef. at System.Data.SqlClient.SqlConnection.OnErro...
SQL Server Management studio generated value of datatype "Date" into following string: CAST(0x38320B00 AS Date). I need to convert it into classical .NET datetime (i have the string in c# app). I know that if it were SQL Server DateTime it would be 2 times longer Hex number and first part would specify number of days from 1.1.1900, an...
Has somebody measured performance differences between "real" SQL Server database and a SQL Server Express user instances (attached .mdf database file)? What was the conclusion? Was the .mdf database file fast enough for your application? ...
Hi all, I am loading the spatial data from Geoconcept Navteq UK Map to SQL Server 2008.In geoconcept the geometry field is, sepparated values of Longitude and Latitude. I have written a one webhandler to connect to database and retrieve data in the form of GML.From that GML ,i am creating one Georss feed.I am displaying on top of virtu...
I'm desperately looking for SQL Database Publishing wizard. I've download it but it seems to require SQL Server 2005. According to http://blogs.msdn.com/webdevtools/archive/2007/10/15/sql-database-publishing-wizard-is-now-in-visual-studio-orcas.aspx it comes with Visual Studio 2008, but my Visual Studio 2008 Professional doesn't have tha...
How can I get a SQL dump of a SQL Server 2008 database? That is, a .sql file with inserts to regenerate the data in another database, much like mysqldump. ...
I have two ASP.NET websites on a web-server, and two SQL Server databases. I have a folder for Website #1, which contains a web.config with a connection string pointing to Database #1. Under the folder for Website #1 there's a staging folder called 'staging', containing Website #2, and the web.config there has a connection string that ...
Hi there, I'm going to get some real-world data the best I can for this query I'm having a hard time with. Table HierarchySet: HierarchySetId ClientId 22 1866 23 1866 Table User: UserId UserName ClientId 76 TestUser 1866 Table LinkTable: LinkId UserId OrganisationId Hierar...
I have SSRS setup and working fine. I can even access them from a web browser. The only problem is that it requires me to log in every time I want to review a report. I need anonymous users to be able to view these reports. Is this possible? ...
Hello! I'm in the process to migrate a datebase. New is that a part of the data's home is in an external database (ERP-System). I have to modify a large number of queries. How can i check all queries & SP's, if they still run successfuly? If i have a query 'A' which depends on query 'B', and i change a column in query 'B' i do not get...
This LINQ query expression emits a left join and works: from p in Prices join ip in ItemPrices on new { p.PriceId, ItemId = 7 } equals new { ip.PriceId, ip.ItemId } into priceItemPrice from pip in priceItemPrice.DefaultIfEmpty() select new { pricesPriceId = p.PriceId, z = (int?)pip.PriceId, p.Content, p.Pri...
After going thru some tutorials on SQL SERVER 2008's new feature SPARSE COLUMN, I have found that it doesn't take any space if the column value is 0 or null but when there is a value, it takes 4 times the space a regular(non sparse) column holds. If my understanding is correct, then why I will go for that at the time of database design?...
Hi, I have a schema called application. Is there a way that, rather than using the syntax SELECT * FROM application.table I can set the default schema so that I can just use SELECT * FROM table It would be the same idea as a using statement I suppose. ...
Hi, I'm in the process of upgrading from SQL 2000 - SQL 2008 Would it be possible (or feasable) to set up log shipping from Server A - that has the sql 2000 database on, to Server B - that has the SQL 2008 instance on Or is there a better way of upgrading? I need to obviously test my application using the new SQL 2008 instance.... ...
Hi I have SQL Server 2008 with a table called ProductCategories designed like this: Id | Name | ParentId 71 PCs NULL 32 MACs NULL 3 Keyboard 1 9 Mouse 1 5 Screen 1 11 Keyboard 2 7 Mouse 2 8 Screen 2 I would like to select from this table, and get a result set like t...
I ran into something a little odd this morning and thought I'd submit it for commentary. Can someone explain why the following SQL query prints 'equal' when run against SQL 2008. The db compatibility level is set to 100. if '' = ' ' print 'equal' else print 'not equal' And this returns 0: select (LEN(' ')) It appears to b...
So SQL Server 2008 in Hyper-V is a supported configuration, and should perform well as long as you use fixed or pass-through disks and increase your processor/memory settings appropriately. My question is can I use snapshots as a reliable backup mechanism, or should I use the tried and trusted maintenance plan to do my backups? ...
Has anyone ever successfully gotten forms authentication to work with report builder? I have a client who wants to use report builder outside my company's domain. Would forms authentication work for this? ...
I'm using MS SQL 2008 server, and I have a column that stores a word document ".docx". Within the word document is a definition (ie: a term). I need to sort the definitions upon returning a dataset. so basically... SELECT * FROM DocumentsTable Order By DefinitionsColumn ASC. So my problem is how can this be accomplished, the binary c...