I'm wondering if I'll have trouble installing SQL Server 2008 on my development machine whilst our production server is 2005? E.g. is something change so that my 2005 databases/sps/functions/views will not work correctly or other issues I should think about? Would like to do this just to test drive the new SQL Server but still be able t...
I upgraded from SQl server 05 to 08 and had a few issues. After uninstalling 05 and a few restarts later 08 installed okay, but now I don't have any SQL Server services running. I can't connect to (local)\SQLExpress or .\SQLEXPRESS via SQL Server management studio and the SQL Server services dialog shows no services. There's no add butt...
I never use Access 2007 - until today. I want to connect to an existing SQL Server 2008 database. I have tried using: External Data ODBC option - but get DSN errror Upsizing wizard with ODBC - get an error Upsizing wizard with SNAC - get ODBC error. So that one seems a none starter :-) I have done some searching and only found other...
I am trying to install SQL server express 2008 on my machine. I get an error message that says that older version of VS 2008 in installed on the computer. Upgrade to VS2008 SP1 before installing Sql server 2008. I tried to install sp1 but I get an error message that a compatible version of vs2008 is not detected on the system. the upgr...
How can I convert some Geometry data into Geography data in MS SQL Server 2008? ...
(ANSWER) How to export some Geography data from a Microsoft Sql Server 2008. You'll need to use the command line argument BCP to dump the data in it's original (native) format to a binary file. Then on the other server you can bulk insert this binary data back into a table of the same strucutre. here's some code. Export Command Line:...
Hi, For some reason sql server 2008 is not allowing me to add columns to an existing table. The table is empty btw. Is there a setting that prevents modifying tables in sql 2008? ...
Does anyone know if the problems that have been affecting Stack Overflow with regards to SQL Server 2008 Full Text Search performance have implications for the search in SharePoint? As far as I understand it SharePoint search uses SQL Server full text search. ...
I started using a Sql Compact version of my DB and during the development it occured that the DB needs to be accessible over the network. Cause I wasn't able to find a way to share the SDF file over net without replication I need to import it into SQL Server 2008 (Express). Any Ideas? ...
Howdy... here on my local LAN, I have a Windows Server 2k8 box with SQL Server 2k8 installed. I can connect to the database engine using the SSMS tool on the server, but attempting to connect to the database engine from a remote machine (also on the same LAN), the connection fails with the usual generic message about not being able to c...
I have looked at the SQL Server 2008 feature comparison matrix and it lists the express/web and workgroup editions as having the SSIS runtime. Does this mean it is possible to develop SSIS packages using the developer edition, and then deploy and run them on a server running one of the lowly SQL Server editions such as SQL Server 2008 Ex...
Is there any way to import a database backup from 2005 into 2008 express edition. What I've had to resort to is doing a script the database, then import all the data through DTS. Whenever I tried to import straight from a backup file it says something about not being to import into a new version of sql server or I'll get the below error....
My simplified and contrived example is the following:- Lets say that I want to measure and store the temperature (and other values) of all the worlds' towns on a daily basis. I am looking for an optimal way of storing the data so that it is just as easy to get the current temperature in all the towns, as it is to get all the temperature...
Example There is an application that measures temperature in each town of the world. Each measurement is taken every 5 minutes and written in to the Measurement table. CREATE TABLE [dbo].[Measurement]( [MeasurementID] [int] IDENTITY(1,1) NOT NULL, [Town] [varchar](50) NOT NULL, [Date] [datetime] NOT NULL, [Temp] [int] N...
Hi, Does someone have a link where I can read on how to access my remote server's sql server '08 installation? update I want to access sql server 2008 from management studio on a remote server. Remote access is disabled by default! ...
We're getting new servers. Trying to figure out the AMD vs Intel holy war. Is there anywhere to find unbiased performance comparisons of these two processor families? Should I quit worrying about this and file it into the "it doesn't matter" category. ...
Hi folks, i have the following two tables:- GeoShapes GeoShapeId INT IDENTITY Name VARCHAR(100) ShapeFile GEOGRAPHY [ this is a closed Polygon of Lat/Longs ] CrimeLocations CrimeLocationId INT IDENTITY LatLong GEOGRAPHY [ this is a Lat/Long Point ] Now, i have around 10K GeoShape results and around 500CrimeLocations. I'm t...
Hi, I have a number of databases on a Windows 2000 Server running the 32 bit version of SQL Server 2000. I need to transfer all the data and settings to a new server running the 64 bit version of SQL 2008 on Windows 2003 64 bit. Is this as simple as backing up the databases and restoring to the new server. Will this work with the system...
The FILESTREAM feature of SQL Server 2008, allows storage of and efficient access to BLOB data using a combination of SQL Server 2008 and the NTFS file system. When insert a row on a table which contains varbinary column with filestream attribute, the file (data) is stored directly on the file system and assigned the new name (e.g. 0000...
I've built a entity framework model against a 2008 database. All works ok against the 2008 database. When I try to update the entity on a 2005 database I get this error. The version of SQL Server in use does not support datatype 'datetime2 I specifically did not use any 2008 features when I built the database. I can't find any ref...