as suggested,

don't assign the id until the end of the registration process....if they don't complete it, you don't save to the database; use a placeholder like ID: Pending if you...

well, stating the obvious, it depends on what the trigger does;

triggers that are jsut sending emails because a new record was added can be replaced witha job that...

i agree with Vivek; if the goal is to copy everything, there are easier ways to do it;

if the goal is to increase your experience with bcp, just as a...

Brandie

It's been a while, but i thought at one point only the registered version fo WinZip has command line options? or is it a seperate application that comes with...

====edit====

where is my jump to conclusions mat? i read like the first few words and made an assumption, sorry...

looking at your post in detail now...now i see it's why the...

nope, the font is not dynamically exposed either, even though a richtextbox is being used to display the data;

about the only thing you could do is use a try catch,and...

if you are talking about the color of the results in the message panel in SSMS, the only thing you can change is the font size and font type; the...

the convert finction has an optional parameter when you convert to varchar specifically for formatting things to dates;

you want to use the 112 format stype:

SELECT CONVERT(VARCHAR(35),@date,112)

in your specific example, it's...

I am deeply relieved that I'm still able to do college level homework for people. We got an A!Sometimes, in the dark of the night, I second guess myself...

another version, this with some exclusions, since when someone says "del3ete everything" , they never think it through,a nd afterwards the say "well i mean everything except the lookup tables,...

rob.shaw (9/13/2010)

---

Hi Lowell,

Thanks for your speedy response once again.

I'm probably not making myself clear here. The fact that a "bare-metal" restore has been done means that all the SQL binaries...

rob.shaw (9/13/2010)

---

Hi Lowell,

Thanks for your input to my problem.

The problem I have is not restoring the master database, but rebuilding it. As I am doing a bare-metal recovery, everything has...

Tom Brown (9/13/2010)

---

I'm used to SQL Server. Oracle syntax is a bit different. I have Oracle SQL Plus (v9). I've solved most of my problems but need help...

auto_increment is access or mysql syntax i think it's not mapped to the SQL equivalent of IDENTITY when you run it in SSMS; simply replace that with IDENTITY(1,1) and your...

rob take a look at this thread on the same issue:

RE: Restoring Master database different versions of same service pack

in that thread, i stated that there is nothing of critical...