No Management Studio in 2005 Enterprise Edition

I have installed SQL Server 2005 Enterprise Edition Evaluation on my

machine and Management Studio or Enterprise Manager is not present. Do

i need to perform extra task or did i do sth wrong when installing this.

Thanks for your attention.

It's more likely that you did not install the client components
When you setup program, at one stage wou have choice to check the components you want to install
Client components are grouped under the name orf workstation or something similar (Sorry I don't remeber the exact name))

sql

No longer able to open up .rptproj

My visual studio .net application previously had not problem opening .rptroj
files, but now it tells me "Make sure the application for the project type
(.rptproj) is installed"
Also, when I try to create a new project, the "Business Intelligence"
project type is not listed. I have seen some suggestions on line about
removing msatinterop.dll from the PrivateAssemblies directory but this does
not change a thing for me.Try running VS from the command line with the /resetskippkgs switch. That
should do the trick. Your command would look something like:
C:\>cd C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE\
C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
/resetskipkgs
This is assuming you have RS installed to the default directory. You would
obviously have to find where the devenv.exe file is in order to run the file.
"DBA72" wrote:
> My visual studio .net application previously had not problem opening .rptroj
> files, but now it tells me "Make sure the application for the project type
> (.rptproj) is installed"
> Also, when I try to create a new project, the "Business Intelligence"
> project type is not listed. I have seen some suggestions on line about
> removing msatinterop.dll from the PrivateAssemblies directory but this does
> not change a thing for me.|||Running devenv didn't work for me, but reinstalling MRS with the Report
Designer component checked did. Good Luck.
Bassist695 wrote:
> Try running VS from the command line with the /resetskippkgs switch.
That
> should do the trick. Your command would look something like:
> C:\>cd C:\Program Files\Microsoft Visual Studio .NET
2003\Common7\IDE\
> C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
> /resetskipkgs
> This is assuming you have RS installed to the default directory. You
would
> obviously have to find where the devenv.exe file is in order to run
the file.
>
> "DBA72" wrote:
> > My visual studio .net application previously had not problem
opening .rptroj
> > files, but now it tells me "Make sure the application for the
project type
> > (.rptproj) is installed"
> >
> > Also, when I try to create a new project, the "Business
Intelligence"
> > project type is not listed. I have seen some suggestions on line
about
> > removing msatinterop.dll from the PrivateAssemblies directory but
this does
> > not change a thing for me.|||I solved this problem by reinstalling reporting services. I tried
running devenv.exe to no avail. On the default install for RS it
leaves the Report Designer unchecked. When you reinstall (or repair)
make sure this component is checked and it should solve the problem.
Bassist695 wrote:
> Try running VS from the command line with the /resetskippkgs switch.
That
> should do the trick. Your command would look something like:
> C:\>cd C:\Program Files\Microsoft Visual Studio .NET
2003\Common7\IDE\
> C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
> /resetskipkgs
> This is assuming you have RS installed to the default directory. You
would
> obviously have to find where the devenv.exe file is in order to run
the file.
>
> "DBA72" wrote:
> > My visual studio .net application previously had not problem
opening .rptroj
> > files, but now it tells me "Make sure the application for the
project type
> > (.rptproj) is installed"
> >
> > Also, when I try to create a new project, the "Business
Intelligence"
> > project type is not listed. I have seen some suggestions on line
about
> > removing msatinterop.dll from the PrivateAssemblies directory but
this does
> > not change a thing for me.sql

No Import/Export Option in Mgmt Studio Express

Hi,

I just installed SQL Server 2005 Express. I would like to import tables from

another DB, and I read in the help files that I just need to (1) right-click on

a non-system database in Management Studio Express, and (2) select Import/Export

under the Tasks menu.

I tried this, but my Tasks menu only contains these options: Detach, Shrink,

Backup, Restore, Generate Scripts.

I googled for \"sql server 2005 "no import" tasks\", and it appears that a

couple of people have had this problem -- the only solution I read was to

install the "Workstation Components," but I already have, and still no luck.

Any idea what I need to do? Thanks!

Did you try right clicking on the database in the object explorer window. Try that, and then the All Tasks, Generate SQL Scripts option.|||Okay, I right-clicked on my database in the object explorer, then went to Tasks->Generate Scripts. This database is empty, though (I want to import a SQL Server 7 DB into it), so I end up getting a message that says "There are no objects in database of the types scriptable by this wizard."

Ultimately, I just need to import a SQL Server 7 database into SQL Server 2005 Express, but I can't find an "import" option in 2005. Is there some component I need to install?|||Ah, I think I need SQL Server Integration Services (SSIS), and that is apparently not included in SQL Server 2005 Express Edition (see "Unsupported Features" in http://msdn2.microsoft.com/en-us/library/ms365166.aspx). Mystery solved.

No icon or utilities...

Does anyone know why, after an upgrade from SQL 2000 to 2K5, there would not be an icon or a path to get to Management Studio? I can register the server from other locations and the services are running on that box, but there are no options on the box itself to get to Management Studio.(i.e. Start...Programs...SQL Server 2005...Management Studio) Please advise.

Most likely, the client tools were not installed. I don't think that they are installed in a default installation on a Server OS.

Put in your installation media, and select client tools.

No fields allowed in header/footer?!?

I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
designer friendly interface. So please be patient & simplistic with your
responses.
If you can't place fields in page headers or footers how can you get fields
to repeat on multi-page forms, like shop travelers and packing lists, which
repeat customer and order info on every page but changes line item data?Two ways:
Rather than using a page header/footer for these section breaks, use a group
header and/or footer in a table. You can set group headers to to force a
page break or to repeat on a new page.
If you must show data in a page header or footer, add a hidden field-bound
textbox to the main report and then reference it from an item in the header
or footer (ReportItems!SalesTotal.Value). This isn't elegant but it works
for most things.
Paul Turley, MCSD, MCDBA, MSF, MCT
nospam at scout-master.com
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:FE0F30A9-057B-48FB-B8F8-E7158B312724@.microsoft.com...
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get
> fields
> to repeat on multi-page forms, like shop travelers and packing lists,
> which
> repeat customer and order info on every page but changes line item data?|||You can reference the fields in the reports to do so.
HTH,, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"rs_newbie" <rsnewbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:FE0F30A9-057B-48FB-B8F8-E7158B312724@.microsoft.com...
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get
> fields
> to repeat on multi-page forms, like shop travelers and packing lists,
> which
> repeat customer and order info on every page but changes line item data?|||That is right; you cannot place fields in a page header or footer. To get
round this, put a textbox in the header and use a formula that references a
textbox with the field in the body of the report. For example:
=ReportItems!OrderNumber.Value
The above expression can be placed in the page header or footer. It is
referencing a textbox called OrderNumber. If the textbox displays the field
you want, then the value is also displayed in the textbox that has the above
formula.
Charles Kangai, MCDBA, MCT
"rs_newbie" wrote:
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get fields
> to repeat on multi-page forms, like shop travelers and packing lists, which
> repeat customer and order info on every page but changes line item data?|||Thanks everyone. That works great for a few fields. How about whole tables?
"Charles Kangai" wrote:
> That is right; you cannot place fields in a page header or footer. To get
> round this, put a textbox in the header and use a formula that references a
> textbox with the field in the body of the report. For example:
> =ReportItems!OrderNumber.Value
> The above expression can be placed in the page header or footer. It is
> referencing a textbox called OrderNumber. If the textbox displays the field
> you want, then the value is also displayed in the textbox that has the above
> formula.
> Charles Kangai, MCDBA, MCT
> "rs_newbie" wrote:
> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> > designer friendly interface. So please be patient & simplistic with your
> > responses.
> >
> > If you can't place fields in page headers or footers how can you get fields
> > to repeat on multi-page forms, like shop travelers and packing lists, which
> > repeat customer and order info on every page but changes line item data?|||Generally speaking, you don't need to do this as you can have as many tables
as you want in the body of the report. What is the specific scenario?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> Thanks everyone. That works great for a few fields. How about whole
> tables?
> "Charles Kangai" wrote:
>> That is right; you cannot place fields in a page header or footer. To get
>> round this, put a textbox in the header and use a formula that references
>> a
>> textbox with the field in the body of the report. For example:
>> =ReportItems!OrderNumber.Value
>> The above expression can be placed in the page header or footer. It is
>> referencing a textbox called OrderNumber. If the textbox displays the
>> field
>> you want, then the value is also displayed in the textbox that has the
>> above
>> formula.
>> Charles Kangai, MCDBA, MCT
>> "rs_newbie" wrote:
>> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
>> > designer friendly interface. So please be patient & simplistic with
>> > your
>> > responses.
>> >
>> > If you can't place fields in page headers or footers how can you get
>> > fields
>> > to repeat on multi-page forms, like shop travelers and packing lists,
>> > which
>> > repeat customer and order info on every page but changes line item
>> > data?|||Why the reference doesnt function after a pagebreak?
scenario:
You put the hidden field at the top of the body.
Then you insert a header-field that refere to the hidden field.
Cause the report has a lot of data there will be 2 pages and also 2 header.
The reportItem!Name.Value on the SECOND page has no Value.
Why?
thy, Michele
"Brian Welcker [MSFT]" wrote:
> Generally speaking, you don't need to do this as you can have as many tables
> as you want in the body of the report. What is the specific scenario?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> > Thanks everyone. That works great for a few fields. How about whole
> > tables?
> >
> > "Charles Kangai" wrote:
> >
> >> That is right; you cannot place fields in a page header or footer. To get
> >> round this, put a textbox in the header and use a formula that references
> >> a
> >> textbox with the field in the body of the report. For example:
> >>
> >> =ReportItems!OrderNumber.Value
> >>
> >> The above expression can be placed in the page header or footer. It is
> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> field
> >> you want, then the value is also displayed in the textbox that has the
> >> above
> >> formula.
> >>
> >> Charles Kangai, MCDBA, MCT
> >>
> >> "rs_newbie" wrote:
> >>
> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> >> > designer friendly interface. So please be patient & simplistic with
> >> > your
> >> > responses.
> >> >
> >> > If you can't place fields in page headers or footers how can you get
> >> > fields
> >> > to repeat on multi-page forms, like shop travelers and packing lists,
> >> > which
> >> > repeat customer and order info on every page but changes line item
> >> > data?
>
>|||Because there is no instance of the textbox on the second page. The
ReportItems collection in the page header / footer refer to the items on the
page. I understand this is a limitation. Instead of using the header, could
you use an outer list that repeats on new pages?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michele" <Michele@.discussions.microsoft.com> wrote in message
news:EB1F86BB-A2C6-4487-9C25-DC9ADAD69EB3@.microsoft.com...
> Why the reference doesnt function after a pagebreak?
> scenario:
> You put the hidden field at the top of the body.
> Then you insert a header-field that refere to the hidden field.
> Cause the report has a lot of data there will be 2 pages and also 2
> header.
> The reportItem!Name.Value on the SECOND page has no Value.
> Why?
> thy, Michele
> "Brian Welcker [MSFT]" wrote:
>> Generally speaking, you don't need to do this as you can have as many
>> tables
>> as you want in the body of the report. What is the specific scenario?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
>> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
>> > Thanks everyone. That works great for a few fields. How about whole
>> > tables?
>> >
>> > "Charles Kangai" wrote:
>> >
>> >> That is right; you cannot place fields in a page header or footer. To
>> >> get
>> >> round this, put a textbox in the header and use a formula that
>> >> references
>> >> a
>> >> textbox with the field in the body of the report. For example:
>> >>
>> >> =ReportItems!OrderNumber.Value
>> >>
>> >> The above expression can be placed in the page header or footer. It is
>> >> referencing a textbox called OrderNumber. If the textbox displays the
>> >> field
>> >> you want, then the value is also displayed in the textbox that has the
>> >> above
>> >> formula.
>> >>
>> >> Charles Kangai, MCDBA, MCT
>> >>
>> >> "rs_newbie" wrote:
>> >>
>> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
>> >> > Studio's
>> >> > designer friendly interface. So please be patient & simplistic with
>> >> > your
>> >> > responses.
>> >> >
>> >> > If you can't place fields in page headers or footers how can you get
>> >> > fields
>> >> > to repeat on multi-page forms, like shop travelers and packing
>> >> > lists,
>> >> > which
>> >> > repeat customer and order info on every page but changes line item
>> >> > data?
>>|||The problem is that the body has 5 tables and the detail in one of the tables
can span several pages. The other tables don't repeat after page 1. This is a
problem because the information that makes the job traceable is lost . All
you get is a continuation of the detail from the current table with page
header/footer info.
"Brian Welcker [MSFT]" wrote:
> Generally speaking, you don't need to do this as you can have as many tables
> as you want in the body of the report. What is the specific scenario?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> > Thanks everyone. That works great for a few fields. How about whole
> > tables?
> >
> > "Charles Kangai" wrote:
> >
> >> That is right; you cannot place fields in a page header or footer. To get
> >> round this, put a textbox in the header and use a formula that references
> >> a
> >> textbox with the field in the body of the report. For example:
> >>
> >> =ReportItems!OrderNumber.Value
> >>
> >> The above expression can be placed in the page header or footer. It is
> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> field
> >> you want, then the value is also displayed in the textbox that has the
> >> above
> >> formula.
> >>
> >> Charles Kangai, MCDBA, MCT
> >>
> >> "rs_newbie" wrote:
> >>
> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> >> > designer friendly interface. So please be patient & simplistic with
> >> > your
> >> > responses.
> >> >
> >> > If you can't place fields in page headers or footers how can you get
> >> > fields
> >> > to repeat on multi-page forms, like shop travelers and packing lists,
> >> > which
> >> > repeat customer and order info on every page but changes line item
> >> > data?
>
>|||Can you put the tables in a list and say 'repeat on new page'? If they are
not bound to the same data source, you will need to use a subreport.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> The problem is that the body has 5 tables and the detail in one of the
> tables
> can span several pages. The other tables don't repeat after page 1. This
> is a
> problem because the information that makes the job traceable is lost . All
> you get is a continuation of the detail from the current table with page
> header/footer info.
> "Brian Welcker [MSFT]" wrote:
>> Generally speaking, you don't need to do this as you can have as many
>> tables
>> as you want in the body of the report. What is the specific scenario?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
>> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
>> > Thanks everyone. That works great for a few fields. How about whole
>> > tables?
>> >
>> > "Charles Kangai" wrote:
>> >
>> >> That is right; you cannot place fields in a page header or footer. To
>> >> get
>> >> round this, put a textbox in the header and use a formula that
>> >> references
>> >> a
>> >> textbox with the field in the body of the report. For example:
>> >>
>> >> =ReportItems!OrderNumber.Value
>> >>
>> >> The above expression can be placed in the page header or footer. It is
>> >> referencing a textbox called OrderNumber. If the textbox displays the
>> >> field
>> >> you want, then the value is also displayed in the textbox that has the
>> >> above
>> >> formula.
>> >>
>> >> Charles Kangai, MCDBA, MCT
>> >>
>> >> "rs_newbie" wrote:
>> >>
>> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
>> >> > Studio's
>> >> > designer friendly interface. So please be patient & simplistic with
>> >> > your
>> >> > responses.
>> >> >
>> >> > If you can't place fields in page headers or footers how can you get
>> >> > fields
>> >> > to repeat on multi-page forms, like shop travelers and packing
>> >> > lists,
>> >> > which
>> >> > repeat customer and order info on every page but changes line item
>> >> > data?
>>|||Hello-
Best I can tell this technique (ReportItems!SalesTotal.Value) only
displays data on the first page... fairly worthless for my purposes
anyway...
JCF|||It displays data on every page in which ReportItems!SalesTotal.Value exists.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"CodeFester" <fischerjc@.hotmail.com> wrote in message
news:1114809018.195146.312890@.f14g2000cwb.googlegroups.com...
> Hello-
> Best I can tell this technique (ReportItems!SalesTotal.Value) only
> displays data on the first page... fairly worthless for my purposes
> anyway...
> JCF
>|||Thanks Brian!
The list is working great in Visual Studio. The Preview ,Run and Print
Preview all show a proper rendering of the reports.
However, after deployment, the Report Manager shows several blank data
fields. The print preview is not pulling in the 0.000in margins that I've set
in my report properties. The settings are all 0.500in. If I change them to 0
the preview shows the missing data, and so does the printout. Any ideas?
Is there a way to use the same Preview/Print Preview in Report Manager that
Visual Studio uses?
"Brian Welcker [MSFT]" wrote:
> Can you put the tables in a list and say 'repeat on new page'? If they are
> not bound to the same data source, you will need to use a subreport.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> > The problem is that the body has 5 tables and the detail in one of the
> > tables
> > can span several pages. The other tables don't repeat after page 1. This
> > is a
> > problem because the information that makes the job traceable is lost . All
> > you get is a continuation of the detail from the current table with page
> > header/footer info.
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Generally speaking, you don't need to do this as you can have as many
> >> tables
> >> as you want in the body of the report. What is the specific scenario?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> >> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> >> > Thanks everyone. That works great for a few fields. How about whole
> >> > tables?
> >> >
> >> > "Charles Kangai" wrote:
> >> >
> >> >> That is right; you cannot place fields in a page header or footer. To
> >> >> get
> >> >> round this, put a textbox in the header and use a formula that
> >> >> references
> >> >> a
> >> >> textbox with the field in the body of the report. For example:
> >> >>
> >> >> =ReportItems!OrderNumber.Value
> >> >>
> >> >> The above expression can be placed in the page header or footer. It is
> >> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> >> field
> >> >> you want, then the value is also displayed in the textbox that has the
> >> >> above
> >> >> formula.
> >> >>
> >> >> Charles Kangai, MCDBA, MCT
> >> >>
> >> >> "rs_newbie" wrote:
> >> >>
> >> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
> >> >> > Studio's
> >> >> > designer friendly interface. So please be patient & simplistic with
> >> >> > your
> >> >> > responses.
> >> >> >
> >> >> > If you can't place fields in page headers or footers how can you get
> >> >> > fields
> >> >> > to repeat on multi-page forms, like shop travelers and packing
> >> >> > lists,
> >> >> > which
> >> >> > repeat customer and order info on every page but changes line item
> >> >> > data?
> >>
> >>
> >>
>
>|||Do you have an example of how to get a specific table to repeat on every page
as well as individual fields (that change depending on the group) from a
table?
I'm pretty new to SRS and I need to get up to speed really fast.
Thanks in advance.
"Brian Welcker [MSFT]" wrote:
> Can you put the tables in a list and say 'repeat on new page'? If they are
> not bound to the same data source, you will need to use a subreport.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> > The problem is that the body has 5 tables and the detail in one of the
> > tables
> > can span several pages. The other tables don't repeat after page 1. This
> > is a
> > problem because the information that makes the job traceable is lost . All
> > you get is a continuation of the detail from the current table with page
> > header/footer info.
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Generally speaking, you don't need to do this as you can have as many
> >> tables
> >> as you want in the body of the report. What is the specific scenario?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> >> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> >> > Thanks everyone. That works great for a few fields. How about whole
> >> > tables?
> >> >
> >> > "Charles Kangai" wrote:
> >> >
> >> >> That is right; you cannot place fields in a page header or footer. To
> >> >> get
> >> >> round this, put a textbox in the header and use a formula that
> >> >> references
> >> >> a
> >> >> textbox with the field in the body of the report. For example:
> >> >>
> >> >> =ReportItems!OrderNumber.Value
> >> >>
> >> >> The above expression can be placed in the page header or footer. It is
> >> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> >> field
> >> >> you want, then the value is also displayed in the textbox that has the
> >> >> above
> >> >> formula.
> >> >>
> >> >> Charles Kangai, MCDBA, MCT
> >> >>
> >> >> "rs_newbie" wrote:
> >> >>
> >> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
> >> >> > Studio's
> >> >> > designer friendly interface. So please be patient & simplistic with
> >> >> > your
> >> >> > responses.
> >> >> >
> >> >> > If you can't place fields in page headers or footers how can you get
> >> >> > fields
> >> >> > to repeat on multi-page forms, like shop travelers and packing
> >> >> > lists,
> >> >> > which
> >> >> > repeat customer and order info on every page but changes line item
> >> >> > data?
> >>
> >>
> >>
>
>

no DTS

I have just installed sQL sever 2005

now i need to import data from ms access.

i went to "Introducing Business Intelligence Development Studio "/file/ new project

and

nothing about DTS or anything related to import export is there.

But when i look at the online help i see it.

what can I do about this? I have no access to any kind of DTS at all.

thank you all

Try the What's New sections in Books Online, or one of the myriad of SQL related web sites, but basically DTS is no more, it has been replaced by SQL Server Integration Services (SSIS). Perhaps you know that as you are posting in a SSIS forum, in which case what is your question?

To do simple import/export tasks, use the wizard. Of the several methods to get access to it, I normally right click a database in SQL Server Management Studio, and select the option.

|||

Do you see "Integration Services Project" in the Temnplates list in the New Project dialog box?

if you do not, then you either did not install SSIS or there is a problem with your installation.

Please note: There is no "DTS" in SQL Server 2005. SSIS ( SQL Server Integration Services ) is the replacement for DTS.

|||

no its not there at all. I will reinstall again. and another thing

access 2000 cant make tables in sql server 2005 ..whats up with that?

|||

AnonymousNothingworks wrote:

access 2000 cant make tables in sql server 2005 ..whats up with that?

You may need to take this question to another forum - I'm not sure what to tell you there...

No BI Dev Studio after install of Dev edition

I recently installed the Developerâ's edition of SQL Server 2005 so I could
check out the report builder.
After installing on a XP Pro workstation, I looked and it doesnâ't appear to
have installed the Business Intelligence Developer Studio.
Is this not included in the Dev Edition?
Thanks in advance.Are you sure that you selected the option to install workstation components,
books online and development tools. If you did not, BIDS will not be
installed.
Ed.
"rstevens" <rstevens@.discussions.microsoft.com> wrote in message
news:DDE881F0-1682-4B8C-B349-C99EAC4B7D02@.microsoft.com...
>I recently installed the Developer's edition of SQL Server 2005 so I could
> check out the report builder.
> After installing on a XP Pro workstation, I looked and it doesn't appear
> to
> have installed the Business Intelligence Developer Studio.
> Is this not included in the Dev Edition?
> Thanks in advance.
>|||I could have sworn that I told it to install the dev tools, but apparently
hadn't.
Thanks, that was it.
"Ed Allison" wrote:
> Are you sure that you selected the option to install workstation components,
> books online and development tools. If you did not, BIDS will not be
> installed.
> Ed.
> "rstevens" <rstevens@.discussions.microsoft.com> wrote in message
> news:DDE881F0-1682-4B8C-B349-C99EAC4B7D02@.microsoft.com...
> >I recently installed the Developer's edition of SQL Server 2005 so I could
> > check out the report builder.
> >
> > After installing on a XP Pro workstation, I looked and it doesn't appear
> > to
> > have installed the Business Intelligence Developer Studio.
> >
> > Is this not included in the Dev Edition?
> >
> > Thanks in advance.
> >
>
>

No aggregations for Measure Group possible in Analysis Server 2005

I have a cube with about 20 Measure Groups and 30 dimensions. I built some dimensions using BI Development Studio a few weeks ago. The aggregations were build for any measure group without problems.

Now I changed some attributes and want to run the aggregation wizard on my test plattform to design new aggregations. But there were no aggregations build. It shows 0 aggregations.

I read that sometimes this happens when the cube is too complex. But the complexity did not grow very much.

What should I do to be able to design aggregations again?

Best regards,
Stefoon

There is an exellent writeup about aggregations in performance guide.

Chirs's blog is good source for information http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!907.entry

Edward.

--

This posting is provided "AS IS" with no warranties, and confers no rights.

No ability to create maintanance plan in sql server 2005

Hello,
i try to create a new maintenance plan in the sql management studio.
i tried it with windows xp (x86, german), 2003 enterprise / standard (both
x64 and english), sql server developer x86/x64 (english and german),
enterprise x64 (english).
to create it i use the wizard, every time and constellation ends with the
same error:
steps:
1) select windows authentication (same with sa in sql authentication)
2) check database integrity (or any other job)
3) select database master (or any other)
4) not scheduled (no other effect if scheduled)
5) no reporting (no other effect if reported)
6) Finish
Error:
Maintenance Plan Wizard Progress
- Creating maintenance plan "MaintenancePlan" (Error)
Messages
* Create maintenance plan failed.
--
ADDITIONAL INFORMATION:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
- Adding tasks to the maintenance plan (Stopped)
- Adding scheduling options (Stopped)
- Adding reporting options (Stopped)
- Saving maintenance plan "MaintenancePlan" (Stopped)
Has anyone any idea about thies?I'm not sure but perhaps you get this error if you didn't install Integration Services...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
news:D2C35CAD-1CE9-4F7F-9FB0-DDB6BABD670E@.microsoft.com...
> Hello,
> i try to create a new maintenance plan in the sql management studio.
> i tried it with windows xp (x86, german), 2003 enterprise / standard (both
> x64 and english), sql server developer x86/x64 (english and german),
> enterprise x64 (english).
> to create it i use the wizard, every time and constellation ends with the
> same error:
> steps:
> 1) select windows authentication (same with sa in sql authentication)
> 2) check database integrity (or any other job)
> 3) select database master (or any other)
> 4) not scheduled (no other effect if scheduled)
> 5) no reporting (no other effect if reported)
> 6) Finish
> Error:
> Maintenance Plan Wizard Progress
> - Creating maintenance plan "MaintenancePlan" (Error)
> Messages
> * Create maintenance plan failed.
> --
> ADDITIONAL INFORMATION:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
> - Adding tasks to the maintenance plan (Stopped)
> - Adding scheduling options (Stopped)
> - Adding reporting options (Stopped)
> - Saving maintenance plan "MaintenancePlan" (Stopped)
> Has anyone any idea about thies?
>|||thank you, this seems to be the solution!
"Tibor Karaszi" schrieb:
> I'm not sure but perhaps you get this error if you didn't install Integration Services...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
> news:D2C35CAD-1CE9-4F7F-9FB0-DDB6BABD670E@.microsoft.com...
> > Hello,
> >
> > i try to create a new maintenance plan in the sql management studio.
> > i tried it with windows xp (x86, german), 2003 enterprise / standard (both
> > x64 and english), sql server developer x86/x64 (english and german),
> > enterprise x64 (english).
> > to create it i use the wizard, every time and constellation ends with the
> > same error:
> >
> > steps:
> > 1) select windows authentication (same with sa in sql authentication)
> > 2) check database integrity (or any other job)
> > 3) select database master (or any other)
> > 4) not scheduled (no other effect if scheduled)
> > 5) no reporting (no other effect if reported)
> > 6) Finish
> >
> > Error:
> > Maintenance Plan Wizard Progress
> > - Creating maintenance plan "MaintenancePlan" (Error)
> > Messages
> > * Create maintenance plan failed.
> > --
> > ADDITIONAL INFORMATION:
> > Create failed for JobStep 'Subplan'.
> > (Microsoft.SqlServer.MaintenancePlanTasks)
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
> > --
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> > --
> > The specified '@.subsystem' is invalid (valid values are returned by
> > sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
> > - Adding tasks to the maintenance plan (Stopped)
> > - Adding scheduling options (Stopped)
> > - Adding reporting options (Stopped)
> > - Saving maintenance plan "MaintenancePlan" (Stopped)
> >
> > Has anyone any idea about thies?
> >
>
>sql

No ability to create maintanance plan in sql server 2005

Hello,
i try to create a new maintenance plan in the sql management studio.
i tried it with Windows XP (x86, german), 2003 enterprise / standard (both
x64 and english), sql server developer x86/x64 (english and german),
enterprise x64 (english).
to create it i use the wizard, every time and constellation ends with the
same error:
steps:
1) select windows authentication (same with sa in sql authentication)
2) check database integrity (or any other job)
3) select database master (or any other)
4) not scheduled (no other effect if scheduled)
5) no reporting (no other effect if reported)
6) Finish
Error:
Maintenance Plan Wizard Progress
- Creating maintenance plan "MaintenancePlan" (Error)
Messages
* Create maintenance plan failed.
--
ADDITIONAL INFORMATION:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
For help, click:
http://go.microsoft.com/fwlink?Prod...ep&LinkId=20476
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
For help, click:
http://go.microsoft.com/fwlink?Prod...34&LinkId=20476
- Adding tasks to the maintenance plan (Stopped)
- Adding scheduling options (Stopped)
- Adding reporting options (Stopped)
- Saving maintenance plan "MaintenancePlan" (Stopped)
Has anyone any idea about thies?I'm not sure but perhaps you get this error if you didn't install Integratio
n Services...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
news:D2C35CAD-1CE9-4F7F-9FB0-DDB6BABD670E@.microsoft.com...
> Hello,
> i try to create a new maintenance plan in the sql management studio.
> i tried it with Windows XP (x86, german), 2003 enterprise / standard (both
> x64 and english), sql server developer x86/x64 (english and german),
> enterprise x64 (english).
> to create it i use the wizard, every time and constellation ends with the
> same error:
> steps:
> 1) select windows authentication (same with sa in sql authentication)
> 2) check database integrity (or any other job)
> 3) select database master (or any other)
> 4) not scheduled (no other effect if scheduled)
> 5) no reporting (no other effect if reported)
> 6) Finish
> Error:
> Maintenance Plan Wizard Progress
> - Creating maintenance plan "MaintenancePlan" (Error)
> Messages
> * Create maintenance plan failed.
> --
> ADDITIONAL INFORMATION:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...ep&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...34&LinkId=20476
> - Adding tasks to the maintenance plan (Stopped)
> - Adding scheduling options (Stopped)
> - Adding reporting options (Stopped)
> - Saving maintenance plan "MaintenancePlan" (Stopped)
> Has anyone any idea about thies?
>|||thank you, this seems to be the solution!
"Tibor Karaszi" schrieb:

