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

i believe the alpha symbol would require an NCHAR column, and nnot a char; the alpha is in the extended ascii character set.

well an open transaction is not a bad thing.

a running process could take a lot of time to finish; so in general, you do nothing at all when there is...

i believe binary must be converted to nvarchar, right? so the conversion to varchar is failing?

select distinct

CONVERT(NVARCHAR(100), h.HRCHY_ID, 1) fConvert,

CAST(h.HRCHY_ID AS NVARCHAR(100)) fCast

from...

you posted in a SQL 2000 forum...are you stuck with SQL 2000, or are you in SQL 2005 or above?

if you Are in 2005 or above, what is your...

take a look at this article: by selecting columns aliases as html tag names like TD and getting the data as xml, this technique seems to work really well for...

with 2005 and above, this got a lot easier; there are DMV's that have the connecting IP address now;

here's an example:

--the auditing snippet below works fine in a...

well, here's the data in consumable format...i'll try to look again at what you are asking, but i used up all my brain power converting your post to something usable....

with...