microsoft sql server 2005 along with the microsoft visual studio 2005

Hello everyone, I'm in need of help.
I'm using microsoft sql server 2005 along with the microsoft visual studio
2005. I have 2 questions:
1) In the database server, there is an "image" datatype. I need to know how
to use that because I need to display images on my webform.
2) I read somewhere that pointers can be used to point the file path. So, is
it possible for me to store images / audios in a file and use the database to
point to the file path? If it is possible, how can it be done?
Thanks.
--
Message posted via http://www.sqlmonster.comhttp://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
"Chocolord via SQLMonster.com" <u26301@.uwe> wrote in message
news:682fc43fee2d6@.uwe...
> Hello everyone, I'm in need of help.
> I'm using microsoft sql server 2005 along with the microsoft visual studio
> 2005. I have 2 questions:
> 1) In the database server, there is an "image" datatype. I need to know
> how
> to use that because I need to display images on my webform.
> 2) I read somewhere that pointers can be used to point the file path. So,
> is
> it possible for me to store images / audios in a file and use the database
> to
> point to the file path? If it is possible, how can it be done?
> Thanks.
> --
> Message posted via http://www.sqlmonster.com
>

Microsoft SQL Management Studio failed to load

I am running SQL Server 2005 bata on my Windows Server 2003, web edition
machine. Recently got an error that the Bata had expired. I ignored this.
However, other C# apps using the Db started having problems.
Uninstalled .Net Framework Version 2. I downloaded the most
recent version from MS, installed the new version.
Now I can't run Management studio or the profiler. Get the following errors:
'Procedure entry point _CxxFrameHandler3 could not be located in the
dynamic link library MSVCR80.dll '
and a follow on error
..."\v2.0.50215\mscorwks.dll could not be loaded".
How do I get back to being able to use these tools?
Hi
The .NET versions are tightly linked to the SQL Server Betas.
Download the SQL Server September 2005 CTP and the Visual Studio 2005 RC1.
They are the newest and are a perfect match.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"FredC" <FredC@.discussions.microsoft.com> wrote in message
news:72539B05-013B-4A6C-BE1E-ED024A28247C@.microsoft.com...
>I am running SQL Server 2005 bata on my Windows Server 2003, web edition
> machine. Recently got an error that the Bata had expired. I ignored this.
> However, other C# apps using the Db started having problems.
> Uninstalled .Net Framework Version 2. I downloaded the most
> recent version from MS, installed the new version.
> Now I can't run Management studio or the profiler. Get the following
> errors:
> 'Procedure entry point _CxxFrameHandler3 could not be located in the
> dynamic link library MSVCR80.dll '
> and a follow on error
> ..."\v2.0.50215\mscorwks.dll could not be loaded".
> How do I get back to being able to use these tools?
|||Sql server 2005 CTP won't install here. It keeps asking me to insert
disk 2.
|||On Tue, 20 Sep 2005 08:59:05 -0700, "FredC"
<FredC@.discussions.microsoft.com> wrote:

>I am running SQL Server 2005 bata on my Windows Server 2003, web edition
>machine. Recently got an error that the Bata had expired. I ignored this.
>However, other C# apps using the Db started having problems.
>Uninstalled .Net Framework Version 2. I downloaded the most
>recent version from MS, installed the new version.
>Now I can't run Management studio or the profiler. Get the following errors:
> 'Procedure entry point _CxxFrameHandler3 could not be located in the
>dynamic link library MSVCR80.dll '
>and a follow on error
>..."\v2.0.50215\mscorwks.dll could not be loaded".
>How do I get back to being able to use these tools?
In addition to Mike's comments you need to be very careful about
uninstall order of components from the old SQL Server 2005 and .NET
Framework builds. That is described in some detail in the documents
that come with September CTP.
Andrew Watt
MVP - InfoPath
|||I found and downloaded SQL Server September 2005 CTP but I can't find Visual
Studio 2005 RC1. Where do I get it?
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> The .NET versions are tightly linked to the SQL Server Betas.
> Download the SQL Server September 2005 CTP and the Visual Studio 2005 RC1.
> They are the newest and are a perfect match.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "FredC" <FredC@.discussions.microsoft.com> wrote in message
> news:72539B05-013B-4A6C-BE1E-ED024A28247C@.microsoft.com...
>
>
|||Apologies microsoft, after all the things I've been saying about them.
All you do, is...
1. Install everything apart from SQL express, on the RC VS.Net 2005
1. put the "server" ISO on, install everything but the bottom checkbox.
1. put the "client" ISO on, install everything to run from the
harddrive.
1. Put the ISO VS.Net 2005 RC back on, and install the SQL Express.
Hey presto, it all works, including SQL express integrated into VS.Net.
(Now we can use SQL Express, with files, who is going to use Access?)
|||drawnai:
Thanks for the good info. But I got myself into more trouble. I thought I'd
try to uninstall Visual Studio and Sever. All the .Net stuff seems to
uninstall and the Server itself uninstalls, but tools like management studio
and profiler don't. They are in my start menu but not in add and remove
programs. Result is that Sever will not install the new tools. Got any
experience at get rid of this stuff while saving existing databases?
"drawnai@.hotmail.com" wrote:

