would something like this be a good idea to create a stored procedure with those commands, and have EXECUTE AS with sysadmin rights, then grant rights to the proc for...

are you sure the view in question qualifies as an updatable view?

that could be the issue with your CLR, rather than CLR itself.

i'm not sure, but ot looks like you want to parameterize the value for @COI_Shell , right?

Is this what you are looking for?(I guessed on the datatype)

CREATE PROCEDURE MyProcedure(@COI_Shell int)

AS

BEGIN

SET...

something like this is the way i interpreted it:

SELECT

VIEW1.ITEMNMBR,

VIEW1.ITEMDESC,

VIEW1.ABCCODE,

VIEW1.UOMSCHDL,

Month6 + JobMonth6 AS TotMonth6,

Month5 + JobMonth5 AS TotMonth5,

Month4 + JobMonth4 AS TotMonth4,

Month3 + JobMonth3 AS TotMonth3,

Month2 + JobMonth2 AS TotMonth2,

Month1 +...

if you are using SQL2505, you can convert the TEXT to varchar(max), but if you try and view the results in SSMS, you will still have the same issue identified...

I often want to search for a specific string that was posted by a specific author; so searching for "Jeff Moden"+"Tally" yields lots of results to dig through for the...

dambuster (8/25/2009)

---

Hi all,

What I would need to know is if it is possible to create databases with a format of an older version of Sql Server from Sql Server 2008.

I...

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