Reporting Services (SSRS)

DMO v ADO

• by julliff

• DevX

• Topic

I have just 'inherited' an inhouse app which uses DMO to maintain metadata info & recreate scripts etc. I need to rewrite a lot of the functionality to bring it up to speed with the project. Can anyone tell me the advantages of using DMO for these tasks over ADO? Thanks

2002-01-28

3 reads

Two Sql Instances On single server.

• by vishalr

• SQLServerCentral.com

• Topic

we have two sql server instances on sigle server. One instace is sql7 another is sql2000. Server has 4processors of 500 MHz. 1GB Ram. Is it required to set manual memory configurations for two instances or shall i leave for dynamic memory. Thanks

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-01-28

1 reads

Reporting Methods

• by gkk

• MSDN Communities

• Topic

I've a lot of ad-hoc reports to be generated from a legacy database. This means that the data comes from several tables with a lot of conditional processing. What is the best method to go about it. It's in SQL 2000. I connect using VB6 and ADO 2.6. If I write a SP to do […]

2002-01-23

passing parm to openquery

• by gsolomon

• Other

• Topic

Is it possible to write a stored procedure that accepts a parameter such as a Datetime and then passes that parm to an OpenQuery statement that is accessing data via a Linked Server?

2002-01-22

Table Size issue

• by Carla-Stewart

• Database Journal

• Topic

In Enterprise Manager 7.0 I know that you can see the size of the table when clicked on the database. Is there a way to get that value in Transact SQL. I need to write a query that displays all tables and their size. Thanks ahead of time

2002-01-17

1 reads

Storing the connectionID

• by julliff

• SQLServerCentral.com

• Topic

Hi, I need to store the connectionIDs in a table. I want to fire a proc from within a trigger, but I don't know how to return the connectionID, can anyone help? This is the proc so far: CREATE PROCEDURE dbo.uspCurrentUserUpdate @UserName VARCHAR(20), @SecurityToken INTEGER AS IF EXISTS( SELECT 1 FROM CurrentUsers CU WHERE CU.UserName […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-01-17

3 reads

Full text Indexing with computed column

• by Guypreach

• Other

• Topic

Hi! all I have one doubt regarding the performance tuning related to queries. We have a complex query that performs search on four columns based on the same keyword. My idea is to create a computed column for the four fields and then perform the search. The other question is ...whether it is possible and […]

2002-01-09

1 reads

sa login failure in DTS

• by Alleged-DBA

• SQLServerCentral.com

• Topic

Hi All: I installed SS2K (as domain admin) and created a simple DTS package using ADO to return the number of records in a specific table meeting a condition. When I try to run the pkg, I get an error stating SQL Server cannot be found or access is denied on the line of code […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-12-31

2 reads

Dynamic Properties Task with FTP

• by deek

• Other

• Topic

Okay- here's the deal. I have a database which will use FTP to access and download 5 files a day from a remote server. Every day the file names will change, as they are named with a convention which uses the date. An example of the five file names from 12/19/01 is: SUMMARY.2001.12.19.txt G32.2001.12.19.txt G31.2001.12.19.txt […]

2001-12-24

Top 'n' records

• by paras_98

• Other

• Topic

I want to dynamically control hte number of records returned from a stored procedure. How can I achieve it? I have tried the following query but it does not work.... create procedure myproc( @n int ) as select top @n field1,field2 from table1 i could not run the above query so had to run the […]

2001-12-24