How to remove Projects and reports from web browser

I am creating, building, and deploying reports via a web browser interface in SQL 2005 Visual Studio. There are a few projects that I no longer want the masses to see when the go to \\servername\reportserver. I have deleted all files associated with the projects and reports, and removed them from within the report server, but when I open the web browser I can still see the old projects and open the reports.

Where is the browser getting this information even though the data doesn't even exist as far as i can tell, and how to I actually delete those entries that i no longer want seen.

I have heard that I can go the actual web page itself, and delete the items using "show details", but I am unfamiliar with where exactly that is and how to use it.

Any advice or help would be greatly appreciated - thanks everyone!

Go to your Report Manager. (http://ServerName/Reports)
Over on the right, you will see a button named 'Show Details'.
From there, you can check the boxes of the folders you want to delete (or navigate further down to find the specific objects you want to remove).
Click the 'Delete' button which will be on the left.
It will ask if you are sure you want to delete them, click 'Yes'.

Hope this helps.

Jarret

|||Thanks - worked like a charm!

How to refresh Full Text Indexes?

Hi All,

i am using full text search in stored procedure for my web application search-engine.

how do i refresh my fulltext indexes which i created using unique indexes?

as i can see two options tart full population and Start Incremental population in full-text index on right click of table.

on click of anyone its showing successful.

can anyone please let me know what is the standard way to refresh full text indexes periodically in terms of best performance? i found, when i run query first time with contains keyword , it takes much time.

what enterprise settings required to increase performance?

Thanks in advance.

When you start a population of a fulltext catalog, it reports successful but that only means its started successfully. The population can take a while depending on size of columns, number of rows etc.

Depending on the size of the index and how long it takes to do a full population, you may want to do run regular incremental populations which will only update the records that have been added/changed since the last full population. Population is quite a resource intensive process so be aware of what effect it has on your application. Also remember you'll need to add a timestamp field to any tables which you want to do incremental populations on.

If you need to realtime updates to happen, look into enabling change tracking/background update which will keep your index in sync with the data. Otherwise, new/changed rows won't be reflected in your fulltext index until you do another population.

As with any index, as data gets added and removed the index becomes fragmented so i'd look to schedule a rebuild of the catalog periodically (how frequent is up to you).

The first query may have been slow as the population may still have been in progress. Look at FULLTEXTCATALOGPROPERTY to check the size of the index and the current population status.

HTH!

|||

Hello,

thanks a lot for the reply.

can you please verify the way how i created Index?

create fulltext catalog MyFullTextCatalog

create unique index ui_AssetID on EMAM_Assets(ID)

create fulltext index on EMAM_Assets(title,asset_desc) KEY INDEX ui_AssetID on MyFullTextCatalog
with CHANGE_TRACKING AUTO

i created full text index as mentioned above. i want to perform search on title and asset_desc.

I created one schedule (daily) on table -> full text properties to populate full text index. I didnt get your point about timestamp. where do i need to add and how to use it? where will it be helpful?

second, i click on Full text Catalog property, its showing error: Property FullTextIndexSize is not available for FulltextCatalog. This property may not exist or may not be retrieved. once i click on OK on this error alert, its opening Full Text Catalog Property. Is it something wrong?

Please guide me in set up Administration configuration for Full Text Index. I am working on Search Engine and Query performance is very much important. i having 5 tables on which i need to perform search.

|||

You need to add a new column to the table you are running incremental populations on with a datatype of TIMESTAMP, the value of which is controlled by SQL Server to keep track of changes to records in the table.

With the commands you have used, SQL Server should populate the catalog as soon as the index is created. Rather than using the GUI to check the property, use FULLTEXTCATALOGPROPERTY in a query window (see Books Online for more details). The error you get may be related to the GUI rather than your full text catalog.

Have a look at the following link which has some great tips on Full Text Searching:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx

HTH!

|||

Hi,

thanks for valuable input.

I created full text index with Change Track Automatically.

As i understand, in that case i need not to worry about full text population. is that right?

Full text index refresh will be done automatically. right?

let me know if it is required in this case also.

i already removed schedule for full text index population.

now i am facing on big problem is that: Query taking around 1 min while executing first time.

after that if u will be sit ideal for around 20 min then once again query will take more time.

instant execution followed by first one will result very fast.

I will check for cache memory and I/O for that. i think it could be reason.

Please let me know if you have any idea.

Thanks.

|||

You're right- once you've enabled change tracking a Full Population should happen automatically and the index will be maintained by sql server.

Make sure that the initial full population of the catalog has completed before running a query as it will be quite a resource intensive process and may be the cause of your slow query,

Good luck!

How to refresh Full Text Indexes?

Hi All,

i am using full text search in stored procedure for my web application search-engine.

how do i refresh my fulltext indexes which i created using unique indexes?

as i can see two options tart full population and Start Incremental population in full-text index on right click of table.

on click of anyone its showing successful.

can anyone please let me know what is the standard way to refresh full text indexes periodically in terms of best performance? i found, when i run query first time with contains keyword , it takes much time.

what enterprise settings required to increase performance?

Thanks in advance.

When you start a population of a fulltext catalog, it reports successful but that only means its started successfully. The population can take a while depending on size of columns, number of rows etc.

Depending on the size of the index and how long it takes to do a full population, you may want to do run regular incremental populations which will only update the records that have been added/changed since the last full population. Population is quite a resource intensive process so be aware of what effect it has on your application. Also remember you'll need to add a timestamp field to any tables which you want to do incremental populations on.

If you need to realtime updates to happen, look into enabling change tracking/background update which will keep your index in sync with the data. Otherwise, new/changed rows won't be reflected in your fulltext index until you do another population.

As with any index, as data gets added and removed the index becomes fragmented so i'd look to schedule a rebuild of the catalog periodically (how frequent is up to you).

The first query may have been slow as the population may still have been in progress. Look at FULLTEXTCATALOGPROPERTY to check the size of the index and the current population status.

HTH!

|||

Hello,

thanks a lot for the reply.

can you please verify the way how i created Index?

create fulltext catalog MyFullTextCatalog

create unique index ui_AssetID on EMAM_Assets(ID)

create fulltext index on EMAM_Assets(title,asset_desc) KEY INDEX ui_AssetID on MyFullTextCatalog
with CHANGE_TRACKING AUTO

i created full text index as mentioned above. i want to perform search on title and asset_desc.

I created one schedule (daily) on table -> full text properties to populate full text index. I didnt get your point about timestamp. where do i need to add and how to use it? where will it be helpful?

second, i click on Full text Catalog property, its showing error: Property FullTextIndexSize is not available for FulltextCatalog. This property may not exist or may not be retrieved. once i click on OK on this error alert, its opening Full Text Catalog Property. Is it something wrong?

Please guide me in set up Administration configuration for Full Text Index. I am working on Search Engine and Query performance is very much important. i having 5 tables on which i need to perform search.

|||

You need to add a new column to the table you are running incremental populations on with a datatype of TIMESTAMP, the value of which is controlled by SQL Server to keep track of changes to records in the table.

With the commands you have used, SQL Server should populate the catalog as soon as the index is created. Rather than using the GUI to check the property, use FULLTEXTCATALOGPROPERTY in a query window (see Books Online for more details). The error you get may be related to the GUI rather than your full text catalog.

Have a look at the following link which has some great tips on Full Text Searching:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx

HTH!

|||

Hi,

thanks for valuable input.

I created full text index with Change Track Automatically.

As i understand, in that case i need not to worry about full text population. is that right?

Full text index refresh will be done automatically. right?

let me know if it is required in this case also.

i already removed schedule for full text index population.

now i am facing on big problem is that: Query taking around 1 min while executing first time.

after that if u will be sit ideal for around 20 min then once again query will take more time.

instant execution followed by first one will result very fast.

I will check for cache memory and I/O for that. i think it could be reason.

Please let me know if you have any idea.

Thanks.

|||

You're right- once you've enabled change tracking a Full Population should happen automatically and the index will be maintained by sql server.

Make sure that the initial full population of the catalog has completed before running a query as it will be quite a resource intensive process and may be the cause of your slow query,

Good luck!

How to refresh Access Table from SSIS package?

Hi all,

I have created an SSIS package to export rows of data from SQL to Access using SSIS package. The package is executed from asp.net web application. Below is what i want to achieve:

-User enters a date range

-SSIS package will export data between the date range from SQL to Access database.

-When user enter another date range, I want to clear the contents of the Access database. (Im using Execute Sql Task-- Delete tablename)

The problem is that when I look at the table after the second user request, the fields will show #deleted. Only after i click refresh will the new data appear. How can I make the data appear without manually refreshing the Access table.

Thks alot.

Can't you just drop off the access table and re-create it upon every user request ?

|||

Hi,

dropping the table means that I will need to create a the table again at the OLE DB destination. However I am unable to do that. I tried to use SQL command data access mode to create table. However, I received an error "CREATE TABLE SQL is not supported".

|||

Hi,

if it is not possible to refresh the Access table, can any expert here advise me on how to create a table when executing the package? The only way to go now is to drop the table and create a new table to solve my problem, but i am facing this problem of creating table.

Thks

How to redirect report to a frame?

Hi,
I've a web application. The default page consists of
three frames. 'List bar frame', 'Banner frame' and 'Main
frame'. Reports are displayed on this 'Main frame'.
I've a report which has got a column which is linked to
another report. I want the second report to be displayed
in the same frme ('Main frame'). Right now while
clicking the link column, report is displayed in the
parent frame, there by I'm loosing list bar and banner in
the application. How do I do this?
thanks,
DeeWhen you access the parent report in your frame, add the URL access
parameter rc:LinkTarget=framename. This will target all of the hyperlinks in
the report. You can also do stuff like rc:LinkTarget=_blank to open in a new
window.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Deepak" <deee@.discussions.microsoft.com> wrote in message
news:02e201c46d7c$f84dff50$a501280a@.phx.gbl...
> Hi,
> I've a web application. The default page consists of
> three frames. 'List bar frame', 'Banner frame' and 'Main
> frame'. Reports are displayed on this 'Main frame'.
> I've a report which has got a column which is linked to
> another report. I want the second report to be displayed
> in the same frme ('Main frame'). Right now while
> clicking the link column, report is displayed in the
> parent frame, there by I'm loosing list bar and banner in
> the application. How do I do this?
> thanks,
> Dee|||After giving rc:LinkTarget=framename, second report is
opening in a new window. Not in the given frame. I'm
using Jump to report method for calling 2nd report.
thanks,
Deee
>--Original Message--
>When you access the parent report in your frame, add the
URL access
>parameter rc:LinkTarget=framename. This will target all
of the hyperlinks in
>the report. You can also do stuff like
rc:LinkTarget=_blank to open in a new
>window.
>--
>Bryan Keller
>Developer Documentation
>SQL Server Reporting Services
>A friendly reminder that this posting is provided "AS
IS" with no
>warranties, and confers no rights.
>
>"Deepak" <deee@.discussions.microsoft.com> wrote in
message
>news:02e201c46d7c$f84dff50$a501280a@.phx.gbl...
>> Hi,
>> I've a web application. The default page consists of
>> three frames. 'List bar frame', 'Banner frame'
and 'Main
>> frame'. Reports are displayed on this 'Main frame'.
>> I've a report which has got a column which is linked to
>> another report. I want the second report to be
displayed
>> in the same frme ('Main frame'). Right now while
>> clicking the link column, report is displayed in the
>> parent frame, there by I'm loosing list bar and banner
in
>> the application. How do I do this?
>> thanks,
>> Dee
>
>.
>|||You will need to use jump to URL action and build the URL as an expression,
adding rc:LinkTarget. I know it is not ideal, but it is the suggested
workaround for your scenario.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Deepak" <dee@.discussions.microsoft.com> wrote in message
news:05b901c46e31$d7519f40$a501280a@.phx.gbl...
> After giving rc:LinkTarget=framename, second report is
> opening in a new window. Not in the given frame. I'm
> using Jump to report method for calling 2nd report.
> thanks,
> Deee
> >--Original Message--
> >When you access the parent report in your frame, add the
> URL access
> >parameter rc:LinkTarget=framename. This will target all
> of the hyperlinks in
> >the report. You can also do stuff like
> rc:LinkTarget=_blank to open in a new
> >window.
> >
> >--
> >Bryan Keller
> >Developer Documentation
> >SQL Server Reporting Services
> >
> >A friendly reminder that this posting is provided "AS
> IS" with no
> >warranties, and confers no rights.
> >
> >
> >"Deepak" <deee@.discussions.microsoft.com> wrote in
> message
> >news:02e201c46d7c$f84dff50$a501280a@.phx.gbl...
> >> Hi,
> >>
> >> I've a web application. The default page consists of
> >> three frames. 'List bar frame', 'Banner frame'
> and 'Main
> >> frame'. Reports are displayed on this 'Main frame'.
> >> I've a report which has got a column which is linked to
> >> another report. I want the second report to be
> displayed
> >> in the same frme ('Main frame'). Right now while
> >> clicking the link column, report is displayed in the
> >> parent frame, there by I'm loosing list bar and banner
> in
> >> the application. How do I do this?
> >>
> >> thanks,
> >>
> >> Dee
> >
> >
> >.
> >|||It's working. thank you very much.
>--Original Message--
>You will need to use jump to URL action and build the
URL as an expression,
>adding rc:LinkTarget. I know it is not ideal, but it is
the suggested
>workaround for your scenario.
>--
>Bryan Keller
>Developer Documentation
>SQL Server Reporting Services
>A friendly reminder that this posting is provided "AS
IS" with no
>warranties, and confers no rights.
>
>"Deepak" <dee@.discussions.microsoft.com> wrote in message
>news:05b901c46e31$d7519f40$a501280a@.phx.gbl...
>> After giving rc:LinkTarget=framename, second report is
>> opening in a new window. Not in the given frame. I'm
>> using Jump to report method for calling 2nd report.
>> thanks,
>> Deee
>> >--Original Message--
>> >When you access the parent report in your frame, add
the
>> URL access
>> >parameter rc:LinkTarget=framename. This will target
all
>> of the hyperlinks in
>> >the report. You can also do stuff like
>> rc:LinkTarget=_blank to open in a new
>> >window.
>> >
>> >--
>> >Bryan Keller
>> >Developer Documentation
>> >SQL Server Reporting Services
>> >
>> >A friendly reminder that this posting is provided "AS
>> IS" with no
>> >warranties, and confers no rights.
>> >
>> >
>> >"Deepak" <deee@.discussions.microsoft.com> wrote in
>> message
>> >news:02e201c46d7c$f84dff50$a501280a@.phx.gbl...
>> >> Hi,
>> >>
>> >> I've a web application. The default page consists
of
>> >> three frames. 'List bar frame', 'Banner frame'
>> and 'Main
>> >> frame'. Reports are displayed on this 'Main frame'.
>> >> I've a report which has got a column which is
linked to
>> >> another report. I want the second report to be
>> displayed
>> >> in the same frme ('Main frame'). Right now while
>> >> clicking the link column, report is displayed in
the
>> >> parent frame, there by I'm loosing list bar and
banner
>> in
>> >> the application. How do I do this?
>> >>
>> >> thanks,
>> >>
>> >> Dee
>> >
>> >
>> >.
>> >
>
>.
>

How to read the xml returned by select query with "For XML Auto,Elements"

Hi all,

I am writing a select query which produces huge xml data.Now i want to read that data from my web application a save it as xml file.

How can i do that.

I am using asp.net vb.net.

Check if this post is helpful.

http://forums.asp.net/t/1182514.aspx

how to read and store a large file from SQL Server 2000?

hi..

I want to store a RMVB file to SQL SERVER 2000 ,and read from it,iwant to play the RMVB file in web,the size of the RMVB file is more than 300MB less 1G.the SQL FieldImage can include it.

Now My Quesstion is How can i Store and Read the RMVB file from SQL Server2000?

I usedSqlInsertCommand.ExecuteNoquery() in my program,but it Too slow,ao make a unknown error.

Thank you for your help.

I would seriously recomend not putting stuff like this into your db. Store a hard link to the file in your db, and put the file in the file system where it belongs. Binary data in your db of that size is only going to slow down every db operation you hope to accomplish.

|||And if you don't even execute the database functions it is fast enough and you don't get any errors?|||

thanks

I try it as you say,the code is:<embed src="http://pics.10026.com/?src=a.rmvb" height=200 width=200>but when it run,there are error Message:"the link of http://x.x.x.x/a.rmvb" is timeout or wrong" but the a.rmvb is realy in there and the link time is less then 1 second.

where is wong?thanks for your help!

|||

Please post your entire set of code that inserts this item into a database so we can troubleshoot it.

|||

hi..

the code is that:

WebForm1 -->WebForm1 -->WebForm1 --> body MS_POSITIONING="GridLayout"

form id="Form1" method="post" runat="server"

embed src="http://pics.10026.com/?src=Request["path"]" width=200 height=200>/embed

/form>

/body>

the path=a.rmvb

and when it run in localhost it is all right,but when it is wrong in server(the server not install realplay software)

where is wrong ?

thanks for your help!

|||

hi..

when i install realply in the server,it is all ok!

How to read a single row in a strongly types dataset?

I'm using strongly typed datasets in my first ASP.NET 2.0 web application. I come from ASP Classic, not an earlier version of .NET, and feel like I'm in another world. I'm slowly getting my head around datasets, but one thing I can't find any information on is how to read the data in a single record?

I'm not talking about for next loops, or accessing row information as a repeater or other control is filled. I'm talking about reading the data returned by a method that returns a table containing a single record. This is what I have:

Dim BookAdapter As New BooksTableAdapters.BooksBBTableAdapter
Dim organizations As Books.BooksBBDataTable
Dim organization As Books.BooksBBRow

organizations = BookAdapter.GetDataByOneBook(sBookID)

Dim sDropOff As String
Dim sOrganization As String
Dim sContact
For Each organization In organizations
If organization.DropOff = 1 Then
sDropOff = "True"
Else
sDropOff = "False"
End If
sOrganization = organization.Organization
sContact = organization.ContactName
Next

sBody = "Books Listing" & Chr(10) & Chr(10)
sBody = sBody & "Organization: " & sOrganization & Chr(10)
sBody = sBody & "Contact Name: " & sContact & Chr(10)
sBody = sBody & "Email: " & organization.Email & Chr(10)
sBody = sBody & "Phone Number: " & organization.Phone & Chr(10)

I'm using the FOR NEXT, but this is silly since I only have one record. GetDataByOneBook(sBookID) does exactly what is says, it returns a single book with a specific bookID.

Not only is this silly, it doesn't work. Using sContact as an example, it's Dim'd as a string. In the FOR NEXT loop, organization.ContactName has the right value, and it appears to be assigned to sContact correctly, but when I try to use sContact in sBody, I get an error saying that sContact has been used before it is assigned a value. Maybe the variables lose their scope outside the loop? Maybe I could get around this by building sBody inside the loop, but there has to be a better way!

Diane

I believe you want to do something like the following with your code:

1Dim BookAdapterAs New BooksTableAdapters.BooksBBTableAdapter2Dim organizationsAs Books.BooksBBDataTable3Dim organizationAs Books.BooksBBRow45 organizations = BookAdapter.GetDataByOneBook(sBookID)67If (organizations.Count > 0)Then89 sBody ="Books Listing" & Chr(10) & Chr(10)10 sBody = sBody &"Organization: " & organizations[0].Organization & Chr(10)11 sBody = sBody &"Contact Name: " & organizations[0].ContactName & Chr(10)12 sBody = sBody &"Email: " & organizations[0].Email & Chr(10)13 sBody = sBody &"Phone Number: " & organizations[0].Phone & Chr(10)1415End If

I do not have your XSD, so I can not test this.

|||

Thank you!

Diane

How to query two MS SQL DBs on the same server inside a Stored Procedure

Okay, so I have a problem and I would be REALLY grateful for any
assistance anyone can offer because I have found little or no help on
the web anywhere.

I want to access and do joins between tables in two different SQL db's
on the same server. Heres what Im dealing with.

In one database resides all of my security features for our clients,
where it decides who can login, etc etc...

In another database, I need to cross reference with a few fields in my
security db.

See the issue Im running into here is that because the way the people
have their databases set up for different products, I would normally
have to put these tables with security features in every database...
which is horrible, because every time I do an update I would have to
do it in 12 different places. Thats not efficient at all.

So I thought if I had one central DB, where all security features are
controlled from, that would be perfect... now the issue is cross
referencing and doing joins with other tables that ARENT in the same
db...

have I lost you yet?

I appreciate all of your help!

THANKS!!google@.digitallsd.com (JMack) wrote in message news:<472b479f.0402170642.37a57121@.posting.google.com>...
> Okay, so I have a problem and I would be REALLY grateful for any
> assistance anyone can offer because I have found little or no help on
> the web anywhere.
> I want to access and do joins between tables in two different SQL db's
> on the same server. Heres what Im dealing with.
> In one database resides all of my security features for our clients,
> where it decides who can login, etc etc...
> In another database, I need to cross reference with a few fields in my
> security db.
> See the issue Im running into here is that because the way the people
> have their databases set up for different products, I would normally
> have to put these tables with security features in every database...
> which is horrible, because every time I do an update I would have to
> do it in 12 different places. Thats not efficient at all.
> So I thought if I had one central DB, where all security features are
> controlled from, that would be perfect... now the issue is cross
> referencing and doing joins with other tables that ARENT in the same
> db...
>
> have I lost you yet?
> I appreciate all of your help!
> THANKS!!

As a general answer to your question, you can write code like this:

select *
from dbo.ThisTable t1
join ThatDatabase.dbo.ThatTable t2
on t1.KeyColumn = t2.KeyColumn

Assuming you have SQL2000 (you didn't mention the version), you should
review the "Using Ownership Chains" topic in Books Online for
information about cross-database ownership chains (and there is an
article in the current SQL Server Magazine also).

Simon|||well unfortunately I'm in SQL 7 so that option doesnt apply to me.

The only other way I can see around it, is taking the tables I need
available to all the db's and replicating them from one publishing db...

which is overkill, but because of the way the system is set up this is
the only other option i can think of aside from replication is trying to
get IT to updgrade to SQL 2000

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||
Oh damn buddy,

you have saved my life. IT WORKS.

THANK YOU SO MUCH!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||"Jeremy Mack" <google@.digitallsd.com> wrote in message
news:4032799b$0$199$75868355@.news.frii.net...
> well unfortunately I'm in SQL 7 so that option doesnt apply to me.
> The only other way I can see around it, is taking the tables I need
> available to all the db's and replicating them from one publishing db...
> which is overkill, but because of the way the system is set up this is
> the only other option i can think of aside from replication is trying to
> get IT to updgrade to SQL 2000
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Sorry if my explanation was misleading - joining on another database will
work fine in SQL7, but in SQL2000 the default cross-database chaining
behaviour changed in SP3, which is why it's worth reviewing the
documentation.

Simon|||JMack (google@.digitallsd.com) writes:
> Okay, so I have a problem and I would be REALLY grateful for any
> assistance anyone can offer because I have found little or no help on
> the web anywhere.
> I want to access and do joins between tables in two different SQL db's
> on the same server. Heres what Im dealing with.
> In one database resides all of my security features for our clients,
> where it decides who can login, etc etc...
> In another database, I need to cross reference with a few fields in my
> security db.
> See the issue Im running into here is that because the way the people
> have their databases set up for different products, I would normally
> have to put these tables with security features in every database...
> which is horrible, because every time I do an update I would have to
> do it in 12 different places. Thats not efficient at all.
> So I thought if I had one central DB, where all security features are
> controlled from, that would be perfect... now the issue is cross
> referencing and doing joins with other tables that ARENT in the same
> db...

I see that you have got a solution working.

But I am a little wary of hard-coding database references. The day
you need to set up a test environment on the same server, you have
trouble...

One alternative would be to have a central database which you maintain,
and then use replication to push those updates to the other places.
Although admittedly, replication might be a little heavy-duty for this...

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

How To Query A Linked Server

Hey all. I'm having a slight problem and was hoping I could use
linked servers to solve it. Basically I've developed a web app
locally using SQL 2005 Express and need to import the data to a web
hosting facility SQL 2005 server. I can see the production server in
management studio and have set up a linked server. However I'm not
sure how to query the database and then ultimately select from my
local db and insert it into the new db tables.
First problem is the linked server address. It's the following:
sqlXXXX.mssqlservers.com
When I query the linked server I get this.
The object name 'sqlXXXX.mssqlservers.com.MyDB.dbo.MyTable' contains
more than the maximum number of prefixes. The maximum is 3.
Is the linked server route the best way for me to import this data? I
need to get the data in ASAP for this client.
Thanks.Hi,
Use: '[sqlXXXX.mssqlservers.com].MyDB.dbo.MyTable'
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
<rh1200la@.gmail.com> wrote in message
news:1190655841.782199.125430@.19g2000hsx.googlegroups.com...
> Hey all. I'm having a slight problem and was hoping I could use
> linked servers to solve it. Basically I've developed a web app
> locally using SQL 2005 Express and need to import the data to a web
> hosting facility SQL 2005 server. I can see the production server in
> management studio and have set up a linked server. However I'm not
> sure how to query the database and then ultimately select from my
> local db and insert it into the new db tables.
> First problem is the linked server address. It's the following:
> sqlXXXX.mssqlservers.com
> When I query the linked server I get this.
> The object name 'sqlXXXX.mssqlservers.com.MyDB.dbo.MyTable' contains
> more than the maximum number of prefixes. The maximum is 3.
> Is the linked server route the best way for me to import this data? I
> need to get the data in ASAP for this client.
> Thanks.
>