Search Results

Search found 28900 results on 1156 pages for 'sql 2005'.

Page 201/1156 | < Previous Page | 197 198 199 200 201 202 203 204 205 206 207 208  | Next Page >

• How do I find out the expiry date of a SQL Server 2008 trial-install instance?

  - by Peter Mounce

  So I installed a trial of SQL Server 2008 enterprise edition while waiting for MSDN licenses to come through - I now want to uninstall the trial and replace it with a developer edition installation. However, I'd like to first know how long I have left on the trial. Is there a way to do this programmatically with SQL? I looked at create_date in…

  Read the article

• How can I run a .sql file with the sqlcmd utility specifying to continue if there are errors?

  - by Matt

  How can I run a .sql file with the sqlcmd utility specifying to continue if there are errors? Right now if an error occurs, the entire sql file aborts. Is there away around this?

  Read the article

• How to backup SQL Server Agent jobs?

  - by guaike

  Hi,I want to backup my sql server 2005 Agent jobs to another server, How can I backup and restore SQL Server 2005 Agent job schedules?

  Read the article

• how to put SQL Server express R2 advance and Wt edition in the visual studio setup as a CLickOnce pr

  - by ZeroAbsolute

  Like i said in the topic: I would like to insert as a ClickOnce prerequisites sql server express r2 editions. I can do a similar package.xml and product.xml like that of sql server express that i took from vs2010 but i don't have the public key for SQLEXPRWT_x86_ENU.exe does anyone know how to find the public key ???

  Read the article

• LINQ to Entities, SQL Server version and setting ProviderManifestToken at runtime

  - by chris

  We have developers some developers who are developing against a SQL Server 2005 database, while others are using 2008. We just discovered that generating the edmx against a 2008 database set the ProviderManifestToken to 2008, which means some queries won't work against a 2005 database. While this is a known issue, is there any way to set this…

  Read the article

• Why is fulltextsearch for phrase ignored in SQL Server?

  - by cpt.oneeye

  I am executing the following SQL statement on an indexed SQL Server 2008 R2 database. SELECT * FROM mydatabase WHERE (CONTAINS(ColumnA,'"The Apple is red"')) The problem is that it returns too many entries. It also returns entries where 'ColumnA' contains only one of the words ('Apple' or 'is' or 'red'...) and not only the entries which…

  Read the article

• How to use T-SQL MERGE in this case?

  - by abatishchev

  I'm new to T-SQL command MERGE so I found a place in my SQL logic where I can use it and want to test it but can't figure out how exatcly should I use it: IF (EXISTS (SELECT 1 FROM commissions_history WHERE request = @requestID)) UPDATE commissions_history SET amount = @amount WHERE request = @requestID ELSE INSERT INTO…

  Read the article

• How do I Make Management Studio Express use proxy settings to connect to online SQL service

  - by TheAgent

  It doesn't seem like SQL Management Studio Express 2005 considers Internet Options proxy settings defined for the LAN when trying to connect to SQL Server 2005. Is there a way to make it use the proxy settings?

  Read the article

• SQL Server - Missing Indexes - What would use the index?

  - by BankZ

  I am using SQL Server 2008 and we are using the DMV's to find missing indexes. However, before I create the new index I am trying to figure out what proc/query is wanting that index. I want the most information I can get so I can make informed decision on my indexes. Sometimes the indexes SQL Server wants does not make sense to me.…

  Read the article

• Most efficient way to move a few SQL Server tables to SQLite?

  - by wom

  I have a fairly large SQL Server database; I'd like to pull 4 tables out and dump them directly into an sqlite.db for remote querying (via nightly batch). I was about to write a script to step through(most likely on a unix host kicked off via cron); but there should be a simpler method to export the tables directly (SQLite not an…

  Read the article

• How to give over right (table) permission in SQL Server 2008?

  - by Ayyappan.Anbalagan

  I am using SQL Server 2008. I tried to modify the table. But it not allowing to update. How to give UPDATE permission in SQL Server 2008?

  Read the article

• How do I add my SQL 2005 DB to my VS MVC 2 project?

  - by Jason

  I want to use the built-in membership functionality that comes with the SQL Express database that is created when the project is built but I want to use it in my SQL Server database without having to re-create the wheel so to speak.

  Read the article

• Accessing Oracle DB through SQL Server using OPENROWSET

  - by Ken Paul

  I'm trying to access a large Oracle database through SQL Server using OPENROWSET in client-side Javascript, and not having much luck. Here are the particulars: A SQL Server view that accesses the Oracle database using OPENROWSET works perfectly, so I know I have valid connection string parameters. However, the new requirement…

  Read the article