> I'm not sure but perhaps you get this error if you didn't install Integrat
ion Services...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
> news:D2C35CAD-1CE9-4F7F-9FB0-DDB6BABD670E@.microsoft.com...
>
>

No "Maintenance Plans" under SQL Server 2005

Running "SQL Server Mgmt Studio"
For the software "SQL Server 2005"
Under the SERVER instance, there's Mgmt -> Maint Plans.
Under SERVER\INSTANCE, there's no Maintenance Plans.
The DBs I need to back up are under SERVER\INSTANCE.
Any idea why my server instance does not have the option?
Thanks,
ScottThere are none by default, you have to create them. Right click and say "New
Maintenance Plan" or choose the wizard.
--
Andrew J. Kelly SQL MVP
"Scott Moseman" <scmoseman@.gmail.com> wrote in message
news:1157491039.842488.194100@.m79g2000cwm.googlegroups.com...
> Running "SQL Server Mgmt Studio"
> For the software "SQL Server 2005"
> Under the SERVER instance, there's Mgmt -> Maint Plans.
> Under SERVER\INSTANCE, there's no Maintenance Plans.
> The DBs I need to back up are under SERVER\INSTANCE.
> Any idea why my server instance does not have the option?
> Thanks,
> Scott
>|||Scott Moseman wrote:
> Running "SQL Server Mgmt Studio"
> For the software "SQL Server 2005"
> Under the SERVER instance, there's Mgmt -> Maint Plans.
> Under SERVER\INSTANCE, there's no Maintenance Plans.
> The DBs I need to back up are under SERVER\INSTANCE.
> Any idea why my server instance does not have the option?
> Thanks,
> Scott
>
Skip the maintenance plan and use a scheduled T-SQL script to do your
backups. See
http://realsqlguy.com/serendipity/archives/11-Send-In-Backup!.html for a
script that will backup every database on your server, all you have to
do is schedule it to run.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I'm not talking about it missing a maintenance plan, I'm talking
about the Management folder not even having the Maintenance
Plan subfolder under which you'd add any new plans. Adding a
maintenance plan is not a problem, but there's no place to do it.
Thanks,
Scott
Andrew J. Kelly wrote:
> There are none by default, you have to create them. Right click
> and say "New Maintenance Plan" or choose the wizard.
> --
> Andrew J. Kelly SQL MVP
>
> "Scott Moseman" <scmoseman@.gmail.com> wrote:
> > Running "SQL Server Mgmt Studio"
> > For the software "SQL Server 2005"
> >
> > Under the SERVER instance, there's Mgmt -> Maint Plans.
> > Under SERVER\INSTANCE, there's no Maintenance Plans.
> >
> > The DBs I need to back up are under SERVER\INSTANCE.
> > Any idea why my server instance does not have the option?
> >
> > Thanks,
> > Scott
> >|||Hi,
I had the same problem.
You need to install Integration Services also for that instance
SERVER\INSTANCE.
HTH
Flor
Tracy McKibben a =E9crit :
> Scott Moseman wrote:
> > Running "SQL Server Mgmt Studio"
> > For the software "SQL Server 2005"
> >
> > Under the SERVER instance, there's Mgmt -> Maint Plans.
> > Under SERVER\INSTANCE, there's no Maintenance Plans.
> >
> > The DBs I need to back up are under SERVER\INSTANCE.
> > Any idea why my server instance does not have the option?
> >
> > Thanks,
> > Scott
> >
> Skip the maintenance plan and use a scheduled T-SQL script to do your
> backups. See
> http://realsqlguy.com/serendipity/archives/11-Send-In-Backup!.html for a
> script that will backup every database on your server, all you have to
> do is schedule it to run.
> > > -- > Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

No "Maintenance Plans" under SQL Server 2005

Running "SQL Server Mgmt Studio"
For the software "SQL Server 2005"
Under the SERVER instance, there's Mgmt -> Maint Plans.
Under SERVER\INSTANCE, there's no Maintenance Plans.
The DBs I need to back up are under SERVER\INSTANCE.
Any idea why my server instance does not have the option?
Thanks,
ScottThere are none by default, you have to create them. Right click and say "New
Maintenance Plan" or choose the wizard.
Andrew J. Kelly SQL MVP
"Scott Moseman" <scmoseman@.gmail.com> wrote in message
news:1157491039.842488.194100@.m79g2000cwm.googlegroups.com...
> Running "SQL Server Mgmt Studio"
> For the software "SQL Server 2005"
> Under the SERVER instance, there's Mgmt -> Maint Plans.
> Under SERVER\INSTANCE, there's no Maintenance Plans.
> The DBs I need to back up are under SERVER\INSTANCE.
> Any idea why my server instance does not have the option?
> Thanks,
> Scott
>|||Scott Moseman wrote:
> Running "SQL Server Mgmt Studio"
> For the software "SQL Server 2005"
> Under the SERVER instance, there's Mgmt -> Maint Plans.
> Under SERVER\INSTANCE, there's no Maintenance Plans.
> The DBs I need to back up are under SERVER\INSTANCE.
> Any idea why my server instance does not have the option?
> Thanks,
> Scott
>
Skip the maintenance plan and use a scheduled T-SQL script to do your
backups. See
http://realsqlguy.com/serendipity/a...-Send-In-Backup!.html for a
script that will backup every database on your server, all you have to
do is schedule it to run.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I'm not talking about it missing a maintenance plan, I'm talking
about the Management folder not even having the Maintenance
Plan subfolder under which you'd add any new plans. Adding a
maintenance plan is not a problem, but there's no place to do it.
Thanks,
Scott
Andrew J. Kelly wrote:[vbcol=seagreen]
> There are none by default, you have to create them. Right click
> and say "New Maintenance Plan" or choose the wizard.
> --
> Andrew J. Kelly SQL MVP
>
> "Scott Moseman" <scmoseman@.gmail.com> wrote:
>|||Hi,
I had the same problem.
You need to install Integration Services also for that instance
SERVER\INSTANCE.
HTH
Flor
Tracy McKibben a =E9crit :

