If you cannot find the current Visual Studio sln project file, can you obtain
the report design from the Report Manger to plug back into the designer to
ensure that you start from the most current report verision held on the
server?
Thanks
IanYes. Using Report Manager, select the report you want and from the
Properties tab click on the Edit link to download the rdl file. FYI -
there is a nice and free utility called Reporting Services Scripter by
Jasper Smith that can grab multiple files and download ot transfer them
to another RS - http://www.sqldbatips.com/showarticle.asp?ID=62
Matt A|||Thanks Matt I'd completely forgotten this Edit link facility
"reportdude" wrote:
> Yes. Using Report Manager, select the report you want and from the
> Properties tab click on the Edit link to download the rdl file. FYI -
> there is a nice and free utility called Reporting Services Scripter by
> Jasper Smith that can grab multiple files and download ot transfer them
> to another RS - http://www.sqldbatips.com/showarticle.asp?ID=62
> Matt A
>
Showing posts with label design. Show all posts
Showing posts with label design. Show all posts
Sunday, February 26, 2012
Sunday, February 19, 2012
Get my own Store procedure from Hosted SQL server.
I have design my web and host it at ISP SQL server, unfortunately I have lost my Store procedure scripts and want to get it back from that ISp server.
1. Is there anyway to extract the stored procedure without using SQL DTS [ I have try it but only can backup my tables content/data only]
2. I can change my asp scripts direct connect to my ISP SQL server without doubt just like what I have hosting in their's.[I know my own admin password,but not the procedure wrote.]
3. ASK? Which asp/VBScript command can extract from their server without using DTS?
Thanks in advanced.Originally posted by edmun3
RE: I have design my web and host it at ISP SQL server, unfortunately I have lost my Store procedure scripts and want to get it back from that ISp server.
1. Is there anyway to extract the stored procedure without using SQL DTS [ I have try it but only can backup my tables content/data only]
2. I can change my asp scripts direct connect to my ISP SQL server without doubt just like what I have hosting in their's.[I know my own admin password,but not the procedure wrote.]
3. ASK? Which asp/VBScript command can extract from their server without using DTS? Thanks in advanced.
Q1 [Is there any way to extract a stored procedure without using SQL DTS [ I have try it but only can backup my tables content/data only]]?
A1 Yes. since you can backup and access your tables, access YourDB..Syscomments. I beleive the syscomments column in which you will find your stored procedure tsql is named text.
1. Is there anyway to extract the stored procedure without using SQL DTS [ I have try it but only can backup my tables content/data only]
2. I can change my asp scripts direct connect to my ISP SQL server without doubt just like what I have hosting in their's.[I know my own admin password,but not the procedure wrote.]
3. ASK? Which asp/VBScript command can extract from their server without using DTS?
Thanks in advanced.Originally posted by edmun3
RE: I have design my web and host it at ISP SQL server, unfortunately I have lost my Store procedure scripts and want to get it back from that ISp server.
1. Is there anyway to extract the stored procedure without using SQL DTS [ I have try it but only can backup my tables content/data only]
2. I can change my asp scripts direct connect to my ISP SQL server without doubt just like what I have hosting in their's.[I know my own admin password,but not the procedure wrote.]
3. ASK? Which asp/VBScript command can extract from their server without using DTS? Thanks in advanced.
Q1 [Is there any way to extract a stored procedure without using SQL DTS [ I have try it but only can backup my tables content/data only]]?
A1 Yes. since you can backup and access your tables, access YourDB..Syscomments. I beleive the syscomments column in which you will find your stored procedure tsql is named text.
Get Monday date from Week no
Within Tsql or RS field design environment, how can you return the Monday of
each week from either an ISO date or SQL week no value
Have been looking at DateAdd and DatePart functions with no luck
Thanks
IanCouple of article here on how to do it in tsql:
Get First Day of the Week Function
http://www.sql-server-helper.com/functions/get-first-day-of-week.aspx
Get first and last day of a week
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50624
Haven't tried any of them, but at least the discussion gives you a lot of
hints as well.
Kaisa M. Lindahl Lervik
"IanP" <IanP@.discussions.microsoft.com> wrote in message
news:1AE2E1B7-C667-4E17-B75A-9209A87A4A1C@.microsoft.com...
> Within Tsql or RS field design environment, how can you return the Monday
> of
> each week from either an ISO date or SQL week no value
> Have been looking at DateAdd and DatePart functions with no luck
> Thanks
> Ian|||Thanks Kaisa will investigate
Ian
"Kaisa M. Lindahl Lervik" wrote:
> Couple of article here on how to do it in tsql:
> Get First Day of the Week Function
> http://www.sql-server-helper.com/functions/get-first-day-of-week.aspx
> Get first and last day of a week
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50624
> Haven't tried any of them, but at least the discussion gives you a lot of
> hints as well.
> Kaisa M. Lindahl Lervik
>
> "IanP" <IanP@.discussions.microsoft.com> wrote in message
> news:1AE2E1B7-C667-4E17-B75A-9209A87A4A1C@.microsoft.com...
> > Within Tsql or RS field design environment, how can you return the Monday
> > of
> > each week from either an ISO date or SQL week no value
> >
> > Have been looking at DateAdd and DatePart functions with no luck
> >
> > Thanks
> >
> > Ian
>
>
each week from either an ISO date or SQL week no value
Have been looking at DateAdd and DatePart functions with no luck
Thanks
IanCouple of article here on how to do it in tsql:
Get First Day of the Week Function
http://www.sql-server-helper.com/functions/get-first-day-of-week.aspx
Get first and last day of a week
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50624
Haven't tried any of them, but at least the discussion gives you a lot of
hints as well.
Kaisa M. Lindahl Lervik
"IanP" <IanP@.discussions.microsoft.com> wrote in message
news:1AE2E1B7-C667-4E17-B75A-9209A87A4A1C@.microsoft.com...
> Within Tsql or RS field design environment, how can you return the Monday
> of
> each week from either an ISO date or SQL week no value
> Have been looking at DateAdd and DatePart functions with no luck
> Thanks
> Ian|||Thanks Kaisa will investigate
Ian
"Kaisa M. Lindahl Lervik" wrote:
> Couple of article here on how to do it in tsql:
> Get First Day of the Week Function
> http://www.sql-server-helper.com/functions/get-first-day-of-week.aspx
> Get first and last day of a week
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50624
> Haven't tried any of them, but at least the discussion gives you a lot of
> hints as well.
> Kaisa M. Lindahl Lervik
>
> "IanP" <IanP@.discussions.microsoft.com> wrote in message
> news:1AE2E1B7-C667-4E17-B75A-9209A87A4A1C@.microsoft.com...
> > Within Tsql or RS field design environment, how can you return the Monday
> > of
> > each week from either an ISO date or SQL week no value
> >
> > Have been looking at DateAdd and DatePart functions with no luck
> >
> > Thanks
> >
> > Ian
>
>
Subscribe to:
Posts (Atom)