> Apologies microsoft, after all the things I've been saying about them.
> All you do, is...
> 1. Install everything apart from SQL express, on the RC VS.Net 2005
> 1. put the "server" ISO on, install everything but the bottom checkbox.
> 1. put the "client" ISO on, install everything to run from the
> harddrive.
> 1. Put the ISO VS.Net 2005 RC back on, and install the SQL Express.
> Hey presto, it all works, including SQL express integrated into VS.Net.
> (Now we can use SQL Express, with files, who is going to use Access?)
>
sql

Microsoft SQL isapi extension ERROR and SQLXML 3.0

Hi,

I'm using WinXP SP 2, IIS 5.1, SQL Server 2005 Standard, and Visual Studio 2005 Professional.

When I create a virtual directory with IIS Virtual Directory Management for SQLXML 3.0, I get a Microsoft SQL isapi extension error when going to the default page.

If I delete the virtual directory, and then add it directly in the IIS snap-in, with executable permissions, all goes well.

My website is from the Wrox book, Beginning ASP.NET 2.0. An appendix in the book says to add the virtual directory with the SQLXML 3.0 tool, and not to use IIS. I'm very new to this, so I'm not sure if I'll lose functionality down the road or not, by using IIS.

Has anyone run into this before or have any ideas how to get sqlxml 3.0 virt. dir's to work?

The error according to Microsoft support is related to permissions in SQL Server, I also found a FAQ from the SQLXML experts so you will find the answers to all your questions. Hope this helps.

http://support.microsoft.com/kb/820874

http://sqlxml.org/faqs.aspx?faq=79

Microsoft Reports

I am trying to create some reports in MS Visual Studio Express. Is there way to make report viewer or report templates available in Visual Studio Express ?

Hi,

Do you mean those express editions like Visual Web Developer, right?

Business Intelligence Development Studio is the environment that you will use to develop reports and report models in SQL Server 2005 Reporting Services. Business Intelligence Development Studio is theMicrosoft Visual Studio 2005 environment with enhancements that are specific to SQL Server 2005 business intelligence solutions.

Thanks.

Microsoft Reporting Technologies

It seems there are several current reporting mechanisms related to .net and Visual Studio. There is Crystal Reports, an integrated reporting system in Visual Studio and a somewhat related reporting system in SQL Server. The last two seem to use similar .xml bases but it's unclear how or if they are related. This does not include (or maybe is does) the Sharepoint reporting system.

I have eliminated the Crystal Report for various reasons after trying it for awhile. Therefore is there some good introductions and/or comparisons between the Visual Studio reporting system and the SQL Server or BI reporting systems since they both seem to use .rdlc and .rdl type definitions. How or are they related?

Try this link where you can find the answers for your questions

http://msdn2.microsoft.com/en-us/library/ms170246.aspx

sql

Microsoft Feedback Center: Available?

I've been trying to get to the MSDN Product Feedback Center to report a bug
in SQL Server 2005 Management Studio. I'm getting an Error when I try to
reach the site - msdn.microsoft.com/feedback - Is it available?
"An error has occurred during the processing of your request. Please try
again later. "
Persistence pays off. I got in with the menu at the top of Management Studio
with Community-Send Feedback.
"Dr. Network" <charles.hawkins@.jenzabar.net> wrote in message
news:ObkYbN1VGHA.5288@.TK2MSFTNGP14.phx.gbl...
> I've been trying to get to the MSDN Product Feedback Center to report a
> bug in SQL Server 2005 Management Studio. I'm getting an Error when I try
> to reach the site - msdn.microsoft.com/feedback - Is it available?
> "An error has occurred during the processing of your request. Please try
> again later. "
>
|||Try http://lab.msdn.microsoft.com/ProductFeedback/
That URL works for me.
Andrew Watt [MVP]
On Mon, 3 Apr 2006 15:18:17 -0400, "Dr. Network"
<charles.hawkins@.jenzabar.net> wrote:

>I've been trying to get to the MSDN Product Feedback Center to report a bug
>in SQL Server 2005 Management Studio. I'm getting an Error when I try to
>reach the site - msdn.microsoft.com/feedback - Is it available?
>"An error has occurred during the processing of your request. Please try
>again later. "
>

Mgt Studio Express vs Mgt Studio "Full" questions

I am currently using Management Studio Express to administer remote SQLServer databases I support as a DBA. I notice that I cannot "see" DTS packages on the remote server from Express, but when I login directly to the server (Term Services) and use the local Management Studio (Full?), that I CAN see the DTS packages.

1) What are the other differences between Management Studio Express and Management Studio "Full"?

2) Is it possible to aquire and install (upgrade) on my workstation, to Management Studio "Full" so that I can take advantage of the additional capabilities the "Express" version does not have, in order to manage my remote servers?