> Scott Moseman wrote:
> Skip the maintenance plan and use a scheduled T-SQL script to do your
> backups. See
> http://realsqlguy.com/serendipity/a...-Send-In-Backup!.html for a
> script that will backup every database on your server, all you have to
> do is schedule it to run.
>=20
>=20
> --=20
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

No "(local)" server name in servers list for SQL Server 2005

I have a new install of SQL SERVER 2005 on a new machine.
When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
or MS Access ADE Connection "Data Link Properties", there is no (local)
entry in drop-down "server Name" list. However the actual server name is
listed and I can use it for successful connection.
My main problem is that I am trying to get from SourceSafe a big Access ADE
project and it complains that it is not able to connect to (local) server for
almost each form/report.
Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
problem with my installation?
If it is a setup problem, how can I add (local) to the list of available
servers?
By the way,when I manually typed "(local)" server name, VS 2005 "add
connection" accepted it , but ADE Connection "Data Link Properties" reported
"Sql Server doesn't exist or access is denied"
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
I was able to fix the problem. ADE Connection "Data Link Properties" accepts
manually typed "(local)" after I changed the following:
1. In SQL Server 2005 Configuration Manager selected "SQL server 2005
Network Configuration/Protocols for MSSQLSERVER" and enabled "Tcp/IP".
Note that "SQL Native Client Configuration/Client Configuration" had already
"Tcp/IP" enabled.
2. Restarted SQL Server service.
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
"Michael Freidgeim" wrote:

> I have a new install of SQL SERVER 2005 on a new machine.
> When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
> or MS Access ADE Connection "Data Link Properties", there is no (local)
> entry in drop-down "server Name" list. However the actual server name is
> listed and I can use it for successful connection.
> My main problem is that I am trying to get from SourceSafe a big Access ADE
> project and it complains that it is not able to connect to (local) server for
> almost each form/report.
> Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
> problem with my installation?
> If it is a setup problem, how can I add (local) to the list of available
> servers?
> By the way,when I manually typed "(local)" server name, VS 2005 "add
> connection" accepted it , but ADE Connection "Data Link Properties" reported
> "Sql Server doesn't exist or access is denied"
> Michael Freidgeim.
> <a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
> My Blog: http://geekswithblogs.net/mnf/
> </a>

No "(local)" server name in servers list for SQL Server 2005

I have a new install of SQL SERVER 2005 on a new machine.
When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
or MS Access ADE Connection "Data Link Properties", there is no (local)
entry in drop-down "server Name" list. However the actual server name is
listed and I can use it for successful connection.
My main problem is that I am trying to get from SourceSafe a big Access ADE
project and it complains that it is not able to connect to (local) server fo
r
almost each form/report.
Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
problem with my installation?
If it is a setup problem, how can I add (local) to the list of available
servers?
By the way,when I manually typed "(local)" server name, VS 2005 "add
connection" accepted it , but ADE Connection "Data Link Properties" reporte
d
"Sql Server doesn't exist or access is denied"
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>I was able to fix the problem. ADE Connection "Data Link Properties" accept
s
manually typed "(local)" after I changed the following:
1. In SQL Server 2005 Configuration Manager selected "SQL server 2005
Network Configuration/Protocols for MSSQLSERVER" and enabled "Tcp/IP".
Note that "SQL Native Client Configuration/Client Configuration" had already
"Tcp/IP" enabled.
2. Restarted SQL Server service.
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
"Michael Freidgeim" wrote:

