my crappy pseudo code construction was off for the case statement Sean; i meant show what this example does: chop up a single field into 3 seperate fields wit the...

is there an index on the [qm_entry_dt] column on table [tblQuoteMain]?

my knee jerk reaction is to use a table value function to get whatever data you need;

for now lets see if a slightly different scalar function will work.

first thing i'd...

well lets start with the basics; are you sure you are connecting at all? can you select @@version from vb?

could you be connecting to MASTER, adn thinking you'll see tables...

Lynn Pettis (3/16/2011)

---

Your project, okay. I could provide you with code, but I'm not going to bother.

What you need is a delimited string parse function. Do a search...

great question.

this book references says that some additional logging information is stored inside the page, and as a result, that makes the max size 8060:

http://books.google.com/books?id=G2YqBS9CQ0AC&pg=PA964&lpg=PA964&dq=8060,+but+it+is+8096&source=bl&ots=ZvMVDjIUaL&sig=3HWawbxnTZqAmVYsPmcNyCSVoxY&hl=en&ei=NhKATdffOPKL0QH3_pn5CA&sa=X&oi=book_result&ct=result&resnum=1&ved=0CBUQ6AEwAA#v=onepage&q=8060%2C%20but%20it%20is%208096&f=false

i just tried to run the code in a database that is set at compatibility level 80 and it fails with that syntax check; in 90 or 100 it goes...

ig you know it was a misspelling, where every # should have been the letter i or something, you could script all the commands together, or use this a s...

tripri (3/15/2011)

---

hi i got ten column names like #gorge, H#res, Er#es like that now i want to replace all the '#' values with '.' here all that are the column...

I think it's going to look something like this: I'd ratehr see some sample data so we know it's working, but here is my best guess:

UPDATE A

SET A.ID ...

steveb's on the right track. DDL statements that create table and objects would take no time at all...but if you have 40K lines if INSERT INTO....statements

that is what is...

sp_help [tablename] is the fastest; it identifies all indexes and their columns on the table in question.

i've got a script that scripts out all columns and their includes as well,...

i suspect that instead of using a column with the identity() property, he's using a stored procedure to generate a sequence , and using the results of that...

example:

/*

(No column name)(No column name)(No column name)(No column name)

a97aa

*/

DECLARE @nc NCHAR(1)

SET @nc = N'a'

select

N'a',

ASCII('a'),

CONVERT(CHAR(1),(@nc)),

CONVERT(NCHAR(1),(@nc))

Brent Ozar's Blitz script has a snippet that does what you are looking for: finds any database that is in FULL recovery mode, but no transaction Log backup exists.

As Grant...