Linked Server

How to name the Linked server. I have IP address which I link to the server but they change the IP …

How to subtract two values to give me a total and grand total

I want to subtract two different numbers to get a total and a grand total from each column. Here i…

Count Versions

I am having a tough time here, the problem is: I have a table with manufacturers, applications, and…

Migration Problems With Once Instance Registered as "Local"

I need to set up some kind of method of being sure a set of databases on a new server is kept updat…

Agent won''t execute scripts!!!

I have a simple activeX script that writes to a file on another server, my previous box was windows…

Can not update records

I tried running an Update staement and I get "Can not update multiple records." I am trying to set …

Troubles entering data in Enterprise Manager

Hey; I'm having difficulties with data entry in Enterprise Manager (SQL Server 2000).  I was e…

SQL Server service and Agent (Domain AC)

In the past when setting up new SQL Servers we have created new Domain Account and Exchange Account…

Index tuning wizard option gets grey out

WIN XP, SQL Server 2000 & Reporting Services

Hi everyone, I'm traing to install Reporting services in my machine, i have Windows XP Profetional,…

DTS Version

How to load the lastest version of DTS. I am using the following script to load the package but it …

Alter Database: maxfilesize, autogrow issue

Hoping one of you gurus will be able to help me out. I'm working with several clusters, each contai…

Another one on OPENROWSET

Is there possible to add some parameter in the provider string for this: select * from OPENROWSET (…

Stored procedure in a query?

is it possible to use a stored procedure within a query as follows- select tab, magazine, parent, b…

SQL Server Need to be dedicated server?

We have SQL Server 2K standard ed on a quad cpu and 3gb RAM. 2GB assigned for SQL and 1 for O/S. Ab…