• SQL Server Agent Job Creation

    Hello, My self Ashish Amodia from India, I want to send Automatic mail with an attachment for that I have created job and from job that I want to open my web page automatically - I am using SQL server 2000. If u know how to open web page from job than please let me know :) Thank you

    AshishAmodia20 pointsBadges:
  • How do you create stored procedures in SQL Server 2000?

    How do you create stored procedures in SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrading Microsoft SQL 2000 to SQL 2005

    I have one server running SQL Server 2005 and about five servers running SQL 2000. Does anyone know what is entailed as far as upgrading from SQL 2000 to SQL 2005? The majority of the servers are running Win2k Server.

    Mr D50 pointsBadges:
  • Deadlocks and Conflicting resources

    I have a program that loops through a temp table, and for each row looks up a value in another table, and depending on the result returned inserts a record into one of two tables. Some days this takes 10 minutes to run and others it takes 2 hours to run. There are no other processes running against...

    Bleeb45 pointsBadges:
  • Execute a view/query is slower in SQL Server 2005 than 2000

    Hi, I have migrated a database from 2000 to 2005, updated the statistic and rebuild the index. When I run the following query "select top 500 * from myview order by name", it is extremely slower in 2005 than 2000. The myview simply does an inner join with 2 table. The name is varchar(50). Strangely...

    Db23290 pointsBadges:
  • SQL Server Table and View Index

    Hi, I was wondering if migrating a database from SQLServer 2000 to 2005 using restore or detach/attach also copies the table and view index. Thanks.

    Db23290 pointsBadges:
  • Link microsoft SQL server to Active Directory

    I am getting an error while running a qurey for excuting against OLE DB provide'ADSDSOobject' Please advice Thanks Rajaa

    IT45 pointsBadges:
  • Attaching a SQL Server 2005 database to SQL Server 2000?

    Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looking for a query tool for SQL Server 2000 and SQL Server 2005

    Many of our developers would like to have a client utility like Query Browser or Query Analyzer installed on their machine, so that they can personally query our SQL Server 2000 and 2005 servers and view the results from their workstations. I am unable to find the appropriate way to install...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Adding SQL perfrmon counters

    Recently a site administrator installed a SQL2000 server on Windows 2003. For some reason the perfmon counters for SQL do not show up when trying to check performance. How should these counters be added and/or activated post-installation? In the IT trenches? So am I - read my IT-Trenches blog

    Labnuke9932,960 pointsBadges:
  • Installing SQL Server 2000 on Windows XP Pro

    How do you install SQL Server 2000 on Windows XP Professional?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Simple SQL server question?

    I want to do something that WAS easy in my former world (a dBase environment) but I can't figure out how to do it in MS Access/SQL Server 2000. I would GREATLY appreciate anyone's help. This is what I want to do, in order: 1) Select the top # records of a table, "#" is a field in another table....

    Jtischler5 pointsBadges:
  • SQL Storage Server

    I am uploading in an SQL Server with a maximum of 1250 check images per batch with a minimum of 45KB file size (back and front) with indexes using a thrid party application. The images are temporary stored on a directory watch (7 folders) before running the import application. There are instances...

    Wackojo50 pointsBadges:
  • CRViewer Logon Failed error within Visual Basic 6

    I developed and tested a VB6 program that runs CR Viewer accessing with RDC Crystal Reports 11 reports from a folder on a remote server and uses data and queries from SQL2000 on the same server. All operating systems use MS XP. My problem is that the program works on my desktop and a few others,...

    Lamm10 pointsBadges:
  • Monitor SQL Server 2000 Analysis Services Cubes

    I am working in a BI role and have some ancient AS2000 cubes that are used across the organisation. Only trouble is no-one is exactly sure who uses them daily. How can i monitor which cubes are being accessed by whom? Doesnt seem that profiler picks up AS transactions so im kinda stuck how to do...

    Bright1235 pointsBadges:
  • Deleting in a complicated data structure on SQL Server 2000

    I have a complicated data structure on SQL Server 2000 which, at times can go four levels deep. It is all designed using foreign keys, as expected. I am having difficulty getting deletion to work from the top level, which is an orders table. Some child tables have cascade deletes on, and some are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Storing and retrieving an image in SQL Server 2000

    How do I store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Large DB, low capacity line, resync log-shipping options.

    Hello, We've a large SQL2000 DB which is 335GBs in size and a majority of tables are geographically replicated to a subscriber using transactional replication across a 10Mbit line. We're going through the process of converting the DBs' environment to SQL 2005. Unforetunately I think this means...

    SuperCoolMoss140 pointsBadges:
  • Attaching a SQL Server 2005 database to SQL Server 2000

    How can i attach a database created in SQL Server 2005 to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Possible to deploy 2005 report to sql 2000 RS?

    I've never needed to do this before, but I need to know if I can deploy a report built with VS 2005 to a SQL 2000 Reporting Services box. I don't have an environment at the moment to test it on. Does anyone know if this is possible? Thank you in advance, tley

    Tley15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following