TIA,
Phil Streiff, MCDBA

There are quite a few differences between SSMS and SSMS-Express.

You can obtain (and be properly licensed for) SSMS with SQL Server Workgroup, Standard and Enterprise Edition.

|||

Thanks Arnie,

I will definitely upgrade to SSMS now, based on your input.

I suppose I have to pay for the SQL2K5 Standard or Workgroup license, even though I'm only installing the Mgt Studio on my workstation and not the whole database engine.

Phil

|||

SS 2005 Workgroup Edition is about $750 with 5 CALs. (Maybe better pricing is around.)

IF you were in a dev environment, you could get SS Developer's Edition for about $50. But I don't think that it would be legit to manage production servers.

Maybe one or more of your clients provide you with SSMS to manage their servers.

For definitive licensing questions, call the licensing folks at:

Licensing –VL Contact
(800) 426-9400

Good Luck!

Mgt Studio - Exclamation Point with a check mark?

Some of our workstations have Mgt Studio appearing with a check mark on the
exclamation point that executes a query window. Some do not.
What is the meaning of this icon?
Thanks!
Read about SET PARSEONLY. Btw, you can easily test this yourself by starting Profiler, press that
button and in the trace see what SQL is submitted. The button is meant for you to test your code for
syntax errors, without executing the SQL statements.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
> Some of our workstations have Mgt Studio appearing with a check mark on the
> exclamation point that executes a query window. Some do not.
> What is the meaning of this icon?
> Thanks!
|||I don't think you understand what I meant.
I know about the check mark that parses a query for errors - that's been
around since QA.
But on my Mgt Studio screen - the ! point icon has a very little hard-to-see
check mark on top of it - a workstation next to it does not have the icon
appearing like this.
"Tibor Karaszi" wrote:

> Read about SET PARSEONLY. Btw, you can easily test this yourself by starting Profiler, press that
> button and in the trace see what SQL is submitted. The button is meant for you to test your code for
> syntax errors, without executing the SQL statements.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
>
|||I don't think it's a checkmark, I just always thought it was a stray
artifact of a badly-resized icon. I've logged onto several machines to try
and find one that looks different, and they all look the same to me (both
direct login and over RDP). Can you show screen shots comparing the two?
Is it possible it's just a visual artifact issue, and not an actual icon
difference that is intentional?
Aaron Bertrand
SQL Server MVP
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...[vbcol=seagreen]
>I don't think you understand what I meant.
> I know about the check mark that parses a query for errors - that's been
> around since QA.
> But on my Mgt Studio screen - the ! point icon has a very little
> hard-to-see
> check mark on top of it - a workstation next to it does not have the icon
> appearing like this.
> "Tibor Karaszi" wrote:
|||Ahh, I see. Very hard indeed to see (a tiny green one, right?). I've never seen that before. Perhaps
a service pack thing?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...[vbcol=seagreen]
>I don't think you understand what I meant.
> I know about the check mark that parses a query for errors - that's been
> around since QA.
> But on my Mgt Studio screen - the ! point icon has a very little hard-to-see
> check mark on top of it - a workstation next to it does not have the icon
> appearing like this.
> "Tibor Karaszi" wrote:
|||Well - I don't know if I can post images on this forum (is it possible?) -
but I did post the images on this forum if you want to go look at it.
http://www.vbforums.com/showthread.php?t=483415
"Aaron Bertrand [SQL Server MVP]" wrote:

> I don't think it's a checkmark, I just always thought it was a stray
> artifact of a badly-resized icon. I've logged onto several machines to try
> and find one that looks different, and they all look the same to me (both
> direct login and over RDP). Can you show screen shots comparing the two?
> Is it possible it's just a visual artifact issue, and not an actual icon
> difference that is intentional?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...
>
>
|||Yes, I don't recall ever seeing it *without* the checkmark, and I can't find
a single instance of client tools that doesn't have it. As I said in my
other reply, I merely thought it was a badly generated icon with extra
pixels flailing about.
Aaron Bertrand
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%232vcbR42HHA.5116@.TK2MSFTNGP04.phx.gbl...
> Ahh, I see. Very hard indeed to see (a tiny green one, right?). I've never
> seen that before. Perhaps a service pack thing?
|||Interesting. Did you check the build number for each SSMS?
OK, I fired up a virtual machine, which is RTM, and it didn't have the little green checkmark.
(Aaron, I do think it *is* a tiny tiny checkmark.)
SSMS build number on a machine where I *don't* have the checkmark: 9.00.1399.00. This is RTM
SSMS build number on a machine where I *don't* have the checkmark: 9.00.2047.00. This is sp1
SSMS build number on a machine where I *have* the checkmark: 9.00.3042.00. This is sp2.
So, it seems this wad added in sp2.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:37330604-00F8-405B-B437-33EAA6D1AC9E@.microsoft.com...[vbcol=seagreen]
> Well - I don't know if I can post images on this forum (is it possible?) -
> but I did post the images on this forum if you want to go look at it.
> http://www.vbforums.com/showthread.php?t=483415
> "Aaron Bertrand [SQL Server MVP]" wrote:

