Search Results

Search found 4737 results on 190 pages for 'reportingservices 2005'.

Page 38/190 | < Previous Page | 34 35 36 37 38 39 40 41 42 43 44 45  | Next Page >

• WSUS 3.0 SP2 installation fails at "configuring database" step.

  - by flashkube

  Attempting to install WSUS 3.0 SP2 on a Windows Server 2003 Enterprise system. I'm asking the setup to create a new database on one of our existing SQL Server 2005 systems. When the setup gets to the "configuring database" step it stops and throws "There is a problem with this Windows Installer package. A program run as part of the setup did not…

  Read the article

• SqlBulkCopy From CSV to SQL Datatable

  - by Swapnil

  I'm using SQL Server 2005, VB.NET 2005. I want to be able to import a very large excel file into a SQL table called "XYZ" I've done this by doing the following: 1. Save the excel file as csv.(Using SaveAs XLCSV option) 2. Build a datatable "ABC" From CSV.(using ODBC Connection and Select * from '*'.csv command) 3. copy the datatable"ABC"…

  Read the article

• SQL Server replication - how to sync tables from internal database to read-only website database

  - by frankadelic

  I have an internal SQL Server 2005 database "ADMIN_DATA" that is used by admin users. We would like to sync three of the database tables in ADMIN_DATA out to another SQL Server 2005 database "WEB_DATA", which is used by a public web app. WEB_DATA is read-only - only SELECT statements are allowed, while ADMIN_DATA is updated all the time. …

  Read the article

