Copy file on network

I have a job which call a SP and that SP generates a excel file dump using
bcp. Now form my website i want to access that excel file. Both my webserver
and db server is on different meachine.
How can i achive this?
can BCP generate output on network. Or can i copy generated file to
webserver using some command through SP ?Vikram
If I understood properly , you can create a linked server to EXCEL file.
HOWTO: Use Excel w/ SQL Linked Servers &
Distributed Queries
http://support.microsoft.com/suppor...s/q306/3/97.asp
"Vikram" <aa@.aa> wrote in message
news:uNVc7FPPGHA.1460@.TK2MSFTNGP10.phx.gbl...
>I have a job which call a SP and that SP generates a excel file dump using
> bcp. Now form my website i want to access that excel file. Both my
> webserver
> and db server is on different meachine.
> How can i achive this?
> can BCP generate output on network. Or can i copy generated file to
> webserver using some command through SP ?
>
>|||But in linked server i have to have excel file. But i do not want this, i
want to have excel file generated by bcp...
any other way ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ehRxqMPPGHA.456@.TK2MSFTNGP15.phx.gbl...
> Vikram
> If I understood properly , you can create a linked server to EXCEL file.
> HOWTO: Use Excel w/ SQL Linked Servers &
> Distributed Queries
> http://support.microsoft.com/suppor...s/q306/3/97.asp
>
>
> "Vikram" <aa@.aa> wrote in message
> news:uNVc7FPPGHA.1460@.TK2MSFTNGP10.phx.gbl...
using
>|||DTS?
"Vikram" <aa@.aa> wrote in message
news:%23izbiaPPGHA.3164@.TK2MSFTNGP11.phx.gbl...
> But in linked server i have to have excel file. But i do not want this, i
> want to have excel file generated by bcp...
> any other way ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ehRxqMPPGHA.456@.TK2MSFTNGP15.phx.gbl...
> using
>|||NO I am suing BCP , calling it from sp using xp_cmdshell
I dont want to use DTS as sp whic return data use temp table and also i have
many sp whose data i have to export to excel
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%2370krlPPGHA.2124@.TK2MSFTNGP14.phx.gbl...
> DTS?
>
> "Vikram" <aa@.aa> wrote in message
> news:%23izbiaPPGHA.3164@.TK2MSFTNGP11.phx.gbl...
i
file.
>|||> How can i achive this?
> can BCP generate output on network. Or can i copy generated file to
> webserver using some command through SP ?
UNC path depending on your permissions.
EXEC master..xp_cmdshell "bcp DB.dbo.Table out
\\SERVER1\Share\test.xls -c -T"
ftp via xp_cmdshell could work.

Copy database without the data on a Cd?

Hi all,
We have a website with a database connected to a SQL server. I need
to copy that database without the data onto a CD so I can place the
program on another server?
Any help would be greatly appreciated.
You can generate create table/procedure/view scripts from within Enterprise
Manager / Mangement Studio. Or you can use a 3rd party tool like SQL
Compare from www.red-gate.com ...
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegro ups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>
|||You can make a backup and restore the database on another server or under a
different name. Then run the script I posted in my blog to delete all data
in the database -
http://www.sqljunkies.com/WebLog/roman/archive/2006/03/08/18620.aspx. After
that you'll have a database with no data, you can back it up and distribute.
As Aaron mentionned, you could also script out all database objects but you
may have to tweak those scripts manually and have them execute in the right
order because script generation tools often don't handle dependencies. So
when you run the script, it might fail if a referenced object hasn't been
created yet.
Roman
Roman Rehak
http://sqlblog.com/blogs/roman_rehak
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegro ups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>
|||ApexSQL Diff should help here.
TheSQLGuru
President
Indicium Resources, Inc.
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegro ups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>

Copy database without the data on a Cd?

Hi all,
We have a website with a database connected to a SQL server. I need
to copy that database without the data onto a CD so I can place the
program on another server?
Any help would be greatly appreciated.You can generate create table/procedure/view scripts from within Enterprise
Manager / Mangement Studio. Or you can use a 3rd party tool like SQL
Compare from www.red-gate.com ...
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegroups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>|||You can make a backup and restore the database on another server or under a
different name. Then run the script I posted in my blog to delete all data
in the database -
http://www.sqljunkies.com/WebLog/ro.../08/18620.aspx. After
that you'll have a database with no data, you can back it up and distribute.
As Aaron mentionned, you could also script out all database objects but you
may have to tweak those scripts manually and have them execute in the right
order because script generation tools often don't handle dependencies. So
when you run the script, it might fail if a referenced object hasn't been
created yet.
Roman
Roman Rehak
http://sqlblog.com/blogs/roman_rehak
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegroups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>|||ApexSQL Diff should help here.
TheSQLGuru
President
Indicium Resources, Inc.
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegroups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>sqlsql

Copy database without the data on a Cd?

Hi all,
We have a website with a database connected to a SQL server. I need
to copy that database without the data onto a CD so I can place the
program on another server?
Any help would be greatly appreciated.You can generate create table/procedure/view scripts from within Enterprise
Manager / Mangement Studio. Or you can use a 3rd party tool like SQL
Compare from www.red-gate.com ...
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegroups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>|||You can make a backup and restore the database on another server or under a
different name. Then run the script I posted in my blog to delete all data
in the database -
http://www.sqljunkies.com/WebLog/roman/archive/2006/03/08/18620.aspx. After
that you'll have a database with no data, you can back it up and distribute.
As Aaron mentionned, you could also script out all database objects but you
may have to tweak those scripts manually and have them execute in the right
order because script generation tools often don't handle dependencies. So
when you run the script, it might fail if a referenced object hasn't been
created yet.
Roman
--
Roman Rehak
http://sqlblog.com/blogs/roman_rehak
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegroups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>|||ApexSQL Diff should help here.
--
TheSQLGuru
President
Indicium Resources, Inc.
<mchin247@.gmail.com> wrote in message
news:1184684718.199501.113020@.e9g2000prf.googlegroups.com...
> Hi all,
> We have a website with a database connected to a SQL server. I need
> to copy that database without the data onto a CD so I can place the
> program on another server?
> Any help would be greatly appreciated.
>

Cookie problem in reporting services

Hi, I'm using URL access to view my reports from within my website. My report
is being viewed from within an IFrame on the site. IE 6 with default security
blocks cookies coming from the IFrame. Apparently - setting
"UseSessionCookies" to false in the site settings is supposed to cause RS to
manage session via the querystring and instead. I have done this and RS is
still sending cookies? (I am running SP1)
Is this a bug is RS or am i missing something?Hi Jarrod,
From your descriptions, I understood cookies are continuing sending even
you have set UseSessionCookies to false. Have I understood you? Correct me
if I was wrong.
Based on my scope, UseSessionCookies is a system property and you could set
that to false by using the SOAP API SetSystemProperties method.
I am not sure why it is continuing sending cookies as you said. I have
surveied known issues internally and do not find anything related with
UseSessionCookies so that is it possible for you to generate a samll sampel
for me to reproduce it?
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Jarrod,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!