I 'd like to insert (via "bulk insert")  between 10-20 files (about
300MB each)  into one table.
The problem is that in input files decimal point is written as "," and
without leading zeros (i.e.: ",45"), and sever uses ".".

I've got a table where an index number is already given.
I want to establish a trigger on a tmp table, so each time rows are
inserted, the trigger verify the next number available in the main
table, and then update it.

I created a new database instance, but I forgot to script out the
scheduled jobs before I wiped out the original database instance.  I
have attached the original msdb database as msdb_old onto the new
instance, but I need a script to pull out the require information from

I just started using SQL to create a report. I got the syntax working
but I have absolutely no idea of how to format data. Can anyone kindly
look at my code and help me? I thank you in advance.
Details:-

Hi friends,
How can I create ONE SQL Agent JOB That will 2 activities: (Using SQL
2005)
1) Backup a specified Database (Full Backup) and store the backup file

I'm fairly new to sql server so please bear with me.
We have a sql 2005 database on our server. The .mdf is 3gb but the .ldf is
30GB - should it be this big? As a consequence we are running out of disk
space.

Does anybody know why searching for a string '@' with LIKE does not work
even when you use ESCAPE
Very strange......
Say the field has .....   I love my @*&!& friend

I am writing an application which I will deploy to my clients. It is
important for security, support, IP reasons etc, that the users are not
able to access my databse schema (i.e. view/modify/run procs etc).
What do I have to do to ensure that users will not be able to access my

I have a problem that has caused whatever hairs on my head that I had left
to disappear. I distributed an application in a pilot program to over 100
users on a corporate network using an OLEDB connection string to connect to
a SQL Server 2005 database. Of the 100 plus installs, 10 ...

I have an app that will be using SSE as the backend database. My app
consists of several executables and libraries, I need to bundle all of
them together with SSE.
Ideally, I would like to provide a single installation file that

I found that I'm making an error in my 'case' statements, and now I
want to go through a database full of many stored procedures to find
that error in some of them and to fix it.  Is there any way to do a
search through multiple stored procedures at once?  I don't see one in

on my SQL Server data file is corrupted. Unfortunately last backup was
made about half year ago. Transaction log seems to be ok.
Is it possible to restore data file from old backup and apply
transactions from current transaction log?

I remember readng that BLOBs can be stored externally (with reference to
the BLOB file stored in tables instead).
Does anyone have any experience doing this ? I have a few questions:
1).what are the things to watch out for (apart from obvious ones like

drop table [dbo].[begin_call_temp]
CREATE TABLE [dbo].[begin_call_temp] (
[Event_Datetime]  [datetime] NULL ,
[Machine_ID]  [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS

Hi: I have database mail in SQL2005 configured and it can successfully send
mail. Is there any way to configure an alert so that when a particular table
is updated, and email is sent? The table has only a single row in it.
TIA