Nope, that's it.

Your port declarations in your post don't match. You say that you are using port 7024, but the network address is specifying port 5022. Check your port declarations. If that...

Which service pack are you using?  This was a well known bug in SQL 2000. SQLMail would just stop responding. The problem was greatly improved by service pack 4, but...

Each developer has their own personal SQL Server on their system. There is not a single unified development system. Pre-production (test) is backfilled from production every Monday and is controlled...

What is the error? Please be more forthcoming with information. You'll get more help if we don't have to drag it out of you.

Is there something specific that you need help with? I've included the syntax for functions below.

The syntax of a function from Books Online:

Syntax

---

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

November 8, 2006 at 12:16 pm

#670678

RE: Error converting data type varchar to numeric

That line will give you an error in SQL 2000 as well. The error is caused by the IsNull() function, and is not related to your data type conversion. Empty string...

---

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

November 7, 2006 at 11:46 pm

#670474

RE: Function

Okay, so what exactly do you need help with?

---

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

November 7, 2006 at 11:34 pm

#670472

RE: I need help on a good locking and rollback strategy

Create a stored procedure and allow the transaction to be rolled back within the procedure. And like John said, do 1 query, not two.

---

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

November 7, 2006 at 11:32 pm

#670471

RE: Subquery Issue

ROWCOUNT is being deprecated. It still works in 2005, but it probably won't be fully supported in future versions. I wouldn't rely too heavily on it. From BOL for SQL 2005:

---

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

November 7, 2006 at 5:21 pm

#670440

RE: Cannot Add replication services after SP1 upgrade

You don't need to do a complete reinstall. SQL will let you install individual components. Run the setup program and follow through telling it to install only the replication component.

---

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

November 7, 2006 at 5:13 pm

#670439

RE: Mirroring for certain tables from the database in sql 2005

Definitely not. Like Chris said, it is database level. Sounds like you want replication instead.

---

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

November 7, 2006 at 5:11 pm

#670438

RE: Log shipping monitor out of sync

Are the jobs using Windows Authentication or a SQL account to update the monitor? If using a SQL account and the password has changed, you will need to update it...

---

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

November 7, 2006 at 5:08 pm

#670437

RE: Filtering bad data on NVARCHAR

My, Grandma!! What a big user defined function you have!!

 

---

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

November 6, 2006 at 5:59 pm

#670212

RE: Filtering bad data on NVARCHAR

Good points. Not to mention that there is always the possibility that an all numerical value could be out of range. For example, a string of 100 1's would pass...

---

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

November 6, 2006 at 11:16 am

#670140

Viewing 15 posts - 1,051 through 1,065 (of 1,271 total)