You cannot do this, the backup files with 7 are only forward compatible not backward. 2000 backups cannot be restored to 7 only to 2000.

Edited by - antares686 on 09/06/2002...

This should give you an idea of what counters pertain to what with SQL Server. Read over each and build the list you want too mointor from it.

http://www.sql-server-performance.com/performance_monitor_tips.asp

http://www.sql-server-performance.com/performance_monitor_counters.asp

"Don't roll your...

Ok imagine you wrote an Proc this way.

CREATE PROCEDURE ip_getauthors

@col varchar(50),

@keyword VARCHAR(1000) --Did this because some keyword sets are large.

AS

SET NOCOUNT ON

EXECUTE ('SELECT * FROM tbl_Authors WHERE [' + @col...

You can do both but not as one statement. This does what you state.

update tblEmails

set Flag = 'P' where email in (select top 10000 email from tblEmails where Flag...

There are two ways to do this. 1 is to create a single sp using dynamic SQL inside to be able to alter between them.

Ex.

CREATE PROC ip_search

@keyword varchar(10),

@opt int --...

If a new SP comes out this list is usually up to date. http://www.sql-server-performance.com/service_packs.asp

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Sorry you cannot use EXEC(dynamic) in that fashion. However, all you want to know is if records exist so this can help you get.

Declare @DynamicSQl varchar(250), @UserGroupId Int

SET @DynamicSQl =...

I haven't heard this, but stranger things have happend. Try the most current MDAC as long as it fits your environment. Known issue with clustered servers.

"Don't roll your eyes at...

If it occurrs so infrequently you may never find an answer as anything could be the case. You might want to check the package for multiple versions within it's history...

Ok this is round about but try and see wht happens. SHut down the service, copy the db files (log(s) and data(s)) to a test server, then run sp_attach_db (note:...

What account does SQL Server Agent run under and what does the package do (ex. Retrieves data from remote share on AS400, imports to staging table, cleans the data, moves...

quote:

---

you are not allowed to run production applications on Developer Edition

---

Chris is right on...

This may or may not make a difference, however this is the standard format for performing joining queries in SQL.

Now first thing I can see is that MyRef on each...

You have to set replication to perform a replication. Now if you want to know can you just move the records, then consider using a DTS package and set a...

Can you give me a broad over of how the data flows, where you get it, how you store it and how it forwards to the customer? SQL 2000 under...