On my SQL 2000 server I can no longer view the server properties with
Enterprise manager.
The properties page just flashes up and disappears.
No errors in the Event logs.
Does anyone have any suggestions about how I might overcome the problem.
Regards Craig.I remember seeing this a while ago. What SQL Server service pack is
installed on this client? Could you upgrade it so that it matches the SP
version of server?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Craig Leslie" <craigl@.cil.com.au> wrote in message
news:utz2Y6nUDHA.1276@.TK2MSFTNGP09.phx.gbl...
On my SQL 2000 server I can no longer view the server properties with
Enterprise manager.
The properties page just flashes up and disappears.
No errors in the Event logs.
Does anyone have any suggestions about how I might overcome the problem.
Regards Craig.|||Hi Craig,
This issue maybe caused by the MSSQLServer service startup accout lacking
of permission to access some registry keys. You may try to add the startup
account to local admin group, and then stop and restart the service to see
if it works.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
William Wang
Microsoft Partner Online Support
--
| Reply-To: "Craig Leslie" <craigl@.cil.com.au>
| From: "Craig Leslie" <craigl@.cil.com.au>
| Subject: Exterprise manager
| Date: Fri, 25 Jul 2003 15:27:20 +0800
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <utz2Y6nUDHA.1276@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: cilfsrv1.cil.com.au 203.38.62.194
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:297767
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| On my SQL 2000 server I can no longer view the server properties with
| Enterprise manager.
|
| The properties page just flashes up and disappears.
|
| No errors in the Event logs.
|
| Does anyone have any suggestions about how I might overcome the problem.
|
| Regards Craig.
|
|
|
Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts
Tuesday, March 27, 2012
Exterpise Manager Select Export (ASCII,Excel,Access)?
Hi All. A client needs to send me some sample data. He has insisted he can query the table in Enterprise Manager via a simple select... "Select * from Table1"...
Now I need to get the data in some simple form (ASCII, Excel, Access, etc.) sent to me.
Can someone please provide me the info so I can pass it on for him to query a table from Enterprise Manager and "export it" to a simple file so I can receive it.
ANY THOUGHTS would be helpfull and GREATLY Appreciated!
Thanks.
BillIf this is a one timer I would go for "Tools -> Data Transformation Services -> Export Data".
// Pati|||Hey Pati... It may just be a one timer... but if the data looks good, it may be more frequent. it turns out some other process is taking records from this table, and may be removing them... Part of the reason we are trying to get some snapshots of the data.
I'm trying not to write an app until I know if we need this data.
Is it really simple to use to do the menu picks? Doesn't seem like the end user is very experienced, nor am I on Sql Server.
Thanks for the thoughts.
Bill|||If you think that you will need the same procedure again then you can save the DTS package for further use and then schedule it to run as desired.
...or then for another approach you could automate everything with scripts/scheduled jobs.
But as you're saying that you don't have much experience in SQL Server and that this might just be a one off solution then I would stick to DTS.
// Patisql
Now I need to get the data in some simple form (ASCII, Excel, Access, etc.) sent to me.
Can someone please provide me the info so I can pass it on for him to query a table from Enterprise Manager and "export it" to a simple file so I can receive it.
ANY THOUGHTS would be helpfull and GREATLY Appreciated!
Thanks.
BillIf this is a one timer I would go for "Tools -> Data Transformation Services -> Export Data".
// Pati|||Hey Pati... It may just be a one timer... but if the data looks good, it may be more frequent. it turns out some other process is taking records from this table, and may be removing them... Part of the reason we are trying to get some snapshots of the data.
I'm trying not to write an app until I know if we need this data.
Is it really simple to use to do the menu picks? Doesn't seem like the end user is very experienced, nor am I on Sql Server.
Thanks for the thoughts.
Bill|||If you think that you will need the same procedure again then you can save the DTS package for further use and then schedule it to run as desired.
...or then for another approach you could automate everything with scripts/scheduled jobs.
But as you're saying that you don't have much experience in SQL Server and that this might just be a one off solution then I would stick to DTS.
// Patisql
Monday, March 26, 2012
External image not displayed in report manager
Hello,
I have a problem and I don't know how to solve it. I hope you guy's
know.
I have a report with a external image which refers to a image on a
SharePoint intranet site. When I preview the report in visual studio
the image is visible. But when I deploy the report to the report server
the image is not displayed and a red cross is showing. I have already
set the execution account on the report server but still not working.
When I enter the URL of the image in the browser on the report server
the image is visible. I don't understand what I do wrong? Hope someone
knows!
I use reporting service 2005
Regards,
Robbert Visscher
HollandI had this problem once. I had to enable anonymous access to the
virtual directory for the images folder.
Not sure if that is what your problem is, but maybe...
-Josh
robbert wrote:
> Hello,
> I have a problem and I don't know how to solve it. I hope you guy's
> know.
> I have a report with a external image which refers to a image on a
> SharePoint intranet site. When I preview the report in visual studio
> the image is visible. But when I deploy the report to the report server
> the image is not displayed and a red cross is showing. I have already
> set the execution account on the report server but still not working.
> When I enter the URL of the image in the browser on the report server
> the image is visible. I don't understand what I do wrong? Hope someone
> knows!
> I use reporting service 2005
> Regards,
> Robbert Visscher
> Holland|||I'm not sure, read that this was fixed in RS 2000 sp1, seems like 2005
should handle it.
Found this:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/540b31cf8bab7cfe/33b1edc0dabb5354?lnk=st&q=Reporting+Services+2005+References+to+external+URLs&rnum=4&hl=en#33b1edc0dabb5354
btw, my wife is Dutch: deLeeuw, going to meet the family there for my first
time next spring.
Steve MunLeeuw
"robbert" <robbert_visscher@.hotmail.com> wrote in message
news:1155673109.459815.285790@.p79g2000cwp.googlegroups.com...
> Hello,
> I have a problem and I don't know how to solve it. I hope you guy's
> know.
> I have a report with a external image which refers to a image on a
> SharePoint intranet site. When I preview the report in visual studio
> the image is visible. But when I deploy the report to the report server
> the image is not displayed and a red cross is showing. I have already
> set the execution account on the report server but still not working.
> When I enter the URL of the image in the browser on the report server
> the image is visible. I don't understand what I do wrong? Hope someone
> knows!
> I use reporting service 2005
> Regards,
> Robbert Visscher
> Holland
>|||The image is on a Share Point site so the images are collected in a
Share Point database. But in my preview it works fine so I don't
understand why it not works in de report manager?|||Import(upload) the image file on to the report manger|||Thanks for your answer but it is not a good solution. It has to work
like this way. But why is it not working? It works fine in visual
studio. I have already read a lot of questions on the Internet about
this problem but no one can solve the problem. Maby it is a bug? I
think that the unattended execution account is not working with
reporting service 2005. I have already installed SP1 and the latest
hotfix. So does anyone know what it could be or confirm it is a Bug?
Regards,
Robbert
Holland|||Again, it sounds like a permission issue to me. When you try it using
the Preview tab, it is using your credentials. When it runs via Report
Manager, it does not use your credentials.
Does the ID that SSRS is running under have access to SharePoint?
-Josh
robbert wrote:
> Thanks for your answer but it is not a good solution. It has to work
> like this way. But why is it not working? It works fine in visual
> studio. I have already read a lot of questions on the Internet about
> this problem but no one can solve the problem. Maby it is a bug? I
> think that the unattended execution account is not working with
> reporting service 2005. I have already installed SP1 and the latest
> hotfix. So does anyone know what it could be or confirm it is a Bug?
> Regards,
> Robbert
> Holland|||Hello Josh,
Thanks for your answer! I have set the credentials in the report
manager which are the same as mine credentials. I have set the
unattended execution account and the Windows service identity as the
same I use in visual studio. Also when I acces the URL in the browser
the image is visible. I have access to the share point site because I
see the image in the browser. I hope you know a solution! Thanks!
Robbert
Holland
Josh schreef:
> Again, it sounds like a permission issue to me. When you try it using
> the Preview tab, it is using your credentials. When it runs via Report
> Manager, it does not use your credentials.
> Does the ID that SSRS is running under have access to SharePoint?
> -Josh
>
> robbert wrote:
> > Thanks for your answer but it is not a good solution. It has to work
> > like this way. But why is it not working? It works fine in visual
> > studio. I have already read a lot of questions on the Internet about
> > this problem but no one can solve the problem. Maby it is a bug? I
> > think that the unattended execution account is not working with
> > reporting service 2005. I have already installed SP1 and the latest
> > hotfix. So does anyone know what it could be or confirm it is a Bug?
> >
> > Regards,
> >
> > Robbert
> > Holland|||Robbert,
And you enabled anonymous access on that sharepoint site?
-Josh
robbert wrote:
> Hello Josh,
> Thanks for your answer! I have set the credentials in the report
> manager which are the same as mine credentials. I have set the
> unattended execution account and the Windows service identity as the
> same I use in visual studio. Also when I acces the URL in the browser
> the image is visible. I have access to the share point site because I
> see the image in the browser. I hope you know a solution! Thanks!
> Robbert
> Holland
> Josh schreef:
> > Again, it sounds like a permission issue to me. When you try it using
> > the Preview tab, it is using your credentials. When it runs via Report
> > Manager, it does not use your credentials.
> >
> > Does the ID that SSRS is running under have access to SharePoint?
> >
> > -Josh
> >
> >
> > robbert wrote:
> > > Thanks for your answer but it is not a good solution. It has to work
> > > like this way. But why is it not working? It works fine in visual
> > > studio. I have already read a lot of questions on the Internet about
> > > this problem but no one can solve the problem. Maby it is a bug? I
> > > think that the unattended execution account is not working with
> > > reporting service 2005. I have already installed SP1 and the latest
> > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > >
> > > Regards,
> > >
> > > Robbert
> > > Holland|||Helle Josh,
Anonymous acces we can not enabled that because of security. But i have
set a unattended execution account so I dont need that right?
Robbert
Josh schreef:
> Robbert,
> And you enabled anonymous access on that sharepoint site?
> -Josh
>
> robbert wrote:
> > Hello Josh,
> >
> > Thanks for your answer! I have set the credentials in the report
> > manager which are the same as mine credentials. I have set the
> > unattended execution account and the Windows service identity as the
> > same I use in visual studio. Also when I acces the URL in the browser
> > the image is visible. I have access to the share point site because I
> > see the image in the browser. I hope you know a solution! Thanks!
> >
> > Robbert
> > Holland
> >
> > Josh schreef:
> >
> > > Again, it sounds like a permission issue to me. When you try it using
> > > the Preview tab, it is using your credentials. When it runs via Report
> > > Manager, it does not use your credentials.
> > >
> > > Does the ID that SSRS is running under have access to SharePoint?
> > >
> > > -Josh
> > >
> > >
> > > robbert wrote:
> > > > Thanks for your answer but it is not a good solution. It has to work
> > > > like this way. But why is it not working? It works fine in visual
> > > > studio. I have already read a lot of questions on the Internet about
> > > > this problem but no one can solve the problem. Maby it is a bug? I
> > > > think that the unattended execution account is not working with
> > > > reporting service 2005. I have already installed SP1 and the latest
> > > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > > >
> > > > Regards,
> > > >
> > > > Robbert
> > > > Holland|||When I added an "external" image to a report (using a URL as the image
source), I received a warning stating that images would not display
correctly unless an unattended execution account or anonymous access
was configured. Because this was an "OR", I am assuming that you only
need 1 or the other.
My thought was to enable anonymous access, try your report, and disable
anonymous again, just to see if that solves the problem.
Sorry I can't be of more help.
-Josh
robbert wrote:
> Helle Josh,
> Anonymous acces we can not enabled that because of security. But i have
> set a unattended execution account so I dont need that right?
> Robbert
> Josh schreef:
> > Robbert,
> >
> > And you enabled anonymous access on that sharepoint site?
> >
> > -Josh
> >
> >
> >
> > robbert wrote:
> > > Hello Josh,
> > >
> > > Thanks for your answer! I have set the credentials in the report
> > > manager which are the same as mine credentials. I have set the
> > > unattended execution account and the Windows service identity as the
> > > same I use in visual studio. Also when I acces the URL in the browser
> > > the image is visible. I have access to the share point site because I
> > > see the image in the browser. I hope you know a solution! Thanks!
> > >
> > > Robbert
> > > Holland
> > >
> > > Josh schreef:
> > >
> > > > Again, it sounds like a permission issue to me. When you try it using
> > > > the Preview tab, it is using your credentials. When it runs via Report
> > > > Manager, it does not use your credentials.
> > > >
> > > > Does the ID that SSRS is running under have access to SharePoint?
> > > >
> > > > -Josh
> > > >
> > > >
> > > > robbert wrote:
> > > > > Thanks for your answer but it is not a good solution. It has to work
> > > > > like this way. But why is it not working? It works fine in visual
> > > > > studio. I have already read a lot of questions on the Internet about
> > > > > this problem but no one can solve the problem. Maby it is a bug? I
> > > > > think that the unattended execution account is not working with
> > > > > reporting service 2005. I have already installed SP1 and the latest
> > > > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > > > >
> > > > > Regards,
> > > > >
> > > > > Robbert
> > > > > Holland|||I had the same problem. The image i was originally trying to access was a
bitmap file. I re-saved it as a jpeg and then it worked fine.
robbert wrote:
>Hello,
>I have a problem and I don't know how to solve it. I hope you guy's
>know.
>I have a report with a external image which refers to a image on a
>SharePoint intranet site. When I preview the report in visual studio
>the image is visible. But when I deploy the report to the report server
>the image is not displayed and a red cross is showing. I have already
>set the execution account on the report server but still not working.
>When I enter the URL of the image in the browser on the report server
>the image is visible. I don't understand what I do wrong? Hope someone
>knows!
>I use reporting service 2005
>Regards,
>Robbert Visscher
>Holland|||It are jpeg files and they work in visual studio. The problem still is
that i get red crosses in the report manager. I don't understand it.
IanGregson schreef:
> I had the same problem. The image i was originally trying to access was a
> bitmap file. I re-saved it as a jpeg and then it worked fine.
> robbert wrote:
> >Hello,
> >
> >I have a problem and I don't know how to solve it. I hope you guy's
> >know.
> >
> >I have a report with a external image which refers to a image on a
> >SharePoint intranet site. When I preview the report in visual studio
> >the image is visible. But when I deploy the report to the report server
> >the image is not displayed and a red cross is showing. I have already
> >set the execution account on the report server but still not working.
> >When I enter the URL of the image in the browser on the report server
> >the image is visible. I don't understand what I do wrong? Hope someone
> >knows!
> >
> >I use reporting service 2005
> >
> >Regards,
> >
> >Robbert Visscher
> >Holland
I have a problem and I don't know how to solve it. I hope you guy's
know.
I have a report with a external image which refers to a image on a
SharePoint intranet site. When I preview the report in visual studio
the image is visible. But when I deploy the report to the report server
the image is not displayed and a red cross is showing. I have already
set the execution account on the report server but still not working.
When I enter the URL of the image in the browser on the report server
the image is visible. I don't understand what I do wrong? Hope someone
knows!
I use reporting service 2005
Regards,
Robbert Visscher
HollandI had this problem once. I had to enable anonymous access to the
virtual directory for the images folder.
Not sure if that is what your problem is, but maybe...
-Josh
robbert wrote:
> Hello,
> I have a problem and I don't know how to solve it. I hope you guy's
> know.
> I have a report with a external image which refers to a image on a
> SharePoint intranet site. When I preview the report in visual studio
> the image is visible. But when I deploy the report to the report server
> the image is not displayed and a red cross is showing. I have already
> set the execution account on the report server but still not working.
> When I enter the URL of the image in the browser on the report server
> the image is visible. I don't understand what I do wrong? Hope someone
> knows!
> I use reporting service 2005
> Regards,
> Robbert Visscher
> Holland|||I'm not sure, read that this was fixed in RS 2000 sp1, seems like 2005
should handle it.
Found this:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/540b31cf8bab7cfe/33b1edc0dabb5354?lnk=st&q=Reporting+Services+2005+References+to+external+URLs&rnum=4&hl=en#33b1edc0dabb5354
btw, my wife is Dutch: deLeeuw, going to meet the family there for my first
time next spring.
Steve MunLeeuw
"robbert" <robbert_visscher@.hotmail.com> wrote in message
news:1155673109.459815.285790@.p79g2000cwp.googlegroups.com...
> Hello,
> I have a problem and I don't know how to solve it. I hope you guy's
> know.
> I have a report with a external image which refers to a image on a
> SharePoint intranet site. When I preview the report in visual studio
> the image is visible. But when I deploy the report to the report server
> the image is not displayed and a red cross is showing. I have already
> set the execution account on the report server but still not working.
> When I enter the URL of the image in the browser on the report server
> the image is visible. I don't understand what I do wrong? Hope someone
> knows!
> I use reporting service 2005
> Regards,
> Robbert Visscher
> Holland
>|||The image is on a Share Point site so the images are collected in a
Share Point database. But in my preview it works fine so I don't
understand why it not works in de report manager?|||Import(upload) the image file on to the report manger|||Thanks for your answer but it is not a good solution. It has to work
like this way. But why is it not working? It works fine in visual
studio. I have already read a lot of questions on the Internet about
this problem but no one can solve the problem. Maby it is a bug? I
think that the unattended execution account is not working with
reporting service 2005. I have already installed SP1 and the latest
hotfix. So does anyone know what it could be or confirm it is a Bug?
Regards,
Robbert
Holland|||Again, it sounds like a permission issue to me. When you try it using
the Preview tab, it is using your credentials. When it runs via Report
Manager, it does not use your credentials.
Does the ID that SSRS is running under have access to SharePoint?
-Josh
robbert wrote:
> Thanks for your answer but it is not a good solution. It has to work
> like this way. But why is it not working? It works fine in visual
> studio. I have already read a lot of questions on the Internet about
> this problem but no one can solve the problem. Maby it is a bug? I
> think that the unattended execution account is not working with
> reporting service 2005. I have already installed SP1 and the latest
> hotfix. So does anyone know what it could be or confirm it is a Bug?
> Regards,
> Robbert
> Holland|||Hello Josh,
Thanks for your answer! I have set the credentials in the report
manager which are the same as mine credentials. I have set the
unattended execution account and the Windows service identity as the
same I use in visual studio. Also when I acces the URL in the browser
the image is visible. I have access to the share point site because I
see the image in the browser. I hope you know a solution! Thanks!
Robbert
Holland
Josh schreef:
> Again, it sounds like a permission issue to me. When you try it using
> the Preview tab, it is using your credentials. When it runs via Report
> Manager, it does not use your credentials.
> Does the ID that SSRS is running under have access to SharePoint?
> -Josh
>
> robbert wrote:
> > Thanks for your answer but it is not a good solution. It has to work
> > like this way. But why is it not working? It works fine in visual
> > studio. I have already read a lot of questions on the Internet about
> > this problem but no one can solve the problem. Maby it is a bug? I
> > think that the unattended execution account is not working with
> > reporting service 2005. I have already installed SP1 and the latest
> > hotfix. So does anyone know what it could be or confirm it is a Bug?
> >
> > Regards,
> >
> > Robbert
> > Holland|||Robbert,
And you enabled anonymous access on that sharepoint site?
-Josh
robbert wrote:
> Hello Josh,
> Thanks for your answer! I have set the credentials in the report
> manager which are the same as mine credentials. I have set the
> unattended execution account and the Windows service identity as the
> same I use in visual studio. Also when I acces the URL in the browser
> the image is visible. I have access to the share point site because I
> see the image in the browser. I hope you know a solution! Thanks!
> Robbert
> Holland
> Josh schreef:
> > Again, it sounds like a permission issue to me. When you try it using
> > the Preview tab, it is using your credentials. When it runs via Report
> > Manager, it does not use your credentials.
> >
> > Does the ID that SSRS is running under have access to SharePoint?
> >
> > -Josh
> >
> >
> > robbert wrote:
> > > Thanks for your answer but it is not a good solution. It has to work
> > > like this way. But why is it not working? It works fine in visual
> > > studio. I have already read a lot of questions on the Internet about
> > > this problem but no one can solve the problem. Maby it is a bug? I
> > > think that the unattended execution account is not working with
> > > reporting service 2005. I have already installed SP1 and the latest
> > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > >
> > > Regards,
> > >
> > > Robbert
> > > Holland|||Helle Josh,
Anonymous acces we can not enabled that because of security. But i have
set a unattended execution account so I dont need that right?
Robbert
Josh schreef:
> Robbert,
> And you enabled anonymous access on that sharepoint site?
> -Josh
>
> robbert wrote:
> > Hello Josh,
> >
> > Thanks for your answer! I have set the credentials in the report
> > manager which are the same as mine credentials. I have set the
> > unattended execution account and the Windows service identity as the
> > same I use in visual studio. Also when I acces the URL in the browser
> > the image is visible. I have access to the share point site because I
> > see the image in the browser. I hope you know a solution! Thanks!
> >
> > Robbert
> > Holland
> >
> > Josh schreef:
> >
> > > Again, it sounds like a permission issue to me. When you try it using
> > > the Preview tab, it is using your credentials. When it runs via Report
> > > Manager, it does not use your credentials.
> > >
> > > Does the ID that SSRS is running under have access to SharePoint?
> > >
> > > -Josh
> > >
> > >
> > > robbert wrote:
> > > > Thanks for your answer but it is not a good solution. It has to work
> > > > like this way. But why is it not working? It works fine in visual
> > > > studio. I have already read a lot of questions on the Internet about
> > > > this problem but no one can solve the problem. Maby it is a bug? I
> > > > think that the unattended execution account is not working with
> > > > reporting service 2005. I have already installed SP1 and the latest
> > > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > > >
> > > > Regards,
> > > >
> > > > Robbert
> > > > Holland|||When I added an "external" image to a report (using a URL as the image
source), I received a warning stating that images would not display
correctly unless an unattended execution account or anonymous access
was configured. Because this was an "OR", I am assuming that you only
need 1 or the other.
My thought was to enable anonymous access, try your report, and disable
anonymous again, just to see if that solves the problem.
Sorry I can't be of more help.
-Josh
robbert wrote:
> Helle Josh,
> Anonymous acces we can not enabled that because of security. But i have
> set a unattended execution account so I dont need that right?
> Robbert
> Josh schreef:
> > Robbert,
> >
> > And you enabled anonymous access on that sharepoint site?
> >
> > -Josh
> >
> >
> >
> > robbert wrote:
> > > Hello Josh,
> > >
> > > Thanks for your answer! I have set the credentials in the report
> > > manager which are the same as mine credentials. I have set the
> > > unattended execution account and the Windows service identity as the
> > > same I use in visual studio. Also when I acces the URL in the browser
> > > the image is visible. I have access to the share point site because I
> > > see the image in the browser. I hope you know a solution! Thanks!
> > >
> > > Robbert
> > > Holland
> > >
> > > Josh schreef:
> > >
> > > > Again, it sounds like a permission issue to me. When you try it using
> > > > the Preview tab, it is using your credentials. When it runs via Report
> > > > Manager, it does not use your credentials.
> > > >
> > > > Does the ID that SSRS is running under have access to SharePoint?
> > > >
> > > > -Josh
> > > >
> > > >
> > > > robbert wrote:
> > > > > Thanks for your answer but it is not a good solution. It has to work
> > > > > like this way. But why is it not working? It works fine in visual
> > > > > studio. I have already read a lot of questions on the Internet about
> > > > > this problem but no one can solve the problem. Maby it is a bug? I
> > > > > think that the unattended execution account is not working with
> > > > > reporting service 2005. I have already installed SP1 and the latest
> > > > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > > > >
> > > > > Regards,
> > > > >
> > > > > Robbert
> > > > > Holland|||I had the same problem. The image i was originally trying to access was a
bitmap file. I re-saved it as a jpeg and then it worked fine.
robbert wrote:
>Hello,
>I have a problem and I don't know how to solve it. I hope you guy's
>know.
>I have a report with a external image which refers to a image on a
>SharePoint intranet site. When I preview the report in visual studio
>the image is visible. But when I deploy the report to the report server
>the image is not displayed and a red cross is showing. I have already
>set the execution account on the report server but still not working.
>When I enter the URL of the image in the browser on the report server
>the image is visible. I don't understand what I do wrong? Hope someone
>knows!
>I use reporting service 2005
>Regards,
>Robbert Visscher
>Holland|||It are jpeg files and they work in visual studio. The problem still is
that i get red crosses in the report manager. I don't understand it.
IanGregson schreef:
> I had the same problem. The image i was originally trying to access was a
> bitmap file. I re-saved it as a jpeg and then it worked fine.
> robbert wrote:
> >Hello,
> >
> >I have a problem and I don't know how to solve it. I hope you guy's
> >know.
> >
> >I have a report with a external image which refers to a image on a
> >SharePoint intranet site. When I preview the report in visual studio
> >the image is visible. But when I deploy the report to the report server
> >the image is not displayed and a red cross is showing. I have already
> >set the execution account on the report server but still not working.
> >When I enter the URL of the image in the browser on the report server
> >the image is visible. I don't understand what I do wrong? Hope someone
> >knows!
> >
> >I use reporting service 2005
> >
> >Regards,
> >
> >Robbert Visscher
> >Holland
Thursday, March 22, 2012
Extending Management Studio
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management Studio. If ISVs (independent software vendors) could plug their SQL Server tool(s) into Management Studio – creating a single environment for you to work in – which tools do you use that you’d like to see surfaced in Management Studio.
Dan
DBGhost by Innovartis.It would be extremely nice to be able to compile, check in, and check out changes on the fly from within SQLMS.
Also, IntelliSense would be very nice. Apex SQL Edit has their own, however I like the VS / SQLMS interface better.|||Thanks for the feedback. IntelliSense is soemthing we're looking into. A different group owns this so I don't know the latest for it. Its addition would improve greatly productivity.
Dan|||RedGates SQL Compare and Data Compare tools would be very helpful for those of us that manage seperate Dev, UAT and Production enviroments.
Allison|||Could we get the Query Analyzer from SS 2000?
Please.|||Sessionless analysis of current operations available in Quest's Spotlight. It was explained to me as directly analysing the memory (whitesapaces) being used by SQL Server.|||G'day Dan.
Are you asking which elements of the Management Studio we would like to see exposed to extensibility? If so, I have a list! ;-) I am an ISV start-up with a potentially "killer app" (aren't they all lol) and the lack of extensibility is crippling...
Cheers,
Paul McMahon
Xavier Ltd|||Hi Paul,
That's a slightly different question than what I'm asking, however, it is very relevant. Let's chat as I'd love to get your list - you can reach me at dan.jones@.microsoft.com.
Cheers,
Dan|||I think it would be cool to have PromptSQL integrated into Management Studio to give SQL Intellisense inside Management Studio :-)
But then I would say that.|||With respect to QA 2000, what is lacking in SSMS 2005 that you would want added?
Extending Management Studio
Hi There,
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio creating a single environment for you to
work in which tools do you use that youd like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform Team
Red Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>
|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio – creating a single environment for you to
> work in – which tools do you use that you’d like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>
sql
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio creating a single environment for you to
work in which tools do you use that youd like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform Team
Red Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>
|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio – creating a single environment for you to
> work in – which tools do you use that you’d like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>
sql
Extending Management Studio
Hi There,
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio ? creating a single environment for you to
work in ? which tools do you use that you?d like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform TeamRed Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else :)
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else :)
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>> Hi There,
>> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
>> Management
>> Studio. If ISVs (independent software vendors) could plug their SQL
>> Server
>> tool(s) into Management Studio - creating a single environment for you to
>> work in - which tools do you use that you'd like to see surfaced in
>> Management Studio.
>> Cheers,
>> Dan
>> Lead PM
>> SQL Server Management Platform Team
>|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio â' creating a single environment for you to
> work in â' which tools do you use that youâ'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio ? creating a single environment for you to
work in ? which tools do you use that you?d like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform TeamRed Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else :)
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else :)
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>> Hi There,
>> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
>> Management
>> Studio. If ISVs (independent software vendors) could plug their SQL
>> Server
>> tool(s) into Management Studio - creating a single environment for you to
>> work in - which tools do you use that you'd like to see surfaced in
>> Management Studio.
>> Cheers,
>> Dan
>> Lead PM
>> SQL Server Management Platform Team
>|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio â' creating a single environment for you to
> work in â' which tools do you use that youâ'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>
Extending Management Studio
Hi There,
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Managemen
t
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio creating a single environment for you to
work in which tools do you use that youd like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform TeamRed Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Managem
ent
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio – creating a single environment for you t
o
> work in – which tools do you use that you’d like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Managemen
t
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio creating a single environment for you to
work in which tools do you use that youd like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform TeamRed Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Managem
ent
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio – creating a single environment for you t
o
> work in – which tools do you use that you’d like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>
Wednesday, March 21, 2012
Extended Stored Procedures
The database I am setting up requires a dll file to be added to extended
stored prcoedures - "Using a Microsoft tool such as Enterprise Manager, add
the file to the extended stored prcoedures already installed on SQL Server."
Where/how is this done?
Thank you.
Regards,
DianeYou can run a query like the one below from Query Analyzer. See the Books
Online for more information.
EXEC sp_addextendedproc 'MyFunction', 'MyApp.dll'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:508ECDA1-08D8-4593-BAF8-628108DDFF0B@.microsoft.com...
> The database I am setting up requires a dll file to be added to extended
> stored prcoedures - "Using a Microsoft tool such as Enterprise Manager,
> add
> the file to the extended stored prcoedures already installed on SQL
> Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane|||Diane wrote:
> The database I am setting up requires a dll file to be added to
> extended stored prcoedures - "Using a Microsoft tool such as
> Enterprise Manager, add the file to the extended stored prcoedures
> already installed on SQL Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
See "sp_addextendedproc" and "Creating Extended Stored Procedures" in
BOL.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
stored prcoedures - "Using a Microsoft tool such as Enterprise Manager, add
the file to the extended stored prcoedures already installed on SQL Server."
Where/how is this done?
Thank you.
Regards,
DianeYou can run a query like the one below from Query Analyzer. See the Books
Online for more information.
EXEC sp_addextendedproc 'MyFunction', 'MyApp.dll'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:508ECDA1-08D8-4593-BAF8-628108DDFF0B@.microsoft.com...
> The database I am setting up requires a dll file to be added to extended
> stored prcoedures - "Using a Microsoft tool such as Enterprise Manager,
> add
> the file to the extended stored prcoedures already installed on SQL
> Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane|||Diane wrote:
> The database I am setting up requires a dll file to be added to
> extended stored prcoedures - "Using a Microsoft tool such as
> Enterprise Manager, add the file to the extended stored prcoedures
> already installed on SQL Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
See "sp_addextendedproc" and "Creating Extended Stored Procedures" in
BOL.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
Extended Stored Procedures
The database I am setting up requires a dll file to be added to extended
stored prcoedures - "Using a Microsoft tool such as Enterprise Manager, add
the file to the extended stored prcoedures already installed on SQL Server."
Where/how is this done?
Thank you.
Regards,
DianeYou can run a query like the one below from Query Analyzer. See the Books
Online for more information.
EXEC sp_addextendedproc 'MyFunction', 'MyApp.dll'
Hope this helps.
Dan Guzman
SQL Server MVP
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:508ECDA1-08D8-4593-BAF8-628108DDFF0B@.microsoft.com...
> The database I am setting up requires a dll file to be added to extended
> stored prcoedures - "Using a Microsoft tool such as Enterprise Manager,
> add
> the file to the extended stored prcoedures already installed on SQL
> Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane|||Diane wrote:
> The database I am setting up requires a dll file to be added to
> extended stored prcoedures - "Using a Microsoft tool such as
> Enterprise Manager, add the file to the extended stored prcoedures
> already installed on SQL Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
See "sp_addextendedproc" and "Creating Extended Stored Procedures" in
BOL.
David Gugick
Quest Software
www.imceda.com
www.quest.com
stored prcoedures - "Using a Microsoft tool such as Enterprise Manager, add
the file to the extended stored prcoedures already installed on SQL Server."
Where/how is this done?
Thank you.
Regards,
DianeYou can run a query like the one below from Query Analyzer. See the Books
Online for more information.
EXEC sp_addextendedproc 'MyFunction', 'MyApp.dll'
Hope this helps.
Dan Guzman
SQL Server MVP
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:508ECDA1-08D8-4593-BAF8-628108DDFF0B@.microsoft.com...
> The database I am setting up requires a dll file to be added to extended
> stored prcoedures - "Using a Microsoft tool such as Enterprise Manager,
> add
> the file to the extended stored prcoedures already installed on SQL
> Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane|||Diane wrote:
> The database I am setting up requires a dll file to be added to
> extended stored prcoedures - "Using a Microsoft tool such as
> Enterprise Manager, add the file to the extended stored prcoedures
> already installed on SQL Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
See "sp_addextendedproc" and "Creating Extended Stored Procedures" in
BOL.
David Gugick
Quest Software
www.imceda.com
www.quest.com
Extended Stored Procedures
The database I am setting up requires a dll file to be added to extended
stored prcoedures - "Using a Microsoft tool such as Enterprise Manager, add
the file to the extended stored prcoedures already installed on SQL Server."
Where/how is this done?
Thank you.
Regards,
Diane
You can run a query like the one below from Query Analyzer. See the Books
Online for more information.
EXEC sp_addextendedproc 'MyFunction', 'MyApp.dll'
Hope this helps.
Dan Guzman
SQL Server MVP
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:508ECDA1-08D8-4593-BAF8-628108DDFF0B@.microsoft.com...
> The database I am setting up requires a dll file to be added to extended
> stored prcoedures - "Using a Microsoft tool such as Enterprise Manager,
> add
> the file to the extended stored prcoedures already installed on SQL
> Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
|||Diane wrote:
> The database I am setting up requires a dll file to be added to
> extended stored prcoedures - "Using a Microsoft tool such as
> Enterprise Manager, add the file to the extended stored prcoedures
> already installed on SQL Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
See "sp_addextendedproc" and "Creating Extended Stored Procedures" in
BOL.
David Gugick
Quest Software
www.imceda.com
www.quest.com
sql
stored prcoedures - "Using a Microsoft tool such as Enterprise Manager, add
the file to the extended stored prcoedures already installed on SQL Server."
Where/how is this done?
Thank you.
Regards,
Diane
You can run a query like the one below from Query Analyzer. See the Books
Online for more information.
EXEC sp_addextendedproc 'MyFunction', 'MyApp.dll'
Hope this helps.
Dan Guzman
SQL Server MVP
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:508ECDA1-08D8-4593-BAF8-628108DDFF0B@.microsoft.com...
> The database I am setting up requires a dll file to be added to extended
> stored prcoedures - "Using a Microsoft tool such as Enterprise Manager,
> add
> the file to the extended stored prcoedures already installed on SQL
> Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
|||Diane wrote:
> The database I am setting up requires a dll file to be added to
> extended stored prcoedures - "Using a Microsoft tool such as
> Enterprise Manager, add the file to the extended stored prcoedures
> already installed on SQL Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
See "sp_addextendedproc" and "Creating Extended Stored Procedures" in
BOL.
David Gugick
Quest Software
www.imceda.com
www.quest.com
sql
Monday, March 19, 2012
Extended Stored Procedure
Dear Mike
I've created this sp through Enterprise Manager. and when I execute
sp_addextendedProc it show me Error message:
Server: Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 26
There is already an object named 'xp_Session' in the database.Why would you execute sp_addextendedproc if you've already added it? You
only need to add the xp once.
http://www.aspfaq.com/
(Reverse address to reply.)
"mtgoli" <mtgoli@.discussions.microsoft.com> wrote in message
news:E42A61D7-41F7-490A-899E-EDAA6996256A@.microsoft.com...
> Dear Mike
> I've created this sp through Enterprise Manager. and when I execute
> sp_addextendedProc it show me Error message:
> Server: Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 26
> There is already an object named 'xp_Session' in the database.
>
I've created this sp through Enterprise Manager. and when I execute
sp_addextendedProc it show me Error message:
Server: Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 26
There is already an object named 'xp_Session' in the database.Why would you execute sp_addextendedproc if you've already added it? You
only need to add the xp once.
http://www.aspfaq.com/
(Reverse address to reply.)
"mtgoli" <mtgoli@.discussions.microsoft.com> wrote in message
news:E42A61D7-41F7-490A-899E-EDAA6996256A@.microsoft.com...
> Dear Mike
> I've created this sp through Enterprise Manager. and when I execute
> sp_addextendedProc it show me Error message:
> Server: Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 26
> There is already an object named 'xp_Session' in the database.
>
Monday, March 12, 2012
extended connection managers for data flow destinations?
It looks like you can only extended connection managers for data flow sources.
Is there anyway to develop a custom connection manager for the SQL destination in the data flow destinations?
I can’t use hardcoded connection strings.I can’t use configurations because they are not encrypted.I already have managed code that will give the corrected connection string.I already have a custom connection manager that I use from the data flow sources.I just need one for data flow destinations but I can’t see a way to extend into the OLE DB?
The OLEDB Destination is just like the OLEDB source and can use the same connection managers. However, you are using the SQL destination and that is a special destination and needs the specific connection manager that it supports. If you want to use your custom connection manager then switch to using the OLEDB destination instead and it should just work.
HTH,
Matt
|||oledb destinations only support the special destinations as well. there is no way I can see to use a custom connection manger in any of the destinations.
except for the script component and in that you can do whatever you want.
|||Actually they support anything they see as an OLEDB connection. I can create different types of OLEDB connections and the OLEDB destination will support them (e.g. excel, sql (sqlncli), sql (sqloledb), etc). It does indeed have to be an OLEDB type connection though.
Matt
|||ok so I think you might have answered my question.
If I develop a custom connection mgr derived from connectionmanagerbase I can't use that custom connection mgr with any of the stock data flow destinations.
because only OLEDB connections can be used and there is no way to create a custom OLEDB connection.
so there is no way to do what I wanted to do.
except the script componet can do what I want but I have to override the correct portions....
|||Well there are ways to create custom OLEDB connections but you would have to write your own OLEDB provider, which not many would want to do so I guess in your case a script would probably be the best alternative.
Matt
Friday, March 9, 2012
expression to get CreatedBy, CreationDate, ModifiedBy, and ModifiedDate properties for report?
If you look at the General Properties for a report in Report Manager, there are 4 properties listed at the top:
What I'm looking for is if there's a way to retrieve these properties via an expression from a textbox within a report. For instance, there's already an expression that is:
=Globals!ReportName
I know it won't be that easy for the CreatedBy, CreationDate, ModifiedBy, and ModifiedDate properties, but I thought I'd ask if there was a workaround or hack.
We're wanting to put that info into the footer of all our reports. (Actually this is for Report Builder reports, but you can still use expressions in Report Builder reports, so it should apply as it would to normal reports.)
Hi Greg,
I don't believe any of that information is stored in the RDL itself. The only way I know to get that information is to query the ReportServer database, similar to:
SELECT [ModifiedDate]
,[Modified].[UserName]
,[CreationDate]
,[Created].[UserName]
FROM [ReportServer].[dbo].[Catalog]
INNERJOIN [ReportServer].[dbo].[Users] as [Modified] ON [Catalog].[ModifiedByID] = [Modified].[UserID]
INNERJOIN [ReportServer].[dbo].[Users] as [Created] ON [Catalog].[CreatedByID] = [Created].[UserID]
WHERE [Catalog].Name =Globals!ReportName.Value
Then you can access those fields from the dataset.
HTH,
Jessica
Sunday, February 26, 2012
Express Manager for Sept CTP
Does anyone know if there will be a version of Sql Express Manager (XM) for the September CTP?
Regards
Graham
There will not, no|||Any idea of what product will replace it?|||A lite version of Management Studio.|||Good to know. Thanks.
Scott
Express Manager for Sept CTP
Does anyone know if there will be a version of Sql Express Manager (XM) for the September CTP?
Regards
Graham
There will not, no|||Any idea of what product will replace it?|||A lite version of Management Studio.|||Good to know. Thanks.
Scott
Express Manager download for RTM version of SQLServer Express
Has MS updated the Express Manager tool for the RTM version of SQLServer Express? It's a great tool and not having it causes so much pain (I have to use the command line tools!).
Thanks in advance!We're working on an update to the Express Manager. We expect to release a Community Technology Preview of it by the end of the year. In the mean time your options are to use the command line tools, use Visual Studio, or acquire the Developer or Evaluation Editions of SQL Server 2005 and use the full-blown Management Studio.
Dan|||I tried to install the client tools from SQL Server 2005 developer edition but the installer for this (after downloading another 2.8GB!) says components are already installed and cannot be upgraded (or message similar to this).
I'll use the command line tools I guess
Thanks anyways!
Express Manager / Management Studio Express
When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.
You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.
A few things to be aware of:
First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.
Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.
Dave
Retired SQL Sever DBA with 35+ years experience|||
Hi there.
I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?
I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?
Many thanks in advance,
Chris
By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.
|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||That's great. Thanks for your help.
Chris
|||I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?
|||There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.
Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.
Regards,
Steve
|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.Express Manager
Hi all,
I've just downloaded SQL Server 2005 Express and I'm wondering what's
happened to Express Manager? Apparently it's meant to be available as
a separate download? Is it even available yet and if not when's it
likely to be out?
Cheers,
Simon
hi Simon,
"Simon Johnson" <simon.johnson@.gmail.com> ha scritto nel messaggio
news:f03d8ae0.0409050700.59b2916d@.posting.google.c om...
> Hi all,
> I've just downloaded SQL Server 2005 Express and I'm wondering what's
> happened to Express Manager? Apparently it's meant to be available as
> a separate download? Is it even available yet and if not when's it
> likely to be out?
eXpress Manager will be available for download in the next future... at the
moment you can resort on a free Query Analyzer replacement you can get for
free at http://www.tegels.org/qara/#dl
please post messages about SQLExpress and SQL Server 2005 in the related
beta newsgroup
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||> eXpress Manager will be available for download in the next future... at the
> moment you can resort on a free Query Analyzer replacement you can get for
> free at http://www.tegels.org/qara/#dl
> please post messages about SQLExpress and SQL Server 2005 in the related
> beta newsgroup
Thanks very much.. What's the full name to the beta newsgroups?
Cheers,
Simon.
|||hi Simon,
"Simon Johnson" <simon.johnson@.gmail.com> ha scritto nel messaggio
news:f03d8ae0.0409060016.79e31247@.posting.google.c om...[vbcol=seagreen]
the[vbcol=seagreen]
for
> Thanks very much.. What's the full name to the beta newsgroups?
>
please go to
http://communities.microsoft.com/new...r2005&slcid=us
additional inforamation are provided to access the NGs via Outlook too
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I've just downloaded SQL Server 2005 Express and I'm wondering what's
happened to Express Manager? Apparently it's meant to be available as
a separate download? Is it even available yet and if not when's it
likely to be out?
Cheers,
Simon
hi Simon,
"Simon Johnson" <simon.johnson@.gmail.com> ha scritto nel messaggio
news:f03d8ae0.0409050700.59b2916d@.posting.google.c om...
> Hi all,
> I've just downloaded SQL Server 2005 Express and I'm wondering what's
> happened to Express Manager? Apparently it's meant to be available as
> a separate download? Is it even available yet and if not when's it
> likely to be out?
eXpress Manager will be available for download in the next future... at the
moment you can resort on a free Query Analyzer replacement you can get for
free at http://www.tegels.org/qara/#dl
please post messages about SQLExpress and SQL Server 2005 in the related
beta newsgroup
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||> eXpress Manager will be available for download in the next future... at the
> moment you can resort on a free Query Analyzer replacement you can get for
> free at http://www.tegels.org/qara/#dl
> please post messages about SQLExpress and SQL Server 2005 in the related
> beta newsgroup
Thanks very much.. What's the full name to the beta newsgroups?
Cheers,
Simon.
|||hi Simon,
"Simon Johnson" <simon.johnson@.gmail.com> ha scritto nel messaggio
news:f03d8ae0.0409060016.79e31247@.posting.google.c om...[vbcol=seagreen]
the[vbcol=seagreen]
for
> Thanks very much.. What's the full name to the beta newsgroups?
>
please go to
http://communities.microsoft.com/new...r2005&slcid=us
additional inforamation are provided to access the NGs via Outlook too
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Express Manager
When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.
You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.
A few things to be aware of:
First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.
Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.
Dave
Retired SQL Sever DBA with 35+ years experience|||
Hi there.
I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?
I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?
Many thanks in advance,
Chris
By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.
|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||That's great. Thanks for your help.
Chris
|||I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?
|||There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.
Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.
Regards,
Steve
|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.Express Manager
When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.
You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.
A few things to be aware of:
First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.
Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.
Dave
Retired SQL Sever DBA with 35+ years experience|||
Hi there.
I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?
I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?
Many thanks in advance,
Chris
By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.
|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||That's great. Thanks for your help.
Chris
|||I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?
|||There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.
Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.
Regards,
Steve
|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.
Subscribe to:
Posts (Atom)