Viewing 15 posts - 4,546 through 4,560 (of 18,926 total)
SELECT r.[session_id]
, c.[client_net_address]
, s.[host_name]
, c.[connect_time]
, [request_start_time] = s.[last_request_start_time]
, [current_time] = CURRENT_TIMESTAMP
, r.[percent_complete]
, [estimated_finish_time] =...
July 25, 2011 at 5:12 am
andrew.sugden (7/24/2011)
CaseCode: 1017856AVN.
In database...
July 24, 2011 at 6:22 am
Jeff Moden (7/23/2011)
Ya know, Remi... I thought you were just joking.
Of course I am. Why would you think otherwise ;-).
July 23, 2011 at 7:41 pm
MuchLearnSoLittleTime (7/22/2011)
July 23, 2011 at 3:46 pm
Jeff Moden (7/23/2011)
Ninja's_RGR'us (7/22/2011)
Jeff Moden (7/22/2011)
Gah... I've got to learn to read the rest of the posts first. Tow other folks basically said the same thing.
I would point out...
July 23, 2011 at 3:42 pm
Marios Philippopoulos (7/22/2011)
All I...
July 22, 2011 at 4:59 pm
Jeff Moden (7/22/2011)
Gah... I've got to learn to read the rest of the posts first. Tow other folks basically said the same thing.
I would point out the obvious that...
July 22, 2011 at 4:57 pm
lucien.jarrett (7/22/2011)
USE AdventureWorks
GO
----Create new table and insert into table using SELECT INSERT
SELECT FirstName, LastName
INTO TestTable
FROM Person.Contact
WHERE...
July 22, 2011 at 4:56 pm
yes it takes msdb too!
July 22, 2011 at 4:48 pm
This is maybe 80% shorter than manual delete.
Assuming permissions are inherited from parent folder...
Delete all the child folders.
The re-deploy your solutions (only 1 report per sub-folder) That should recreate...
July 22, 2011 at 10:15 am
Daniel Bowlin (7/22/2011)
You could still probably delete folder A, the rebuild A and A1-A50 manually than you could script this without running the risk of destroying your reporting services database.
Ya...
July 22, 2011 at 10:13 am
Lowell (7/22/2011)
Ninja's_RGR'us (7/22/2011)
Even tho the files are in "folders" it's all kept in the RS database so there's nothing to loop through on the...
July 22, 2011 at 10:12 am
Kingston Dhasian (1/22/2010)
Try this if this works..
UPDATE Table SET Column = REPLACE( Column, RIGHT(Column, 3), '' )
This won't work if the last 3 characters are used in the same sequence...
July 22, 2011 at 10:10 am
I don't think VB can work here.
Even tho the files are in "folders" it's all kept in the RS database so there's nothing to loop through on the HD.
July 22, 2011 at 10:04 am
Learn RS scripting.
Sorry no link or usefull info aside from that.
July 22, 2011 at 9:47 am
Viewing 15 posts - 4,546 through 4,560 (of 18,926 total)