• Debugging stored procedures, without using SSMS 2008 Debugger, or the Visual Studio debugger (output

  - by Albert

  I have a SQL Server 2005 database with some Stored Procedures (SP) that I would like to debug...essentially I would just like to check variable values at certain points throughout the SP execution. I have SSMS 2008, but when I try to use the debugger, I get an error that it can't debug SQL Server 2005 databases. And I can't use the Visual…

  Read the article

• Asynchronous sqlserver

  - by bob

  how can i use Asynchronous queries in sqlserver 2005 & asp (not .net)

  Read the article

• Difference between SQL 2005 and SQL 2008 for inserting multiple rows with XML

  - by Sam Dahan

  I am using the following SQL code for inserting multiple rows of data in a table. The data is passed to the stored procedure using an XML variable : INSERT INTO MyTable SELECT SampleTime = T.Item.value('SampleTime[1]', 'datetime'), Volume1 = T.Item.value('Volume1[1]', 'float'), Volume2 = T.Item.value('Volume2[1]',…

  Read the article

• Decimal data Type Display scale part as zero

  - by Wael Dalloul

  I have Decimal field in SQLserver 2005 table, Price decimal(18, 4) if I write 12 it will be converted to 12.0000, if I write 12.33 it will be converted into 12.3300. Always it's putting zero to the right of the decimal point in the count of Scale Part(4). I was using these in SQL Server 2000, it was not behaving like this,…

  Read the article

• When restoring a backup, how to disconnect all active connections?

  - by estourodepilha.com

  My SQL Server 2005 doesn't restore a backup because of active connections. How to force it?

  Read the article

• Web Service appears as website instead of developer web server

  - by stocherilac

  I recently reimaged my PC and regrabbed one of our projects from Source Safe. In our solution we have a web service that normally runs on a server, however we can build the webservice on our localhost for debugging as well. However, now whenever I grab the project from source safe it is building the webservice as a website instead of a…

  Read the article

• SQL server 2055 remote connection problem, cannot solve it help please thank you

  - by user287745

  note:- if this question does not fit this site please do not just close it but also redirect the question to the fitting sister site, thank you" the steps taken and the error are mentioned please help, i am stuck here! installed sql server 2005 express on both computers installed sql server management studio express on both computers…

  Read the article

• How can i rename my column in sql table?

  - by Phsika

  how can i rename column name via alter table in Ms sql 2005 forexample: alter table tablename rename "old col name" to "new col name"

  Read the article

• Use MTS (Microsoft Transaction Server) for object pooling

  - by MZT

  How to use and configure Microsoft Transaction Server (MTS) for object pooling with SLQ Server 2005?

  Read the article

• stored procedures and triggers the same in sql server than mysql?

  - by user314877

  Hello, I have two stored procedures and one trigger for a class I am taking that are done in sql server 2005. I want to recreate them in mysql with phpmyadmin. Everytime i put them in I get a 1064 error. Is this becuase phpmyadmin does not handle stored procedures or triggers well, or is it becuase the syntax from sql server 2005…

  Read the article

• Desimal data Type Display scale part as zero

  - by Wael Dalloul

  I have Decimal field in SQLserver 2005 table, Price decimal(18, 4) if I write 12 it will be converted to 12.0000, if I write 12.33 it will be converted into 12.3300. Always it's putting zero to the right of the decimal point in the count of Scale Part(4). I was using these in SQL Server 2000, it was not behaving like…

  Read the article

• using delete or update command in a function

  - by anand-juventus

  can we use delete or update command inside a function in sql server 2005 database or any other database?

  Read the article

• Is it possible to execute stored procedure through a Linked server

  - by TonyP

  Is it posible to execute Oracle 10g stored procedure on a sql 2005 Linked Server.

  Read the article

• How to export SQL Server data from corrupted database (with disk write error)

  - by damitamit

  IT realised there was a disk write error on our production SQL Server 2005 and hence was causing the backups to fail. By the time they had realised this the nightly backup was old, so were not able to just restore the backup on another server. The database is still running and being used constantly. However DBCC CheckDB fails.…

  Read the article

• Anyone know of any good Database Diff tools?

  - by Haoest

  I can't find any good ones in sourceforge :( Anyone has any success with open source (or retail) database diff tool? EDIT: for sqlserver 2005

  Read the article

• How can I force a subscriber to be synchronized from a local snapshot?

  - by Brian

  Hello, I have a SQL 2005 server replicating(merge\push) to SQL 2005 and SQL 2000 servers. I have multiple subscribers spread througout the United states. I have set , @snapshot_in_defaultfolder = N'false', @alt_snapshot_folder = N'c:\snapshots\Merge\' (sample location). I take the snapshot from the publisher that is in the…

  Read the article

• Visual Studio add-in to support images inline with source?

  - by Jesse Stimpson

  We use Visual Studio 2005 here, and in an attempt to improve the documentation of our source, we're looking for a Visual Studio add-in that will allow images to be viewed in line with source from within the IDE. For example, the use case I'd like to fit is the following: In the directory in which my source lives, I save my…

  Read the article

• put today + 3 working days (as default value) in a Sql datetime field

  - by Michel

  Hi, i want to set the default value in a sql server 2005 datetime field to today + 3 working days.

  Read the article

• Mass data store with SQL SERVER

  - by Leo

  We need management 10,000 GPS devices, each GPS device upload a GPS data every 30 seconds, these data need to store in the database(MS SQL Server 2005). Each GPS device daily data quantity is: 24 * 60 * 2 = 2,880 10 000 10,000 GPS devices daily data quantity is: 10000 * 2880 = 28,800,000 Each GPS data approximately…

  Read the article

• Connection Timeout Linked Server

  - by Wade73

  I have created a linked server from one SQL Server 2005 to Another 2005. When I run an update query through the SQL Server Management Studio (SSMS), it runs in under a second. If I run the query through a asp webpage it times out. I ran SQL Profiler to see if I noticed anything as well as the Activity Monitor in SSMS…

  Read the article

• Single logical SQL Server possible from multiple physical servers?

  - by TuffyIsHere

  Hi, With Microsoft SQL Server 2005, is it possible to combine the processing power of multiple physical servers into a single logical sql server? Is it possible on SQL Server 2008? I'm thinking, if the database files were located on a SAN and somehow one of the sql servers acted as a kind of master, then processing…

  Read the article

• Encrypt column names of tables in SQL SERVER EXPRESS

  - by Josh

  Hello, What is the best way to encrypt columns in SQLSERVER 2005 EXPRESS edition so that no one can steal our database design? Thanks

  Read the article

< Previous Page | 34 35 36 37 38 39 40 41 42 43 44 45  | Next Page >