hmmm sticll can't connect;

am i typing ADMIN:SQLINSTANCE in SSMS, or maybe it's supposed to be someplace else?

i ran this command:

DBCC TRACEON (7806,-1)

which should turn on DAC in SQL Express, just...

ok, now i'm trying to do a proof of concept.

i created this encrypted stored procedure:

--for users who are too lazy to type "SELECT * FROM" ...

My Pleasure Andy;

In my first example, I "assumed" that the ID repeated, like hoses, so you had to get last reading and current reading for each ID/House;

reading your request a...

Welcome to SSC Andy;

the key to solving this kind of issue, is that you have to join the table against a copy of itself.

the join has to get the...

get the script from here:http://vyaskn.tripod.com/code/generate_inserts_2005.txt

you simply pass the proc the table name,a dn it builds INSERT INTO YOURTABLENAME statements.

in 2005, you can use a synonym for any object...a table/view/procedure, etc, but not part of a name.

in 2000, i think you'd have to use a view for any object...

ok, i think you want to left pad the string so it is right aligned, correct?

two ways I can think of, using either the SPACE or REPLICATE functions, and grabbing...

there's not a specific predefined format for the string you are looking for;

two of the formats are pretty close, so by combining them you can get exactly what you want:

declare...

Thanks Lutz;

I was under the impression he didn't have a handle on the bit operator yet.

your example toggles the bit, right? mine was lamer and tries to set the bit,...

noone has mentioned the TSQL bitwise operators yet. pipe (|)and carat(^) for flipping bits, and ampersand for comparisons(&)

here's an example for you all:

declare @myBitField int

SET @myBitField = 42 --meaning of...

there's no direct way to append to the top of a file;

you have to do it in this order:

1.create a new file. with your Filesystem object

2.write the new stuff to...

After Dave inferred that it was the # seconds since 01/01/1970, it was pretty easy...but how the heck did he figure out the starting date?

Dave had you tripped over...

the script below might help a little;

Assume you grab your 200 backups in a number of folders/subfolders.

you probably need to RESTORE HEADER ONLY to see the DatabaseName that is associated...

I'm a little confused by the question;

a script to backup all the databases is very easy, and so is putting it in a job so it runs on a regular...

kabaari (8/18/2009)

---

I am using Coldfusion to INSERT and SELECT data. I used a to do this:

When I <cfdump> this, it works. The empty values return [empty string]. But when...