> I have a new install of SQL SERVER 2005 on a new machine.
> When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
> or MS Access ADE Connection "Data Link Properties", there is no (local)
> entry in drop-down "server Name" list. However the actual server name is
> listed and I can use it for successful connection.
> My main problem is that I am trying to get from SourceSafe a big Access AD
E
> project and it complains that it is not able to connect to (local) server
for
> almost each form/report.
> Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
> problem with my installation?
> If it is a setup problem, how can I add (local) to the list of available
> servers?
> By the way,when I manually typed "(local)" server name, VS 2005 "add
> connection" accepted it , but ADE Connection "Data Link Properties" repor
ted
> "Sql Server doesn't exist or access is denied"
> Michael Freidgeim.
> <a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
> My Blog: http://geekswithblogs.net/mnf/
> </a>

NEWSEQUENTIALID()

I'm trying to modify my default value for GUIDs in DB, currently using newid() for default.

In management studio, click on modify and in the table designer for the default value I entered newsequentialid() and got the following error.

Error validating the default for column "xxxx".

I would like to have my tables that are using guids, have newsequentialid as the default value. When read on this new function it says can only be used with default value, but can't get that to work. Any ideas?

thanks

This is a bug in Management Studio. There are two workarounds

1. Create the table by hand in T-SQL.

