I have a table:
ID                INT    Primary Key
EntryDate    SmallDateTime
Amount        INT

I have a scenario where we need to store strings to be used as labels
in my reports. These strings need to be represented in various
languages. So I am using a table to store the data called
localization.

I know how to get the logical name of a database from the backups (RESTORE
FILELISTONLY), but how do I get it from the database itself?
Thanks,
Tom

Is there a way to define a variable used in a main stored procedure so
that its value becomes available in a child stored procedure that it
calls?  I think normally the scope of a variable is just the immediate
proc that it's declared in.

I want to create a trigger for one of our tables that handles both
insert and update.
For the insert, it will always do something. For the update, it will
only do something if one particular column in the table was changed.

I have a scheduled job setup that I am trying to get to send an email when
the job is complete when to let me know if the job succeeded or failed.  The
job runs fine, but I get no email.  I went through setup everything for DB
mail, and I can send email with the msdb.dbo ...

   Is there a way to find out when the content of the stored procedure was
last modified. I have a few SPs which are badly documented and I need to find
out when it was created/modified.
Thanks

How do you do a full text search on all columns of a table in a single
statement?

We have a problem with this query –
declare @startDate as datetime, @endDate as dateTime
select @startDate = '2008-10-14 00:00:00.000', @endDate = '2008-10-14
23:59:59';

I'm trying to update a database using MERGE. But I don't have any source tables to use, I just have Stored Procedure arguments.
After fiddling around unsuccessfully I've come to an end now and I need help...
 Imagine the following table:
     CREATE TABLE Test (ID TINYINT PRIMARY ...

how to flip a table?
Suppose the tables has same decimail datatypes for all columns except
column0 which is varchar.
After flip the table, columnnames should be in the column0 of new table and

I have a view created thus:
if exists...
drop view MyView
SET QUOTED_IDENTIFIER OFF

I'm writing an application in VB.NET which operates data on SQL Server 2000.
One form reads data from a table. It has several checkboxes and two
Date/Time pickup controls.
With the date/time it's clear (at least it works though am not sure if I do

in one of my packages I'm using a File task to rename a file. Only when the file actually exists I want the File task to rename it.
I've set the following task properties to false: FailPackageOnFailure and FailParentOnFailure. Yet, when running the package in Visual Studio 2008, ...

Doing this in SQL 2005
All I want to do is have a column that auto generates a number for each row
starting with 1.  Since my below Select statement says show just the top 80,
it would be a column with 1 - 80.