a copy of SQLFile.sql please :: MS SQL 2005

when trying New Query in MS SQL 2005 management studio I get the following error :
cannot find the file
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbe nchprojectitems\Sql\SQLFile.sql

is someone could paste me here the content of SQLFile.sql ?

thank youan emty file !
it works

A connection could not be made to the report server http://[IP Address]/ReportServer

Hi

I have sql server 2005 Business Intelligent studio on my machine and Report server on some other machine. I created one rdl file and tried to deploy it on the report server. I have checked the report folder name and everything. But the error mentioned in the subject is being thrown. Additional information is

The request failed with HTTP status 407: Proxy Authentication Required. (Microsoft.ReportingServices.Designer)

Please let me know what all I need to do to resolve the problem.

Regards

Rajesh

Hi,

I too faced the same problem. I have a temporary solution . First copy these files in the machine ( Report Server ). copy the full folder i.e folder containing the reports and its handles(.vssscc files,.rptproj files). Then deploy it. This worked .

Regards

neevarp

A connection could not be made to the report server http://[IP Address]/ReportServer

Hi

I have sql server 2005 Business Intelligent studio on my machine and Report server on some other machine. I created one rdl file and tried to deploy it on the report server. I have checked the report folder name and everything. But the error mentioned in the subject is being thrown. Additional information is

The request failed with HTTP status 407: Proxy Authentication Required. (Microsoft.ReportingServices.Designer)

Please let me know what all I need to do to resolve the problem.

Regards

Rajesh

Hi,

I too faced the same problem. I have a temporary solution . First copy these files in the machine ( Report Server ). copy the full folder i.e folder containing the reports and its handles(.vssscc files,.rptproj files). Then deploy it. This worked .

Regards

neevarp

A better way Generating Scripts with SQL Mgmt Studio

Is there a better/faster/persistable way to generate sql objects with the ms sql server mgmt studio than to go thru that long wizard? I hate having to configure it each time.RIGHT click on database, choose Tasks -> Generate Scripts and go through the wizard. You can choose all the objects you want in one run.|||Make sure the database you need is open in the object browser right click on the object in management studio and click on create. This generates the code for only that object. Hope this helps.|||thanks for response guys/fellow Houstonion but using generate scripts is a pain, since im creating scripts often in a day, I hate having to reset the settings each time. Am I the only one that sees this as a pain?|||All database objects must be scripted or you can recreate the whole database with .bak file with the backup and restore wizard.|||

let me explain, i have a subset of several stored procs and tables that I may modify throughout the day, generate scripts for it, deploy, then repeat.

Therefore if there was a way to set up the preset choices It would save a lot of time and be less prone to error, hard to believe this hasnt been done.

|||If you want to run it as Exe you need Install shield but the problem is I run the .sql files faster than the Install shield version because it is just a cover. I have used most expensive SQL Tools including Toad and Embercadero all just generate .sql files because you can run .sql files any where including command line.|||

sorry i dont understand, why would i want an exe to generate some sql scripts?

so you think to decrease the time it takes to gen erate a subset of sql objects on a db I need to get a sql tool?

|||No that is not what I am saying, what I am saying is there is no difference even with a tool. I think using the object browser takes you to the stored proc or table you need in the database you have opened. But tools will catch errors more than management studio.|||Ok well thanks for reply, wish there was a way to run some sort of batch to recreate my scripts on demand. too bad.sql

95th percentile calculation

Hi *,

For our needs, we have to integrate on a Visual Studio project (a Report Server Project, which gives a report dealing with AVG, MAX counters' values from a SQL DB), a calculation of a '95th percentile' average for a counter (in place of a 'normal' average).
(In another words, we have to automatically substract the 5th 'highest values' of the total of the value, and so only make the average on the remaining 95th of the value).
And this treatment should appear as a function, that we could integrate on the Report.

Does this function already exist ?

Does anyone have any idea to help me to find how to do ?

Tks a lot to everybody.

HI,snakeoli :

Can you elaborate more about your requirment? Do you need something like top 5 percent?

|||

Hi,

No, in fact, we have to calculate the average, in the case for several ranges of values.
But to have 'relevant' results, for each sorted ranges of values, we have to exclude 5% of the highest values before calculating the average.
This maneer is called '95th percentile calculation'.

(for ex : in this range of 20 values : 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20
the 95th percentile give : 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19 !!
=> exclusion of the 5thhighest values of the list (5% of '20' gives '1' ==> 1 value)
And so, calculation of the average only on 19 values !)

The goal is, in some case, to supress values that can influence the result of a average.

Imagine that in this example, we have '1250' in the place of '20' !

So the average of the 20 values gives a result not relevant !
(1+ 2+ 3+ 4 + ...+ 18 + 19 + 1250) / 20

And so, finaly, that what we need to create, throught Visual Studio :
a function (similar as 'AVG()') that can calculate automaticaly this !
(for a sorted range of value, a average excluding the 5th highest values !)

I whisper sincerely that I was clearly in my explanation.

Thanks a lot for your help.

|||

Hi,snakeoli:

I got to know what you want to do in this scenario. However AVG() can not deal with such comlicated calculation for you. I just recommend you to do this in the sql statement. It will be much reasonable.

8.00.0276 still showing within SQL Server 2005

Hello:
We upgraded SQL Server 2000 to SQL Server 2005, last week. No issues arose.
But, when we opened the SQL Server 2005 Management Studio, the phrase
"8.00.0276" appeared next to the name of the SQL Server on the left (above
databases and so forth). That appears to the be the SQL 2000 version number.
Does that mean that the upgrade did not actually happen? I have
documentation on how to upgrade SQL 2000, and we followed it. Isn't it just
a matter of putting in the 2005 CD, telling it what instance to upgrade, and
"doing it"?
Thanks!
childofthe1980sSeems you are looking at the wrong instance or you didn't do the upgrade of the database engine. You
can connect and execute below, just to be certain:
select @.@.version
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in message
news:234CC08B-B0DA-4653-9D07-4EC2D5E5137A@.microsoft.com...
> Hello:
> We upgraded SQL Server 2000 to SQL Server 2005, last week. No issues arose.
> But, when we opened the SQL Server 2005 Management Studio, the phrase
> "8.00.0276" appeared next to the name of the SQL Server on the left (above
> databases and so forth). That appears to the be the SQL 2000 version number.
> Does that mean that the upgrade did not actually happen? I have
> documentation on how to upgrade SQL 2000, and we followed it. Isn't it just
> a matter of putting in the 2005 CD, telling it what instance to upgrade, and
> "doing it"?
> Thanks!
> childofthe1980s

8.00.0276 still showing within SQL Server 2005

Hello:
We upgraded SQL Server 2000 to SQL Server 2005, last week. No issues arose.
But, when we opened the SQL Server 2005 Management Studio, the phrase
"8.00.0276" appeared next to the name of the SQL Server on the left (above
databases and so forth). That appears to the be the SQL 2000 version number.
Does that mean that the upgrade did not actually happen? I have
documentation on how to upgrade SQL 2000, and we followed it. Isn't it just
a matter of putting in the 2005 CD, telling it what instance to upgrade, and
"doing it"?
Thanks!
childofthe1980s
Seems you are looking at the wrong instance or you didn't do the upgrade of the database engine. You
can connect and execute below, just to be certain:
select @.@.version
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in message
news:234CC08B-B0DA-4653-9D07-4EC2D5E5137A@.microsoft.com...
> Hello:
> We upgraded SQL Server 2000 to SQL Server 2005, last week. No issues arose.
> But, when we opened the SQL Server 2005 Management Studio, the phrase
> "8.00.0276" appeared next to the name of the SQL Server on the left (above
> databases and so forth). That appears to the be the SQL 2000 version number.
> Does that mean that the upgrade did not actually happen? I have
> documentation on how to upgrade SQL 2000, and we followed it. Isn't it just
> a matter of putting in the 2005 CD, telling it what instance to upgrade, and
> "doing it"?
> Thanks!
> childofthe1980s

8.00.0276 still showing within SQL Server 2005

Hello:
We upgraded SQL Server 2000 to SQL Server 2005, last week. No issues arose.
But, when we opened the SQL Server 2005 Management Studio, the phrase
"8.00.0276" appeared next to the name of the SQL Server on the left (above
databases and so forth). That appears to the be the SQL 2000 version number
.
Does that mean that the upgrade did not actually happen? I have
documentation on how to upgrade SQL 2000, and we followed it. Isn't it just
a matter of putting in the 2005 CD, telling it what instance to upgrade, and
"doing it"?
Thanks!
childofthe1980sSeems you are looking at the wrong instance or you didn't do the upgrade of
the database engine. You
can connect and execute below, just to be certain:
select @.@.version
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in messa
ge
news:234CC08B-B0DA-4653-9D07-4EC2D5E5137A@.microsoft.com...
> Hello:
> We upgraded SQL Server 2000 to SQL Server 2005, last week. No issues aros
e.
> But, when we opened the SQL Server 2005 Management Studio, the phrase
> "8.00.0276" appeared next to the name of the SQL Server on the left (above
> databases and so forth). That appears to the be the SQL 2000 version numb
er.
> Does that mean that the upgrade did not actually happen? I have
> documentation on how to upgrade SQL 2000, and we followed it. Isn't it ju
st
> a matter of putting in the 2005 CD, telling it what instance to upgrade, a
nd
> "doing it"?
> Thanks!
> childofthe1980s

64bit Server 32bit Client

I installed SQL 2005 on a 64bit server. Can I still use enterprise studio on a 32bit client machine?

The install CD's are 64bit and when I try to find the enterprise studio to install on my 32bit machine i get an error. Is there a place to download the 32bit enterprise studio? What are my options here?

Thanks in advance.

Mike

32 bit tools can happily talk to a 64 bit server.

50(The request is not supported.)

I'm attempting to create an assembly in SQL Server Management Studio
express and I'm getting the following error message.
Msg 6502, Level 16, State 7, Line 1
CREATE ASSEMBLY failed because it could not read from the physical file
'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
supported.).
I've tried a ton of different things and I can't get this to work. Does
anyone have any ideas?<DIV>"IndyChris" <chrisshearier@.yahoo.com> wrote in message
news:1157049490.180110.320140@.74g2000cwt.googlegroups.com...</DIV>> I'm
attempting to create an assembly in SQL Server Management Studio
> express and I'm getting the following error message.
> Msg 6502, Level 16, State 7, Line 1
> CREATE ASSEMBLY failed because it could not read from the physical file
> 'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
> supported.).
> I've tried a ton of different things and I can't get this to work. Does
> anyone have any ideas?
>
Put the DLL in a folder that SQL Server can access, and reference it there.
David

