Recently I created a new db in production and restored it from test.  I
have a nightly backup job that backs up all user databases.  The backup
for this new db is failing.
The message in the error log is

In a column I have some values for part names. The 6th character tells
you where the part came from, and this is the same scheme for every
single part in the database.
If I want to do something like return the basic name of a given part,

This may be an easy question but I've been reading for about a half
hour and experimenting without results.
I simply want the results of my query to display a specific field that
is typed "money" using + and -

Suppose I have a table something like:
    name (VARCHAR(64))   age (INT)   quotation (TEXT)
    =================================================
    Donald Trump         50          I am rich

I have a remote client accessing a SQL database via an internet connection to
a public IP address on our SQL server.  THe program needs to access a shared
folder for printing reports in the program, but the client does not recognize
the UNC path to the folder because they are not ...

Any suggestions much appreciated.
I have just found out that I can't update a textarea field using the
'replace' function  e.g.
UPDATE myPages

I can use the IN with the WHERE clause as example:
SELECT * FROM NORTHWIND WHERE LASTNAME IN ('FULLER','KING')
I want to use the IN and LIKE at the same time:
SELECT * FROM NORTHWIND WHERE LASTNAME LIKE ('A%','B%')

I have a problem while executing my application on the network. I don't know
why this error "cannot generate SSPI context". I have been developing client
server application in VC++.NET with SQL Server 2000. I installed my SQL
Server on Windows Server 2003 machine and configured ...

Hello everyone, I have a query problem.
I'll put it like this. There is a 'publishers' table, and there is a
'titles' table. Publishers publish titles (of course). Now I want to make a
query (in MS SQL Server) that would return the last title published by every

Beyond my control: I am finding control characters (likely tab) is
making its way into address fields of our operational system. This is
messing me up when I load the data into our warehouse w/ BCP (fields
get shifted).

Trying to do this all day and googling for answers but found none, hope
someone can help. Thanks in advance.
select * into
OPENROWSET('SQLOLEDB','SERVER';'uid';'pwd',##test)

Firstly, apologies for the multi-post - I could not decide which group would
be best to post this to.
I have a simple (I think) question.
We are about to roll out our first SQL server based application.  The

I have set up my database to be using "Simple" mode. This will not log any
txns ?
I have got the err message saying the log file is full and i need to do a
txn log backup

I want to ask if there is a way to delete a record only if a certain amount
of time is passed
like i have an EmailVerified bit column, and i want to delete that coulmn
after x days if the value of emailverified is  False after the x days has

I have been looking through some sql literature and notice that there is a
capitol 'N' in front of some quotes sometimes and sometimes not.  What does
that mean?
For instance: