Bulk Copy Program

Hi Techies,

I have a bcp which generates .txt file perfectly. I just wanted to know how can i generate a text file in distributed environment.

Assuming that my Sql Server is running in machine A. I wanted the bcp to generate in Machine B. What are the permission's i should give in order to generate it in Machine B.

Regards
--Tanveerthe user who executes the bcp-command would need write access. read access is usually handy to validate the file has been written but I don't think its required. In case machine B only has a filesystem, that user obviously needs filesystem write access. In case machine B is a sqlserver that user would need write access on the table the file is insert into.|||Thanks for the reply... I guess i have not mentioned that the above program would be executed through stored procedure. In this scenario what are the permission i should give and to which users.

--Tanveer|||Assuming bcp and the copy is executed using xp_cmdshell, the user is the user configured to run sqlserver (exec master..xp_cmdshell 'set'). If it's local user (only known to the server) you'll find it difficult to do the windows-copy. If it's a domain user it'll be easier to grant the write access. Do you have difficulty creating the .txt file using the stored procedure?

Building Move

My current company is planning to undertake an enormous move late this week,
We have a very large SAN environment .
It has been decided that we change the Ip address of the new network at the
new building in order to make the transition as smooth as possible.
With the ip address changes on the new network what type of issues should we
look out for during this move. If any one has participated in a move that
included sql servers any help would greatly be appreciated.Hi
If you are not directly using the IP address then in general I think you
should be ok.
Write down the tests that you are going to do to verify the change before
hand and check them off as you go. You can then make sure that everything is
covered in your testing. Knowing the current systems data flows will help
make sure these are documented.
Make sure that the DNS's are correctly updated and replication of the new
records may require time to propogate.
Make sure that firewalls are correctly configured for any new ranges you are
using and rules relating to the old ranges changed or removed.
John
"JDS" wrote:
> My current company is planning to undertake an enormous move late this week,
> We have a very large SAN environment .
> It has been decided that we change the Ip address of the new network at the
> new building in order to make the transition as smooth as possible.
> With the ip address changes on the new network what type of issues should we
> look out for during this move. If any one has participated in a move that
> included sql servers any help would greatly be appreciated.

Building a new database on SQL Server 2000 cluster

The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition Clu
ster (2 boxes)
The I attach th the SQL Server Thru Enterprise Manager, right -click databas
es, and select new database...I can type the name of the new database, but w
hen I go to look for the other drives in the cluster I can only see the (Mas
ter) drive ...where SQL Ser
ver is installed. How can I view all of the current resources (drives) owne
d by that node in the cluster?
Thanks,
WarrenYou have to add them to the cluster ... This is in cluster administrator.
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:41DA8BCE-72D7-41AF-9A9A-5DD06DBCF760@.microsoft.com...

quote:

---

> The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition

---

Cluster (2 boxes)

quote:

---

> The I attach th the SQL Server Thru Enterprise Manager, right -click

---

databases, and select new database...I can type the name of the new
database, but when I go to look for the other drives in the cluster I can
only see the (Master) drive ...where SQL Server is installed. How can I
view all of the current resources (drives) owned by that node in the
cluster?

quote:

---

> Thanks,
> Warren

---

|||Thanks Wayne.
I can see all the drive within the cluster administrator. Is there another
step that i didn't do? The fail-over works perfectly and each node owns it'
s own resources. But I can view the different drives within Enterprise Manag
er...
Thanks,
Warren Tyler|||Correction on the above entry..
I can't view any of the drive from within Enterprise Manager

Building a new database on SQL Server 2000 cluster

The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition Cluster (2 boxes
The I attach th the SQL Server Thru Enterprise Manager, right -click databases, and select new database...I can type the name of the new database, but when I go to look for the other drives in the cluster I can only see the (Master) drive ...where SQL Server is installed. How can I view all of the current resources (drives) owned by that node in the cluster?
Thanks
WarrenYou have to add them to the cluster ... This is in cluster administrator.
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:41DA8BCE-72D7-41AF-9A9A-5DD06DBCF760@.microsoft.com...
> The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition
Cluster (2 boxes)
> The I attach th the SQL Server Thru Enterprise Manager, right -click
databases, and select new database...I can type the name of the new
database, but when I go to look for the other drives in the cluster I can
only see the (Master) drive ...where SQL Server is installed. How can I
view all of the current resources (drives) owned by that node in the
cluster?
> Thanks,
> Warren|||Thanks Wayne
I can see all the drive within the cluster administrator. Is there another step that i didn't do? The fail-over works perfectly and each node owns it's own resources. But I can view the different drives within Enterprise Manager..
Thanks
Warren Tyler|||Correction on the above entry..
I can't view any of the drive from within Enterprise Manager