Viewing 15 posts - 2,461 through 2,475 (of 5,109 total)
Got to love Microsoft minutes. Having to uninstall an application on the Work PC, and the Installer showed it would take an impressive 68 Microsoft minutes. Some 5 minutes later...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 5, 2017 at 8:15 am
The name is the server isn't SERVERTEST. The server is NR90F56ZX and the Instance name is SERVERTEST. You'll need to pass the Server name as NR90F56ZX\SERVERTEST. Also ensure you have...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 5, 2017 at 7:52 am
I've still got the 2K8 version...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 5, 2017 at 6:26 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 5, 2017 at 6:05 am
That's a project connection manager. Make the connection manager in your package; then you'll be able to make it dynamic.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 5, 2017 at 4:59 am
I have written a lot of dynamic SQL here and because of id...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 5, 2017 at 1:54 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 4, 2017 at 4:15 pm
At a guess it's because SSMS doesn't know what to do with a .prc file. SSMS is really only designed with sql and sqlplan files in mind. Google tells me...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 4, 2017 at 3:37 pm
Lynn Pettis - Monday, December 4, 2017 12:53 PMBy commenting the GROUP BY the query no longer parses, so doesn't run.
Of course!!!...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 4, 2017 at 1:14 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 4, 2017 at 10:02 am
Waqar571 - Monday, December 4, 2017 6:32 AMHow can I do that as I tried it.
Myself and Anthony both have links in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 4, 2017 at 6:36 am
Wait... That SP is only doing deletes and inserts..? What would you be expecting your unnamed column to be returning in your select statement, considering that your SP isn't returning...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 4, 2017 at 6:22 am
If you want the parameters pane to be hidden too, include rc:parameters=Collapsed in your URL. Building on Anthony's URL:
http://myReportsServer/ReportServer/ReportOne?ValueToFilterBy=123456&rc:parameters=Collapsed
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 4, 2017 at 5:37 am
What are you trying to do here exactly??? You can't execute a stored procedure inside a SELECT statement. At a pure guess, maybe what you're after is a (Table Value)...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 4, 2017 at 4:46 am
Also, ensdure that you shrink the files to the same size. If you have them at different sizes, SQL Server won't make proper use out of them. In your above...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 4, 2017 at 4:39 am
Viewing 15 posts - 2,461 through 2,475 (of 5,109 total)