2. Use newid, then generate a script, and replace the newid with newsequential.

You can file a bug at http://lab.msdn.microsoft.com/productfeedback/

|||I can set the default value OK in management studio if it is a brand new table. I'm trying to upgrade my tables in my DB to have the default to be newsequentialId(). Is there a problem if there is already data in the tables with now changing from newid() to newsequentialid()|||

Why on earth is this not fixed yet AND there doesn't seem to be any official Microsoft posting or commment regarding this?

Seriously annoying bug.

|||

If we cannot answer a question in the forums in the first month, it generally gets ignored and we do not go back and try to answer it later. Whenever there is a problem with our product, I strongly recommend filing a bug or a suggestion in Microsoft Connect.

SQL Server's portal on Microsoft Connect: http://connect.microsoft.com/SQLServer/

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

NEWSEQUENTIALID()

I'm trying to modify my default value for GUIDs in DB, currently using newid() for default.

In management studio, click on modify and in the table designer for the default value I entered newsequentialid() and got the following error.

Error validating the default for column "xxxx".

I would like to have my tables that are using guids, have newsequentialid as the default value. When read on this new function it says can only be used with default value, but can't get that to work. Any ideas?

thanks

This is a bug in Management Studio. There are two workarounds

1. Create the table by hand in T-SQL.

