SQL Server recognizes that as a valid date (Dec 1 2004 12:00AM). So, from here it depends on what you want to do. Do you just want to display...

Homebrew,

You really should have started a new thread on this, but....

http://keepass.sourceforge.net/

-SQLBill

quote: The sys admin team let me get on to the box as a Domain Administrator on the old domain.

But that box is no longer a part of that domain....

If you are talking about the SQL Server Error logs...

sp_cycle_errorlog

will do the job. That closes out the current one and opens a new one. The closed out one...

If the server got set to use Windows Authentication Only, then the SA account won't work.

No matter what the server is set for, have the system admin give you a...

So submit a QOD. The site owners don't come up with the questions, we the members do. They can only post what they get. Obviously someone sent them...

Currently the output is intended to go to Query Analyzer.

/* Purpose: This procedure returns a custom data extract that can be */

/* copied from query analyzer into Excel for further...

How are C_CLAIMTOT values being stored? Are they stored with the money symbol ($, etc), are they stored with a comma ($1,000). If so, I'm pretty sure that it's being...

It's in India (the capital city of Andhra Pradesh - from Wikipedia)

Vinod,

It looks like you are using Oracle. This website is for Microsoft SQL Server. I suggest you find an...

Here's probably the trouble: We are not using the Agent backup option.

I've never used Bridgehead, but I've used Veritas' Backup Exec and they also have an Agent for...

Nope...a log backup is all the transactions since the last backup of any kind. If you do a log backup after a differential - the log has the transactions...

If every name were:

lastname comma space firstname space initial.

All you would need to do is create a variable @thename:

1. put the fullname in there

2. copy all upto the comma into...

It depends. Can I still support myself and my family? My wife worked for one of those three letter U.S. government jobs and hated it. She wanted to...

What do your tables look like? And it would help to see some sample data and the result(s) you want from that data.

-SQLBill

It won't happen. Why not? Some of the largest users of SQL Server are the federal government and they do not allow IM. Most people don't realize the real...