405 Error when passing parameters to reports - IIS and Reporting Services

When trying to use a report that requests parameters, while in Visual
Studio everything works fine. I can preview the report and select a
parameter, click view report and the report works. When I deploy the
report to the server and test on the web site, after I select the
parameter from the drop down and click the View Report button I get an
error in the selection criteria fram that says...
(Clip)
The page cannot be displayed
The page you are looking for cannot be displayed because the page
address is incorrect.
----
Please try the following:
If you typed the page address in the Address bar, check that it is
entered correctly.
Open the finreports.mc.vanderbilt.edu home page and then look for
links to the information you want.
HTTP 405 - Resource not allowed
Internet Information Services
----
Technical Information (for support personnel)
More information:
Microsoft Support
(/Clip)
The Report page itself stays blank. When checking the IIS logs, I
see..
(Clip)
443 POST /ReportServer
%2fDepartment+of+Finance+Reports%2fDNFB+Test+Data 405 1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
(/Clip)
It's giving a 405 error on the post to the ReportServer path. This
report, and other reports, work perfectly when used without any
parameters, it's only giving this error when I add parameters for the
user to select.
Does anyone have any ideas? I'm sure it's something I've overlooked,
but I've been gazing at this so long just trying to get Report Server
working in an SSL and Domain locked environment that I'm cross-eyed.
I need an outside view and opinion.
Thanks for any help anyone can give.
TnNytehawkFound the fix to this a couple of hours after I posted, but Google
Groups didn't have my message up until much later so I couldn't reply
to it.
The fix was to add to the ReportServer Virtual Directory Application
Configuration Extension Mapping
Executable: C:\winnt\Microsoft.net\framework\v1.1.4322\apsnet_isapi.dll
Extension: *
Verbs: All Verbs
Script Engine: Checked
Once I added this, everything works like a charm.|||Hello. I have the same problem! Could you write some additional informations
how to solve this problem?
Regards
â'TnNytehawkâ' pisze:
> Found the fix to this a couple of hours after I posted, but Google
> Groups didn't have my message up until much later so I couldn't reply
> to it.
> The fix was to add to the ReportServer Virtual Directory Application
> Configuration Extension Mapping
> Executable: C:\winnt\Microsoft.net\framework\v1.1.4322\apsnet_isapi.dll
> Extension: *
> Verbs: All Verbs
> Script Engine: Checked
> Once I added this, everything works like a charm.
>

3rd party tool to create reports

Hi,
Does any one know of a 3rd party tool to create report definitions for SQL
Reporting Services so you don't have to use Visual Studio.NET?
Y/JakobUnless you have objections about how it creates it or how easy it is to
create it, all you need to have is any version of VS, which includes VB. I
believe it is possible to get something with VS that costs only $100. I
doubt you could purchase a report writer for less than that. $100 per
developer is pretty inexpensive.
Bruce L-C
"Jakob Olsen" <jaoss@.wmdata.com> wrote in message
news:OVlIKaDlEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Does any one know of a 3rd party tool to create report definitions for SQL
> Reporting Services so you don't have to use Visual Studio.NET?
> Y/Jakob
>|||There are some 3rd party tools listed at
http://www.microsoft.com/sql/reporting/partners/softwareapps.asp.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23C5JSLElEHA.592@.TK2MSFTNGP11.phx.gbl...
> Unless you have objections about how it creates it or how easy it is to
> create it, all you need to have is any version of VS, which includes VB. I
> believe it is possible to get something with VS that costs only $100. I
> doubt you could purchase a report writer for less than that. $100 per
> developer is pretty inexpensive.
> Bruce L-C
> "Jakob Olsen" <jaoss@.wmdata.com> wrote in message
> news:OVlIKaDlEHA.3520@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> Does any one know of a 3rd party tool to create report definitions for
>> SQL Reporting Services so you don't have to use Visual Studio.NET?
>> Y/Jakob
>