does anyone know of a good Access to VB or .Net conversion tool?

if you know the SPID of the process currently executing, you could look at the program_name column from master.dbo.Sysprocesses in your stored procedures.

SELECT

  spid

 ,status

 ,sid

 ,hostname

 ,program_name

 ,cmd

 ,cpu

 ,physical_io

 ,blocked

 ,dbid

 ,convert(sysname, rtrim(loginame)) as loginname

 ,spid as 'spid_sort'

 ,  substring(...

imbed a web browser control into your application for the display, then you fill in your parameters on the web address as GET name=value pairs.  see

ms-help://MS.RSBOL80.1033/RSPROG/htm/rsp_prog_urlaccess_374y.htm

in reporting services BOL for...

A better way is to use NT Groups in your active directory.  Set up to use Integrated Security on the database.  Create a group, add your application users, then add the...

are your ANSI NULLs set the same on both machines?

Very Cool!  How do you control the size of the files created by the backup process?  Is there a way to specify the backup file size or do I do that by...

Thanks for the best description of what the HAVING clause is for that i have ever seen!

In general, whenever i have to do some kind of transformation on the data being imported, i will import it as is to a temporary table and then run a procedure...

Not sure if this will help you out, its VB6 not SQL but its what i use to read a Text column into a variable.  you can compute the amount...

Functions specifically return a scalar or table.  the nice thing is a table value function can be used in your from clause, you just need to alias the result

select a.a,...

Bring on the pain o wise one!  i have a similar issue, a COTS package that must remain pure, and i need to see who's making certain changes

try setting the column type in excel.  Right click the column header, choose format cells, then choose text from the list on the Number tab.  this works best before the...

do you have an antivirus or firewall application on the machine that blocks port 25?  we did and had to set up a list of exceptions on the machines sending...

is there a way to do it with SQL 2000?

set up a DNS alias.  Reference the alias in all your connection strings.  then if your primary goes down you update the DNS once and it will propogate to the...