Search Results

Search found 4708 results on 189 pages for '2005'.

Page 32/189 | < Previous Page | 28 29 30 31 32 33 34 35 36 37 38 39  | Next Page >

• When I need to create a schedule for Snapshot Agent for push transactional replication?

  - by THEn

  I am working with transactional database replication for push subscriber. My database structure will not be changed soon. Do I have to use "Schedule the Snapshot Agent"? What is the main reason to enable "Schedule the Snapshot Agent" option in snapshot agent in MSSQL Server 2005?

  Read the article

• SQL Server compatibility mode not logged

  - by smithsi

  I've been researching a problem which was diagnosed as someone changing the compatability mode for the SQL Server database from 80 to 90 on SQL Server 2005 for a database which had it's compatibility mode set to 80 due to legacy stored procedure code not having been upgraded. I found that when changing the compatibility mode this is not logged in the SQL Server logs. Has anyone seen this issue and is this a bug or is there an alternative method to track these changes?

  Read the article

• DTS/SSIS development in SQL 2005 without BIDS

  - by Pramodtech

  hi, Is there any way to develop DTS/SSIS packages in SQL 2005 without using BIDS? Thanks, Pramod

  Read the article

• Schema changes with replication

  - by Even Mien

  What are the steps to make a schema change to a SQL Server 2005 database using transactional replication? I'm trying to add a database column. I thought if I removed the article for the table, made the schema change, and then added the article for the table back that the schema change would replicate. I am now getting the following error every minute or so: SQL Server errors Replication-Replication Distribution Subsystem: agent [jobname] failed. Invalid column name 'NewColumn'.

  Read the article

• Best way to backup a SQL Server database nightly?

  - by Urda

  What is the best way to backup a SQL Server 2005 database nightly? I'm looking for a solution/strategy that would make the database backup file, and place it in an "outgoing" directory. We're wanting our FTP software to move it out to an offsite server. Any suggestions on how to make this work as desired?

  Read the article

• Which features does SQL Server need for SharePoint 2007

  - by elhombre

  Hi all The title says it, I searched the net but not even in the microsoft technet they mention what features I must activate for SQL Server 2005. Can someone help me out?

  Read the article

• Configure SQL server reportign service to send email

  - by Edoode

  Hi I'm configuring SQL server 2005 reporting server to send emails outside the domain. I have followed the steps outlined at MS but have a question: How can I supply a domain user to connect to the Exchange server in the same domain? I've tried <SMTPAccountName>DOMAIN\User</SMTPAccountName> in the rsreportserver.config.

  Read the article

• SQL Server 2008 to SQL Server 2005

  - by Sakhawat Ali

  I have an MDF and LDF file of SQL Server 2005. i attached it with SQL Server 2008 and did some change in data. now when i attached it back to sql server 2005 Express Edition it gives version error. The database 'E:\DB\JOBPERS.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported. Could not open new database 'E:\DB\JOBPERS.MDF'. CREATE DATABASE is aborted. An attempt to attach an auto-named database for file E:\DB\Jobpers.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

  Read the article

• INSERT IGNORE in MS SQL Server 2005?

  - by JohnM2

  Is there mysql's INSERT IGNORE equivalent in MS SQL Server 2005 or something similar?

  Read the article

• SQL Server: proof of sensitive data really deleted by table drop

  - by Danilo Brambilla

  Hi, I was asked to drop some tables on a Company SQL 2005 Server and provide proof of deletion because of these tables contains sensitive data. Is it possible? Thank you all for help

  Read the article

• How do I change the Web Service Account for SQL Server Reporting Services?

  - by anD666

  Hello, I am trying to configure a Report Server on SQL Server 2005 and need to change the ASP.NET Web Service Account. Can anyone point me in the right direction of how to do this. Thanks Andy

  Read the article

• Which features does sql server need for sps07

  - by elhombre

  Hi all The title says it, I searched the net but not even in the microsoft technet they mention what features I must activate for SQL Server 2005. Can someone help me out?

  Read the article

• Delete data from a SQL Server database on a full partition

  - by aleroot

  I have a SQL Server 2005 Database on a dedicated partition, during the time the database grown and now it have occupied all the space on the partition, now the problem is that the only operation I can do on the database is detach, but i want to remove old data from some tables to save space ... How can I remove old data from the database if SQL Server interface doesn't allow to run queries on it ?

  Read the article