Mgt Studio - Exclamation Point with a check mark?

Some of our workstations have Mgt Studio appearing with a check mark on the
exclamation point that executes a query window. Some do not.
What is the meaning of this icon'
Thanks!Read about SET PARSEONLY. Btw, you can easily test this yourself by starting Profiler, press that
button and in the trace see what SQL is submitted. The button is meant for you to test your code for
syntax errors, without executing the SQL statements.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
> Some of our workstations have Mgt Studio appearing with a check mark on the
> exclamation point that executes a query window. Some do not.
> What is the meaning of this icon'
> Thanks!|||I don't think you understand what I meant.
I know about the check mark that parses a query for errors - that's been
around since QA.
But on my Mgt Studio screen - the ! point icon has a very little hard-to-see
check mark on top of it - a workstation next to it does not have the icon
appearing like this.
"Tibor Karaszi" wrote:
> Read about SET PARSEONLY. Btw, you can easily test this yourself by starting Profiler, press that
> button and in the trace see what SQL is submitted. The button is meant for you to test your code for
> syntax errors, without executing the SQL statements.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
> > Some of our workstations have Mgt Studio appearing with a check mark on the
> > exclamation point that executes a query window. Some do not.
> >
> > What is the meaning of this icon'
> >
> > Thanks!
>|||I don't think it's a checkmark, I just always thought it was a stray
artifact of a badly-resized icon. I've logged onto several machines to try
and find one that looks different, and they all look the same to me (both
direct login and over RDP). Can you show screen shots comparing the two?
Is it possible it's just a visual artifact issue, and not an actual icon
difference that is intentional?
--
Aaron Bertrand
SQL Server MVP
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...
>I don't think you understand what I meant.
> I know about the check mark that parses a query for errors - that's been
> around since QA.
> But on my Mgt Studio screen - the ! point icon has a very little
> hard-to-see
> check mark on top of it - a workstation next to it does not have the icon
> appearing like this.
> "Tibor Karaszi" wrote:
>> Read about SET PARSEONLY. Btw, you can easily test this yourself by
>> starting Profiler, press that
>> button and in the trace see what SQL is submitted. The button is meant
>> for you to test your code for
>> syntax errors, without executing the SQL statements.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
>> news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
>> > Some of our workstations have Mgt Studio appearing with a check mark on
>> > the
>> > exclamation point that executes a query window. Some do not.
>> >
>> > What is the meaning of this icon'
>> >
>> > Thanks!
>>|||Ahh, I see. Very hard indeed to see (a tiny green one, right?). I've never seen that before. Perhaps
a service pack thing?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...
>I don't think you understand what I meant.
> I know about the check mark that parses a query for errors - that's been
> around since QA.
> But on my Mgt Studio screen - the ! point icon has a very little hard-to-see
> check mark on top of it - a workstation next to it does not have the icon
> appearing like this.
> "Tibor Karaszi" wrote:
>> Read about SET PARSEONLY. Btw, you can easily test this yourself by starting Profiler, press that
>> button and in the trace see what SQL is submitted. The button is meant for you to test your code
>> for
>> syntax errors, without executing the SQL statements.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
>> news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
>> > Some of our workstations have Mgt Studio appearing with a check mark on the
>> > exclamation point that executes a query window. Some do not.
>> >
>> > What is the meaning of this icon'
>> >
>> > Thanks!
>>|||Well - I don't know if I can post images on this forum (is it possible') -
but I did post the images on this forum if you want to go look at it.
http://www.vbforums.com/showthread.php?t=483415
"Aaron Bertrand [SQL Server MVP]" wrote:
> I don't think it's a checkmark, I just always thought it was a stray
> artifact of a badly-resized icon. I've logged onto several machines to try
> and find one that looks different, and they all look the same to me (both
> direct login and over RDP). Can you show screen shots comparing the two?
> Is it possible it's just a visual artifact issue, and not an actual icon
> difference that is intentional?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...
> >I don't think you understand what I meant.
> >
> > I know about the check mark that parses a query for errors - that's been
> > around since QA.
> >
> > But on my Mgt Studio screen - the ! point icon has a very little
> > hard-to-see
> > check mark on top of it - a workstation next to it does not have the icon
> > appearing like this.
> >
> > "Tibor Karaszi" wrote:
> >
> >> Read about SET PARSEONLY. Btw, you can easily test this yourself by
> >> starting Profiler, press that
> >> button and in the trace see what SQL is submitted. The button is meant
> >> for you to test your code for
> >> syntax errors, without executing the SQL statements.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> >> news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
> >> > Some of our workstations have Mgt Studio appearing with a check mark on
> >> > the
> >> > exclamation point that executes a query window. Some do not.
> >> >
> >> > What is the meaning of this icon'
> >> >
> >> > Thanks!
> >>
> >>
>
>|||Yes, I don't recall ever seeing it *without* the checkmark, and I can't find
a single instance of client tools that doesn't have it. As I said in my
other reply, I merely thought it was a badly generated icon with extra
pixels flailing about.
--
Aaron Bertrand
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%232vcbR42HHA.5116@.TK2MSFTNGP04.phx.gbl...
> Ahh, I see. Very hard indeed to see (a tiny green one, right?). I've never
> seen that before. Perhaps a service pack thing?|||Interesting. Did you check the build number for each SSMS?
OK, I fired up a virtual machine, which is RTM, and it didn't have the little green checkmark.
(Aaron, I do think it *is* a tiny tiny checkmark.)
SSMS build number on a machine where I *don't* have the checkmark: 9.00.1399.00. This is RTM
SSMS build number on a machine where I *don't* have the checkmark: 9.00.2047.00. This is sp1
SSMS build number on a machine where I *have* the checkmark: 9.00.3042.00. This is sp2.
So, it seems this wad added in sp2.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:37330604-00F8-405B-B437-33EAA6D1AC9E@.microsoft.com...
> Well - I don't know if I can post images on this forum (is it possible') -
> but I did post the images on this forum if you want to go look at it.
> http://www.vbforums.com/showthread.php?t=483415
> "Aaron Bertrand [SQL Server MVP]" wrote:
>> I don't think it's a checkmark, I just always thought it was a stray
>> artifact of a badly-resized icon. I've logged onto several machines to try
>> and find one that looks different, and they all look the same to me (both
>> direct login and over RDP). Can you show screen shots comparing the two?
>> Is it possible it's just a visual artifact issue, and not an actual icon
>> difference that is intentional?
>> --
>> Aaron Bertrand
>> SQL Server MVP
>>
>>
>> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
>> news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...
>> >I don't think you understand what I meant.
>> >
>> > I know about the check mark that parses a query for errors - that's been
>> > around since QA.
>> >
>> > But on my Mgt Studio screen - the ! point icon has a very little
>> > hard-to-see
>> > check mark on top of it - a workstation next to it does not have the icon
>> > appearing like this.
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> Read about SET PARSEONLY. Btw, you can easily test this yourself by
>> >> starting Profiler, press that
>> >> button and in the trace see what SQL is submitted. The button is meant
>> >> for you to test your code for
>> >> syntax errors, without executing the SQL statements.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://sqlblog.com/blogs/tibor_karaszi
>> >>
>> >>
>> >> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
>> >> news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
>> >> > Some of our workstations have Mgt Studio appearing with a check mark on
>> >> > the
>> >> > exclamation point that executes a query window. Some do not.
>> >> >
>> >> > What is the meaning of this icon'
>> >> >
>> >> > Thanks!
>> >>
>> >>
>>

