Dear
list of some strange jobs created in sol server.
one of the job contains the following code
"Cmd /c Copy ias\dnary.mdb dnary.mdb

Our DBA support rests with two teams. From 07:30am PT till 07:30pm PT, it is
from USA and then it is outsourced to India. Thus we would like to have two
paging operators for all our jobs.
I can create two operators but the sql 2005 agent job would allow to assign

Does anyone knows where can I get a script to generate backup and restore
information
like the one show below.  I need to do this quick for my boss and can't
think of a way

Here is the sample code:
CREATE PROCEDURE [dbo].[WDSHE_CATEGORIES_INSERTUPDATE]
@cat_name varchar(50),
@status char(1),

A much more complex version of this stored procedure has been working ok
for me but I'm not sure it's well formed.
In particular, the date range poses an issue when a study date range
starts getting larger. Most of the time the range requested is today

How can I select the dates in question based upon these tables. The pounds
tables has history for the past 3 years. The workdays table has current year
plus 09 and 2010. I need to grab from the pounds table the customer
shipments based based upon the next 6 months from the ...

What is tha difference between varchar and nvarchar
From http://www.developmentnow.com/g/113_2005_8_1_0_0/sql-server-programm
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

I'm trying to RETURN an integer variable called @iReturnCode after comparing
2 columns from 2 different tables after comparing the columns. I'm not real
familiar with using RETURN for this type of purpose. If the 2 columns aren't
equal, I'd like to RETURN a 1, if they are equal, ...

Do insert duplicate key errors always throw error number 2601 ?

Have a problem that is probably easy to fix, but I cannot understand why
this happens.
The following code fails because of the GO's in the code:
--------------------------

I have a ntext field in Sharepoint database that contains the results
of a choice field.  There are 5 choices (multiselect allowed) and the
results of the choices are stored as ;#General;#Leasing;#   ...etc
Is there a way to remove the ;# in query at run-time? I am trying to

We have a search form with multiple fields for searching. I've simplified the
stored procedure below to only show a couple of fields and parameters.
The users can search using the ? or _ for single character searches by
entering them in the form.  However, they also want to be ...

I have been working with SQL server for only 6 months and am surprised to
notice most articles discourage use of triggers. What is the reason?
Thank you,
Omid

SQL 2005.
I tried to take a DB offline but it just never came back.
I now just want to detach and/or delete it it.. but get error:
"There is already an open datareader associated with this Data"

I am trying to create a staging table using CREATE TABLE statement on a file
group with the file group name decided at the exectution time. Is there any
way, I can supply the file group name in the form of variable or using CTE
when I create the table using CREATE TABLE statement ...