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...

that only happens if you run the statement in tempdb. those are real object names, but they were dynamically created by SQL;lots of object names in temp start like that:

from...

charindex returns the starting position of one item.

to find two items, you need two searches;

CHARINDEX ( ' emergency',CommentColumn) > 0 OR CHARINDEX( 'not secure',CommentColumn) > 0

more likely, you...

another possbility is to bcp the query to disk, then open it up and find/replace the delimiter(tab,comma?) with </td><td> and replace all CrLf with </tr><tr>;

append the leading and trailing table...

personally, i like queries as attachments;

at one point, i know i wanted all the data in the html of the email, so i build a simple CLR that formatted the...

Alvin Ramard (9/12/2010)

---

That OP is now on my...

did your cursor just create the file prior to moving it? it's quite possible that the command to create the file was issued, and the disk sub system is still...

is this happening directly in a SQl statement run in SSMS, or are you using something else?

for example, if you are using a typed dataset in .net, which includes...

it's the compiler rules...you've probably seen it:

Msg 111, Level 15, State 1, Line 57

'CREATE VIEW' must be the first...