sqlfriends (5/22/2012)

---

I need to rename a reporting server which is installed SQL server 2008 R2 , both database and reporting service is on the same server.

Now after we rename the...

script the table using the script table as function when you right click the table

what are the requirements?

is it an object which exists on ServerA and you need to script it to move it to ServerB? If so right click the object and...

I've just done a quick test, 2 data sets, one based on the sample data given as a data set, and another as a proc based on the data in...

george sibbald (5/22/2012)

---

whats the recovery mode of the database?

For mirroring it needs to be in full recovery mode, for log shipping bulk or full recovery, else the features (not futures...

if it is SSRS, it could be custom code within a report, the unattended execution account, a data source, a subscription which keeps firing, an app which utilises the reportviewer.aspx...

easy, just set @sql = to what you want it to do then execute it like this

declare @sql nvarchar(max)

set @sql = 'exec master.dbo.xp_cmdshell ''rmdir "c:\tempo_SGCTLOCAL\"'', no_output'

exec (@sql)

set @sql = 'exec...

Well firstly I would get up to speed with SSRS, use Google, use the Stairways on this site to get up to speed, then start to look at what you...

Google is your friend

http://www.mssqltips.com/sqlservertip/1361/building-a-dashboard-in-sql-server-reporting-services/

not nessesarily, it could just be a invalid char to which there is no local code page varient for and it displays a box to show you something is there....

you could query the definition of the object in sys.sql_module in the databases and then query sysjobsteps in msdb where the definition or job step is like the linked server...

Yes, take a look at the link and there is plenty of good Google articles on it as well.

Could you not use the unpivot task in a DFT to do it?

Could also do a Google for "dynamic unpivot tsql", as it looks like the SSIS Junkie has already...

Excellent find downloaded and put in my e-book repository

Might be worth wrapping the url in the URL IFCode tags to make it easier for people to follow the link.

k.subramanyam1017 (5/22/2012)

---

Hi friend,

Thanks to given answer but my client said how to find out slow runnig queries or long execution queries(i dont know which query...