Mgt Studio - Exclamation Point with a check mark?

Some of our workstations have Mgt Studio appearing with a check mark on the
exclamation point that executes a query window. Some do not.
What is the meaning of this icon'
Thanks!Read about SET PARSEONLY. Btw, you can easily test this yourself by starting
Profiler, press that
button and in the trace see what SQL is submitted. The button is meant for y
ou to test your code for
syntax errors, without executing the SQL statements.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
> Some of our workstations have Mgt Studio appearing with a check mark on th
e
> exclamation point that executes a query window. Some do not.
> What is the meaning of this icon'
> Thanks!|||I don't think you understand what I meant.
I know about the check mark that parses a query for errors - that's been
around since QA.
But on my Mgt Studio screen - the ! point icon has a very little hard-to-see
check mark on top of it - a workstation next to it does not have the icon
appearing like this.
"Tibor Karaszi" wrote:

> Read about SET PARSEONLY. Btw, you can easily test this yourself by starti
ng Profiler, press that
> button and in the trace see what SQL is submitted. The button is meant for
you to test your code for
> syntax errors, without executing the SQL statements.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
>|||I don't think it's a checkmark, I just always thought it was a stray
artifact of a badly-resized icon. I've logged onto several machines to try
and find one that looks different, and they all look the same to me (both
direct login and over RDP). Can you show screen shots comparing the two?
Is it possible it's just a visual artifact issue, and not an actual icon
difference that is intentional?
Aaron Bertrand
SQL Server MVP
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...[vbcol=seagreen]
>I don't think you understand what I meant.
> I know about the check mark that parses a query for errors - that's been
> around since QA.
> But on my Mgt Studio screen - the ! point icon has a very little
> hard-to-see
> check mark on top of it - a workstation next to it does not have the icon
> appearing like this.
> "Tibor Karaszi" wrote:
>|||Ahh, I see. Very hard indeed to see (a tiny green one, right?). I've never s
een that before. Perhaps
a service pack thing?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...[vbcol=seagreen]
>I don't think you understand what I meant.
> I know about the check mark that parses a query for errors - that's been
> around since QA.
> But on my Mgt Studio screen - the ! point icon has a very little hard-to-s
ee
> check mark on top of it - a workstation next to it does not have the icon
> appearing like this.
> "Tibor Karaszi" wrote:
>|||Well - I don't know if I can post images on this forum (is it possible') -
but I did post the images on this forum if you want to go look at it.
http://www.vbforums.com/showthread.php?t=483415
"Aaron Bertrand [SQL Server MVP]" wrote:

