Well, database evolution is sort of at the center of my interest, and I've been working on such a solution. On http://www.simple-talk.com/sql/database-administration/source-control-and-databases/ I describe some of the problems you are...

Jonathan Mallia (4/18/2008)

---

Hi Guys,

I have an update trigger on a table and when I run a stored procedure that updates the mentioned table, I get the error "Could not continue...

PatrickSimons (4/17/2008)

---

Does anyone know how to get the description text of a SQL Error (eg. "Primary Key violation of ..") into a variable. Like @@ERROR holds the error number, where...

Well, I knew I missed something, and I was not handling 0's properly after the decimal point. So an updated (but...

As Kent said, you could use identity to do this if you can use temporary tables. Using identity would be significantly faster on 2000 than using triangular joins. An example...

First run

EXEC sp_change_users_login 'Report'

This will tell you which users got out of sync. After that you can add the relevant login and...

Ok, probably I missed something, but for a start it will do 🙂

CREATE FUNCTION myFormat ( @a1 FLOAT )

RETURNS VARCHAR(100)

AS BEGIN

DECLARE @result VARCHAR(100)

...

One could use the...

Sorry, next question, is your mirroring actually running?

Can you check the result of

select * from sys.database_mirroring where database_id=db_id()

Regards,

Andras

M Chabot (3/14/2008)

---

Wikipeida was one of the first places I checked and was surprised at how little information there was on these encryption methods. I didn't find much useful guidance...

JACKEY CHENG (4/11/2008)

---

while i use DB mirror, the log file increased too much ,about 7 G every hour ,

so i want to shrink the log in primary server...

Jason Selburg (4/10/2008)

---

I hate to be the bearor of bad news Andras, but your query produces a cartesean product. :ermm: Your query returns some 3000 rows, and mine is the...

Oops, Jason was faster 🙂

(one difference is in our solutions is that it is enough to have one CTE expression), so you now have two solutions 🙂

Regards,

Andras

You would need to use two pivots, e.g.

WITH cteQuarterSales

AS ( SELECT DATEPART(qq, OrderDate) AS Quarter,

...

Take a backup of the 2000 database if you do not already have...