I can find two ways of doing this. 1.SetProperties() Property[] props = new Property[1]; Property setProp = new Property(); setProp.

Hello, This started as a simple thing, allow somebody to access to a database on a SQL 2005 server so they could get to it from MSAccess.

We have setup a 32-bit IIS server on a 32-bit machine. Installed necessary SQL Server components (32-bit replication components).

Question: I have a test table like this CREATE TABLE [dbo].[Test]( [name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [addr] [var

Respected Members, I have a question, when our aspx page is trying to access the SQL Server 2000 database than before this do we have to creaete a user with the name of ASPNET in SQL Serv

Hello, I have 2 tables, reason and complain. 1 complain can have multiple reasons and a reason can be linked to multiple complains.

Hi.. I'm going to build database of university, but I have problem with primaru key, This is the situation: there are many faculities a

I am in the process of tuning some queries and noticed that the client statistics tab shows the network statistics along with the number of trials as well as black, green, and red arrows.

Is there a way to pass parameters into the Report Builder so that the available fields of an entity can vary depending on a parameter value (for instance, a group or user id) We have a si

Here's a little sql 2005 script I wrote: 1. Start by running this script.... declare @x int select @x = 1 while ( @x < 75000) begin insert into myTesttable v

We're building a client application (vb.net, with Visual Studio 2005) that will need to connect to a remote SQL 2005 server.

Hi, I have one client and one server. In both hosts I created an OS-user named User1. The user have been given various role under the prefix SQLServer2005.

I have a Clustered Primary Key on a table, which is used in transactional replication. I wish to change this to a Nonclustered Primary key, can I do this without drop

Hi, Can you tell me whether the compression intended for Katmai is suitable for OLTP applications I know that Oracle has had compression for a number of years, but it is

Hi, I have one client and one server. In both hosts I created an OS-user named User1. The user have been given various role under the prefix SQLServer2005.

Hi, I'm trying to create a SSIS package. I have used OLEDBSource adapter to get the source table's data and transferring the data to an OLEDBDestination adapter.

Hi, We have been accessing databases on ASE 12.5 (on HPUX) from MS SQL Server 2000 (x32) successfully for years.

Hi all, as we are looking to a HA-solution for our SQL-environment we're expecially looking for Clustering or Mirroring.

Dear All, Hope everyone is doing well. I want to ask a question, I am using Windows Vista Home Premium Edition in my notebook, I installed

Hi, This is my first message in this forum. I am a University Student. I have to develop project that compares two databases objects then finds differences between two databa

Does anyone have a single T-SQL script that could be run against a database that would return the table name and row count for each table

Hi, I'm a compleate noob and trying to learn c# and wmi. I have used WMI queries in vbscripts but I want to take things a bit further now and read a server name from a SQL db and query WMI (eg.

Hi All This is a pretty basic question I'm sure but BOL have been of little help... I want to changed the Enabled property of the ProactiveCache object for a partitio

I encounter this error when importing SSIS packages using SQL Server Management Studio: =================================== Unable to cast object of type 'Mi

My apologies for the long explanation & I don't have any experience writing LOOPS. Using the information from TABLE#1 I'm looking to create an output file that looks

Hi, I've had this problem with a VM and now on the Live box. I installed Windows Server 2003 SP1, then install SQL server 2005 and applied service pack 1.

hello i have a problem when i try to begin transaction in sql this is the massege "SqlConnection does not support parallel transactions.

hi all. please help with my dilemma. this is my task: i should write a service that will run every 1 hour.

I'm using SQL Server 2005 version 9.0.3054. In the distribution.dbo.MSsubscriptions table, the field subscriber_db has a value of "virtual".

I need to create a simple dashboard report that will be displayed on a large screen. My problem is that there can be potentially more records than the screen can display.

Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration.

Hello, I need to build a table with encrypted data with the source data coming from a .csv. The account number from the .

I have a simple query, that produce internal server error. Internal error: An unexpected error occurred (file 'pffilestore.

I create a publication with 1 article with a parameterized filter. Empty table without records. Then i went to create a snapshot through snapshot agent.

Hi Sql Gurus. Please help me i'm in troublle now. I have Two databases,that same schemas and same tables.

I'm developing an Invoice cube and while I was debugging it I noticed some of the unit costs were too high, so I use the drillthrough to get the data behind it and the Row Count Measure (the one AS

Hello : I have tried to process a datamining structure in SQL Server 2005 (Developer Edition) but I receive these messages from Sql Server : "Errors in the high-level relational en

How difficult would it be to install IIS and SRS in a SQL Server 2005 x64 installation at a later date What steps would I take Thanks!

Hi, Is it possible to turn a server report created using report builder (with all the smdl and dsv stuff) into a report that is viewable using the Reportviewer ASP.

I have to develop a report withe Many to one and Many to many report. I am having hard time in developing the same.

Hi, Can anyone tell me more about the Flight Recorder I think I can probably make an educated guess but I'd like something concrete.