> I don't think it's a checkmark, I just always thought it was a stray
> artifact of a badly-resized icon. I've logged onto several machines to tr
y
> and find one that looks different, and they all look the same to me (both
> direct login and over RDP). Can you show screen shots comparing the two?
> Is it possible it's just a visual artifact issue, and not an actual icon
> difference that is intentional?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...
>
>|||Yes, I don't recall ever seeing it *without* the checkmark, and I can't find
a single instance of client tools that doesn't have it. As I said in my
other reply, I merely thought it was a badly generated icon with extra
pixels flailing about.
Aaron Bertrand
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%232vcbR42HHA.5116@.TK2MSFTNGP04.phx.gbl...
> Ahh, I see. Very hard indeed to see (a tiny green one, right?). I've never
> seen that before. Perhaps a service pack thing?|||Interesting. Did you check the build number for each SSMS?
OK, I fired up a virtual machine, which is RTM, and it didn't have the littl
e green checkmark.
(Aaron, I do think it *is* a tiny tiny checkmark.)
SSMS build number on a machine where I *don't* have the checkmark: 9.00.1399
.00. This is RTM
SSMS build number on a machine where I *don't* have the checkmark: 9.00.2047
.00. This is sp1
SSMS build number on a machine where I *have* the checkmark: 9.00.3042.00. T
his is sp2.
So, it seems this wad added in sp2.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:37330604-00F8-405B-B437-33EAA6D1AC9E@.microsoft.com...[vbcol=seagreen]
> Well - I don't know if I can post images on this forum (is it possible')
-
> but I did post the images on this forum if you want to go look at it.
> http://www.vbforums.com/showthread.php?t=483415
> "Aaron Bertrand [SQL Server MVP]" wrote:
>

Mgmt Studio: Script Table as...

Hi,

I'm using SQL Server 2005 Express SP1 & Mgmt Studio express.

I'm trying to use the script output to track my db changes in source code mgmt, but when I output a table to a script the first two bytes of the "text" file are 0xFF and 0xFE which sends my SCM into storingthe file in binary defeating the purpose of storing text files I can "diff" to see the changes.

Does anyone know why the mgmt studio is doing this and is there a way to stop it?

thanks!

Management Studio creates UNICODE files so characters from all alphabets can be represented in the same file. Your SCM system is probably interpretting the UNICODE signature at the top of the file as being "binary."

If you are scripting to a Query Editor Window, you can save the script as an ASCII file by clicking File | Save As... and clicking the little pull-down arrow on the right side of the save button to select the file type. US-ASCII is toward the bottom of the list.

Hope this helps,
Steve

|||

Thanks! This was helpful and it explains the situation.

I'm working around it by the copy & paste method you mention while I deal with the SCM issue.

It's interesting that SQL Server Mgmt Studio uses unicode BOM and Visual Studio uses utf-8 for it's configuration files, so the SCM has to deal with the many "standards" of unicode...

life was not mean't to be easy...

Mgmt Studio: List versus Details view

So now all the Details views have the "Policy Health State" column. Great. But when will we be able to add other columns to the details views? Or at least put back what SQL 2K used to show in details views? Pretty please?

Hi Bob,

We actually have plans to only display the Policy Health State in the Details section for only those objects that have policy state. For CTP6, we are looking to extend the Object Details to show many more properties than you had in the past. Please stay tuned.

Bill Ramos,

Lead PM

|||Many, many thanks Bill.

Mgmt Studio not supporting 7.0?

I tried using Mgmt Studio RTM to connect to SQL Server 7.0 instance and
received this:
"This version of Microsoft SQL Server Management Studio can only be used to
connect to SQL Server 2005 and SQL Server 2000 servers (ConnectionDlg)"
I thought Mgmt Studio was going to support 7.0?
Hi
No. 7.0 is really very close to end of life so no support for it.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Johnny Ortega" <john.ortega@.quest.com> wrote in message
news:uuklBLx5FHA.2956@.TK2MSFTNGP12.phx.gbl...
>I tried using Mgmt Studio RTM to connect to SQL Server 7.0 instance and
> received this:
> "This version of Microsoft SQL Server Management Studio can only be used
> to
> connect to SQL Server 2005 and SQL Server 2000 servers (ConnectionDlg)"
> I thought Mgmt Studio was going to support 7.0?
>
|||Maybe part of the confusion is because the book 'Microsoft SQL Server 2005 -
Changing the Paradigm' mentions that SQL Server 7 will be supported (page
97).
Ben Nevarez
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:usTkijx5FHA.2628@.TK2MSFTNGP11.phx.gbl...
> Hi
> No. 7.0 is really very close to end of life so no support for it.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Johnny Ortega" <john.ortega@.quest.com> wrote in message
> news:uuklBLx5FHA.2956@.TK2MSFTNGP12.phx.gbl...
>
|||Hi
Lots of features get dropped from the Product over it's development life.
This support was dropped very early. SMO support for SQL Server 7.0 was
dropped very late and there is still documentation mentioning it.
During the development program, even e-mails were stale by the time most
people read them, let alone printed books.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:e2lMdML6FHA.1000@.tk2msftngp13.phx.gbl...
> Maybe part of the confusion is because the book 'Microsoft SQL Server
> 2005 - Changing the Paradigm' mentions that SQL Server 7 will be supported
> (page 97).
> Ben Nevarez
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:usTkijx5FHA.2628@.TK2MSFTNGP11.phx.gbl...
>

