I don't believe that Replication will work with Users and DTS packages.

No creo que puede usar replicacion para todo.  Yo se que esta posible a duplicar Tables, Stored Procs, Views, Functions...pero...

If you want to upgrade your existing apps and DB from Numeric to Decimal, there is hardly anything to do.

First, create your F-Key before changing any data type.  Next, from...

Thanks, here's what I came up with

CREATE PROCEDURE

dbo.spGetColumnValue

/*

This Procedure Returns a Value for a Column Dynamically

*/

(

@Table...

Can you or anyone possibly give me an Example of sp_ExecuteSQL?  I can never get that thing to work with Parameters!  Thanks for the Help!

Well, I thought I'd be original.  I haven't read everyone's post but I think I have the most unique Idea for going about doing this.  Also, it works for any Table!...

Yes, I do this now.  I have the Code in VB.NET if you'd like it.

Is this something you want for a program you are developing?  Or is it something you want for the SQL Server backend (i.e. something to be able to run in...

Select * From [Table] Where Begin_Date Between '01/01/2004' And '01/15/2004'??  Not sure exactly what you're looking for

Maybe it's because you're using a Dynamic query which can't be cached?  I'm not sure, I've moved onto ADO.NET 1.1 for the past year and soon 2.0.  Try just putting...

Well, unless you are trying to connect to another Server / DB in your Stored Proc, usually "SQL Server does not exist or access denied." happens from within a program...

Thanks for clearing that up.  Since I am a Developer, I haven't learned all the Auditing processes yet.  But no doubt I do agree with you...DB programming is fun!  I...

I guess all of this is really hypothectical, but it's fun to see the responses.

Vinod Kumar mentioned "...performance tuning, auditing the database...".  How...

Here ya go!

Select t1.tid, IsNull(Count1, 0) As Count1, IsNull(Count2, 0) As Count2, IsNull((Count1 - Count2), 0) As Total

From

(Select tid, count(*) as Count1 From txn_log Where type = '10' Group By...

It has to be a Function - that's it, nothing else, game over!  You cannot include data from a Stored Proc into a Select Statement.  The only way (I know...

Great!  Thanks for the Reply!  Personally, I always try everything in my power (sometimes hours and hours of work) to get everything I need from a Select Statement.  Always my...