• SQL Script fails with error: The login already has an account under a different user name

  - by Rock Hymas

  I have a script that creates a user associated with a login for SQL Server 2005. It does this immediately after creating the database and the login. One user of the script reported the following error: The login already has an account under a different user name Any idea how this might happen, and how I could modify the script to handle it?

  Read the article

• SSIS 2005 How to add a zip task?

  - by swapna

  Hi , I have a ssis 2005 project. I have to add a zipping task.ie, i have to zip a text file. But i have to follow DB standards of the ORG. strictly. 1) No 3rd party software in the DB server.Not even resourec kit tools 2) No exe's in the DB server. so i cant use(windows resource kit tools,7-zip, and a execute process task to invoke a c# exe.) please suggest me a way to achieve zipping in ssis without compromising the DB standards.Any zip task is available as an addin to SSIS 2005? Thanks SNA

  Read the article

• Can I use WCF on Visual Studio 2005?

  - by Hemant

  I am about to start a project which consumes third party web services. Because of a legacy system, I am told that I can only use Visual Studio 2005/.NET 2.0. (Though I would have preferred Visual Studio 2008 on .NET 3.5) My understanding is that WCF was released with .NET 3.0. So is there any possibility to use WCF on Visual Studio 2005 by using just the WCF assemblies of .NET 3.0? I will then try to convince them that it is just like using external framework which doesn't disturb anything.

  Read the article

• OData with Visual Studio 2005 and .NET 2.0

  - by Morri

  Is it possible to use OData with Visual Studio 2005 and .NET framework 2.0 ?

  Read the article

• SQL Server Reporting Services 2005 - Accessibility Guidlelines

  - by AJM

  Does anyone know if the html output from SQL Server Reporting Services 2005 is accessible in terms of the WCAG 1.0 or 2.0

  Read the article

• Transaction Log filling up on SQL database set to Simple

  - by Will

  We have a database on a SQL 2005 server that is set to Simple transaction mode. The logging is set to 1 MB and is set to grow by 10% when it needs to. We keep running into an issue where the transaction log fills up and we need to shrink it. What could cause the transaction log to fill up when its set to Simple and unrestricted growth is allowed?

  Read the article

• How to Export SQL Server IMAGE data to Oracle's BLOB?

  - by alextansc

  I'm trying to export a table with IMAGE data type fields in SQL Server 2005 to a table with BLOB data type fields in Oracle 11g. What is the recommended way to perform this operation, assuming we have more than a thousand records to export at once?

  Read the article

• [SQL SERVER] Proof of sensible data really deleted by table drop

  - by Danilo Brambilla

  Hi, I was asked to drop some tables on a Company SQL 2005 Server and provide proof of deletion because of these tables contains sensible data. Is it possible? Thank you all for help

  Read the article

• What's the importance of restoring SQL Server system databases (model, master, etc.)?

  - by Zero Subnet

  I had to restore some production databases to a different drive on the same Microsoft SQL Server 2005 machine. That worked fine and the application using the databases is back online. However, i have not restored the system (or default?) databases that SQL Server creates on its own (model, master, etc.). My question is, what is the role of these databases? and how important it is that i restore them?

  Read the article

• disable the hyperlinks SQL Server Reporting Services

  - by Vinoj Nambiar

  We are using SQL Server 2005 Reporting Services (SSRS). We need to disable the hyperlinks for drill down reports while exporting the reports to excel from report viewer. Is there any way to achieve this in SSRS 2005?

  Read the article

• How to create a database and populate it during setup

  - by Philippe

  I would like to find a way to create and populate a database during asp.net setup. So, what I'm willing to do is: Create the database during the setup Populate the database with some initial data (country codes or something like that) Create the appropriate connection string in the configuration file I'm using .NET 3.5 and Visual Studio 2005, and the Database is SQL Server 2005. Thanks in advance.

  Read the article

• Using the Windows 7 and DirectX SDKs with VS2005

  - by Eduardo León

  I have Visual Studio 2005 and want to teach myself DirectX in my free time. I downloaded the latest Windows 7 and DirectX SDKs. According to Microsoft's website, the latest DirectX SDK is not compatible with Visual Studio 2005 (I assume they mean it's not compatible with the SDK it came with). Can I configure VS2005 to use the SDKs I downloaded instead of the SDK it came with? If so, is there anything I should be particularly careful with?

  Read the article

< Previous Page | 28 29 30 31 32 33 34 35 36 37 38 39  | Next Page >