Mgmt Studio and Sql 2000

I have a local server I just upgraded to 2005. Everything went well. But,
I
also have a remote sql 2000 server I still need to connect to. Can't seem
to get the tcp/ip connection to old server to work. Go back to old 2000 too
l
and it works fine, but I'd prefer to stay in one environment and migrate to
the new tool. Any ideas?What errors do you get?
-Sue
On Tue, 25 Jul 2006 06:47:02 -0700, Janet
<Janet@.discussions.microsoft.com> wrote:

>I have a local server I just upgraded to 2005. Everything went well. But,
I
>also have a remote sql 2000 server I still need to connect to. Can't seem
>to get the tcp/ip connection to old server to work. Go back to old 2000 to
ol
>and it works fine, but I'd prefer to stay in one environment and migrate to
>the new tool. Any ideas?|||As background - in SSMS, I checked the sql native client connectivity and
tcpip is enabled, alias is listed with correct ip and port. Error is:
===================================
Cannot connect to CASCE.
===================================
This version of Microsoft SQL Server Management Studio can only be used to
connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)
Program Location:
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.SqlServerType.Microsoft.SqlS
erver.Management.UI.ConnectionDlg.IConnectionValidator.CheckConnection(IDbCo
nnection conn)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.CheckConnection()
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()
"Sue Hoegemeier" wrote:

> What errors do you get?
> -Sue
> On Tue, 25 Jul 2006 06:47:02 -0700, Janet
> <Janet@.discussions.microsoft.com> wrote:
>
>|||That's the error you get when you try to connect to SQL
Server 7 or earlier with SSMS. Double check the version on
the other remote server when you connect with Query Analyzer
using select @.@.version.
-Sue
On Wed, 26 Jul 2006 10:28:02 -0700, Janet
<Janet@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>As background - in SSMS, I checked the sql native client connectivity and
>tcpip is enabled, alias is listed with correct ip and port. Error is:
>===================================
>Cannot connect to CASCE.
>===================================
>This version of Microsoft SQL Server Management Studio can only be used to
>connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)
>--
>Program Location:
> at
>Microsoft.SqlServer.Management.UI.ConnectionDlg.SqlServerType.Microsoft.Sql
Server.Management.UI.ConnectionDlg.IConnectionValidator.CheckConnection(IDbC
onnection conn)
> at
>Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.CheckConnection()
> at
>Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()
>
>"Sue Hoegemeier" wrote:
>|||Sue, holy toledo! You're right! My contact TOLD me they were running sql
2000, but they're running sql 7. I know that the new SSMS won't work with
that - read that in the documentation. Ah, well. Have to keep the old tool
s
around, I guess. Thanks so much for forcing me to double-check.
"Sue Hoegemeier" wrote:

> That's the error you get when you try to connect to SQL
> Server 7 or earlier with SSMS. Double check the version on
> the other remote server when you connect with Query Analyzer
> using select @.@.version.
> -Sue
> On Wed, 26 Jul 2006 10:28:02 -0700, Janet
> <Janet@.discussions.microsoft.com> wrote:
>
>

Mgmt Studio

Can I manage MSDE databases in Management Studio? If not, how can I? How
about SQL Express?
When I try to attach an msde.mdf it just gets an "unknown error."
Regards,
Gary BlakelyTry to attach an MSDE MDF file to what?
You can certainly manage existing instances of SQL Server 2000 (including
MSDE). But you're not going to be able to just attach a SQL Server
2000-based mdf (from MSDE or otherwise) to a 2005 instance.
A
"GaryDean" <GaryDean@.newsgroups.nospam> wrote in message
news:OZhDtF5HHHA.4760@.TK2MSFTNGP03.phx.gbl...
> Can I manage MSDE databases in Management Studio? If not, how can I? How
> about SQL Express?
> When I try to attach an msde.mdf it just gets an "unknown error."
> --
> Regards,
> Gary Blakely
>|||Hi Gary,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Mgmt Studio

