amit_pjoshi (7/9/2013)

---

Hello Expert,

Can someone help its very urgent?

While developing the SSRS report we have to create a stored procedure using MDX query for this we have to hold the MDX...

it is not necessary to upgrade, no; the database backup is the same, regardless of service pack, version, and that's what you would backup/restore. the service packs / CU change...

tstagliano (7/9/2013)

---

what we are utilmately trying to do is run this procedure on a daily or weekly basis to pull in the actual price of our material to load into...

it does not matter if you are admin or not.

this is a common security misconception/"gotcha"....

tstagliano (7/8/2013)

---

One last piece of advice i need. i am able to run this for the first time, but i need to delete the dbo.tblPlexActualPrice table everytime the SPROC...

cschlieve (7/8/2013)

---

So here is my problem. We have a development Database that has tables that are in the middle of some long term changes that won't be done for...

Jason both your suspicions are correct:

1 you cannot backup a database that is set offline;

you simply get this error:

Msg 942, Level 14, State 4, Line 2

Database 'MyDatabase'...

Rakesh.Chaudhary (7/8/2013)

---

I am returing data into TableVariables using Cursors .So I am having data for Each date of month .

I want this data to be exported to existing EXCEL and...

sharonsql2013 (7/5/2013)

---

Hi

I declared the primary key as identity int.

Now everytime a value(code) is selected from the grid , I want a corresponding character to be concatenated to the primary...

i don't see in what you posted where you granted ABCD\svcaccount permissions in msdb to the procedure sp_start_job; you might have glossed over it, but did you do something like...

you missed Sean's snippet where you have to use a DAC(Dedicated Admin Connection) in order to see the statsblob; if you do that, the dmv sys.sysobvalues would be accessible.

select POWER(convert(bigint,2),31) as val into #temp

he was referencing another thread, where someone asked for the max size of a varchar(max);

that thread is here:

http://www.sqlservercentral.com/Forums/Topic1470699-391-1.aspx

i reused my same code example...

it's not the url itself, it's the target attribute of the a href tag that determines wether it replaces the current palce, or opens a named window or a new...

haha! cannot put anything past you! at least i didn't...

what you can do, however, is create the same trace as the default trace, and modify it from there.

an additional caveat: As far as I know,

a user created trace...