2. Use newid, then generate a script, and replace the newid with newsequential.

You can file a bug at http://lab.msdn.microsoft.com/productfeedback/

|||I can set the default value OK in management studio if it is a brand new table. I'm trying to upgrade my tables in my DB to have the default to be newsequentialId(). Is there a problem if there is already data in the tables with now changing from newid() to newsequentialid()|||

Why on earth is this not fixed yet AND there doesn't seem to be any official Microsoft posting or commment regarding this?

Seriously annoying bug.

|||

If we cannot answer a question in the forums in the first month, it generally gets ignored and we do not go back and try to answer it later. Whenever there is a problem with our product, I strongly recommend filing a bug or a suggestion in Microsoft Connect.

SQL Server's portal on Microsoft Connect: http://connect.microsoft.com/SQLServer/

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

NEWSEQUENTIALID()

I'm trying to modify my default value for GUIDs in DB, currently using newid() for default.

In management studio, click on modify and in the table designer for the default value I entered newsequentialid() and got the following error.

Error validating the default for column "xxxx".

I would like to have my tables that are using guids, have newsequentialid as the default value. When read on this new function it says can only be used with default value, but can't get that to work. Any ideas?

thanks

This is a bug in Management Studio. There are two workarounds

1. Create the table by hand in T-SQL.

2. Use newid, then generate a script, and replace the newid with newsequential.

You can file a bug at http://lab.msdn.microsoft.com/productfeedback/

|||I can set the default value OK in management studio if it is a brand new table. I'm trying to upgrade my tables in my DB to have the default to be newsequentialId(). Is there a problem if there is already data in the tables with now changing from newid() to newsequentialid()|||

Why on earth is this not fixed yet AND there doesn't seem to be any official Microsoft posting or commment regarding this?

Seriously annoying bug.

|||

If we cannot answer a question in the forums in the first month, it generally gets ignored and we do not go back and try to answer it later. Whenever there is a problem with our product, I strongly recommend filing a bug or a suggestion in Microsoft Connect.

SQL Server's portal on Microsoft Connect: http://connect.microsoft.com/SQLServer/

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/