Can I manage MSDE databases in Management Studio? If not, how can I? How
about SQL Express?
When I try to attach an msde.mdf it just gets an "unknown error."
--
Regards,
Gary BlakelyTry to attach an MSDE MDF file to what?
You can certainly manage existing instances of SQL Server 2000 (including
MSDE). But you're not going to be able to just attach a SQL Server
2000-based mdf (from MSDE or otherwise) to a 2005 instance.
A
"GaryDean" <GaryDean@.newsgroups.nospam> wrote in message
news:OZhDtF5HHHA.4760@.TK2MSFTNGP03.phx.gbl...
> Can I manage MSDE databases in Management Studio? If not, how can I? How
> about SQL Express?
> When I try to attach an msde.mdf it just gets an "unknown error."
> --
> Regards,
> Gary Blakely
>|||Hi Gary,
SQL Server 2005 Management Studio totally supports attaching SQL Server
2000, MSDE2000 and SQL Express databases by using sp_detach_db/sp_attach_db
stored procedure.
Please try again via the following:
1. Connect to your MSDE instance, and run the following statement:
use master
go
exec sp_detach_db 'YourDatabaseName'
2. Connect to your SQL Server 2005 instance and run the following statement:
use master
go
exec sp_attach_db @.dbname='DatabaseName',
@.filename1 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test.mdf',
@.filename2 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test_log.ldf'
Could you please mail me (changliw@.microsoft.com) the SQL error logs and a
screenshot of the error message for further research?
By default, the error logs of SQL Server 2005 instance are located in
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG". You may check it
if there are multiple instances installed on your computer.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Gary,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Mgmt Studio

Can I manage MSDE databases in Management Studio? If not, how can I? How
about SQL Express?
When I try to attach an msde.mdf it just gets an "unknown error."
Regards,
Gary Blakely
Try to attach an MSDE MDF file to what?
You can certainly manage existing instances of SQL Server 2000 (including
MSDE). But you're not going to be able to just attach a SQL Server
2000-based mdf (from MSDE or otherwise) to a 2005 instance.
A
"GaryDean" <GaryDean@.newsgroups.nospam> wrote in message
news:OZhDtF5HHHA.4760@.TK2MSFTNGP03.phx.gbl...
> Can I manage MSDE databases in Management Studio? If not, how can I? How
> about SQL Express?
> When I try to attach an msde.mdf it just gets an "unknown error."
> --
> Regards,
> Gary Blakely
>
|||Hi Gary,
SQL Server 2005 Management Studio totally supports attaching SQL Server
2000, MSDE2000 and SQL Express databases by using sp_detach_db/sp_attach_db
stored procedure.
Please try again via the following:
1. Connect to your MSDE instance, and run the following statement:
use master
go
exec sp_detach_db 'YourDatabaseName'
2. Connect to your SQL Server 2005 instance and run the following statement:
use master
go
exec sp_attach_db @.dbname='DatabaseName',
@.filename1 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test.mdf',
@.filename2 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test_log.ldf'
Could you please mail me (changliw@.microsoft.com) the SQL error logs and a
screenshot of the error message for further research?
By default, the error logs of SQL Server 2005 instance are located in
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG". You may check it
if there are multiple instances installed on your computer.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hi Gary,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

mgmnt studio express won't shrink .ldf files

I'm attempting to truncate/shrink a db (mdf & ldf) to be able to zip it and email it. From Object Explorer I select the db->tasks->shrink->files->filetype->log->release unused spage or reorganize->shrink file to (0mb). This action does not change the size of the .ldf file. Shrinking the mdf works just like SQL 2000 - as expected. Why don't the actions taken do what they imply for the .ldf file? If this is not what the selections mean, what do they mean?

thanks, jack

If you want the LDF to skrink to 0mb then you need to truncate the log because SQL Server in shrink mode reserves what was active log now called virtual log before releasing space to the OS. You can run DBCC Shrinkfile and see what error you get because 2005 now logs the error in the error log. Run a search for DBCC Shrinkfile and Truncate log in the BOL. Hope this helps.

|||Caddre, your response led me to information that explains the 'reality' of dealing with the logfile. In my case since I 'want' an empty db to distribute,I found that I could just detach the db, then delete the .ldf file. When I re-attach a 'new' empty log file is created. -- thanks, jack

Method of EnumJob()

I use the method of EnumJob() in order to create an DataGridView in Visual Studio to put in it all the jobs of a server with three of their propertes!

So I use three columns!In first Column I put the "Name",in the second the "Status" and in the third the "Last Execution".

I found from the "SQL Server Books Online" that their DataPropertyNames are Name,CurrentRunStatus and LAstRunDate.

I used them and only the DataPropertyName : "Name" works!!!!!

What am I doing Wrong?

I would appreciate if somebody could help me or give me an idea

Seems that this is not implemeted in the SMO classes, the appropate lines shows:

public DateTime LastRunDate

{

get

{

return (DateTime) base.Properties.GetValueWithNullReplacement("LastRunDate");

}

}

Perhaps you might query the system tables directly.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de