• Problems with cross forest authentication in SQL Reporting

  - by chunkyb2002

  We're currently running an SQL 2008 R2 Cluster with Reporting Services running, all for use with System Center Operations Manager 2007 R2 (RU3). Our users are on a different domains to the SCOM and SQL servers (we have two domains as we are in the process of a domain migration) We have no problems at all with users accessing…

  Read the article

• Pre-Pidded SQL Server 2008 R2 Standard Edition from TechNet fails because of invalid key

  - by marc.d

  i am trying to setup a test-enviroment with Windows Server 2008 R2 (Dell OEM Licence) and SQL Server 2008 R2 Standard Edition (from TechNet) but the installer fails with The SQL Server product key is not valid. To proceed, re-enter the product key values from the Certificate of Authenticity (COA) or SQL Server…

  Read the article

• Unable to install SQL 2008 on Windows 7

  - by Axel

  SQL 2008 install hangs on Windows 7 The story: Trying to install SQL2008 on Windows 7 hangs on SqlEngineDBStartconfigAction_install_configrc_Cpu32. What I Tried: Uninstall hangs on validation Manual uninstall using msiinv.exe and msiexec /x works Added SQL service accounts to local admins no help Turn of UAC no help Last…

  Read the article

• NAT: Exposing SQL Server 2008 Express to the internet

  - by Yves

  Hi, I have a Windows Server 2003 SP2 machine with SQL Server 2008 Express installed. I have my network configured with a NAT. Internal clients can access the instance of SQL Server without a problem. I would like to enable SQL Server to be accessible from anywhere on the the internet. I am not sure how to allow my…

  Read the article

• SQL Server 2008 Recovery Mode reverts from FULL to SIMPLE

  - by Eric Hazen

  Three of our SQL databases have their recovery model change every night from FULL to SIMPLE. The only jobs that I'm aware of are two BackupExec jobs that run nightly. Why would the recovery model change? Backup Jobs: SQL FULL BACKUP, SQL LOG BACKUP Event Manager: Event 5084: Setting Database option RECOVERY to SIMPLE…

  Read the article

• MediaWiki on MS Sql Server

  - by kdbolt70

  Hello all, I've been doing some digging on running mediawiki on sql server instead of mySQL, but haven't come across any concrete information. All of our servers are running SQL Server so I'd like to stick with that. I've tried Screwturn wiki, which is an ASP.NET wiki implementation using SQL Server, but I'm not…

  Read the article

• Microsoft SQL for PHP driver

  - by Jonas B

  Hello I am running a W2K3 x64 server with IIS 7 + FastCGI + PHP 5.3 (x64) I have trouble geting the SQL for php driver to work. It seems it doesn't get loaded, but no error is thrown. I've doublechedked the php.ini a multitude of times and I'm pretty sure I use the right version of the sql for php driver…

  Read the article

• Error when installing SQL Server 2008 on Windows 7

  - by Luis Caez

  When installing SQL Server 2008 on a Windows 7 machine, it experiences the following error. TITLE: Microsoft SQL Server 2008 Setup ------------------------------ The following error has occurred: Attempted to perform an unauthorized operation. Click 'Retry' to retry the failed action,…

  Read the article

• log shipping of biztalk database on SQL server 2008 standard edition

  - by Manjot

  Hi, I want to do log shipping for biztalk databases on SQL server 2008 standard edition (server A) to another SQL server 2008 standard edition (server B). I was told that for biztalk, logshipping is not like standard logshipping. I was able to find 2 links:…

  Read the article

• SQL Server 2008 Copy Database Wizard: Fail

  - by Nai

  I am trying to use the SQL Server 2008 Copy Database Wizard to copy a SQL Server 2008 database. I am using the SQL Management Object method. However, the copy fails with the following error: ERROR : errorCode=-1073548784 description=Executing the query "/*…

  Read the article

• Unable to add datasource in ColdFusion 9 and SQL Server 2008 R2

  - by Evik James

  I just installed SQL Server 2008 R2 and ColdFusion 9.0.1 on my Windows 7 machine for development use only. I have ColdFusion running well and serving pages (that aren't connected to a database). I can view my databases in SQL Server Management Studio. I…

  Read the article

• Sql 2000 Connect From Domain PC to WorkGroup PC using Windows Authentication

  - by bb

  Sql 2000 - I am trying to connect from a PC w/ client tools that is on a domain, to a Sql Server 2000 box that is NOT on the domain using Windows Authentication. I thought I had done this in the past this by creating an account on the non domain PC with…

  Read the article

< Previous Page | 197 198 199 200 201 202 203 204 205 206 207 208  | Next Page >