bcp licensing

Hi,
SQL Server 2000 Standard Edition
I do have license for running SQL Server on a machine. Do I need to get
separate license for installing bcp on a user machine and using bcp from the
user machine to export data out from SQL Server ?
Thanks,
payyans
payyans,
Yes, you can but you need a client access license (CAL) from the client
that bcp is running on.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
payyans wrote:
> Hi,
> SQL Server 2000 Standard Edition
> I do have license for running SQL Server on a machine. Do I need to get
> separate license for installing bcp on a user machine and using bcp from the
> user machine to export data out from SQL Server ?
> Thanks,
> payyans
>
|||Thanks Mark
"Mark Allison" wrote:

> payyans,
> Yes, you can but you need a client access license (CAL) from the client
> that bcp is running on.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> payyans wrote:
>

bcp licensing

Hi,
SQL Server 2000 Standard Edition
---
I do have license for running SQL Server on a machine. Do I need to get
separate license for installing bcp on a user machine and using bcp from the
user machine to export data out from SQL Server ?
Thanks,
payyanspayyans,
Yes, you can but you need a client access license (CAL) from the client
that bcp is running on.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
payyans wrote:
> Hi,
> SQL Server 2000 Standard Edition
> ---
> I do have license for running SQL Server on a machine. Do I need to get
> separate license for installing bcp on a user machine and using bcp from the
> user machine to export data out from SQL Server ?
> Thanks,
> payyans
>|||Thanks Mark
"Mark Allison" wrote:
> payyans,
> Yes, you can but you need a client access license (CAL) from the client
> that bcp is running on.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> payyans wrote:
> > Hi,
> > SQL Server 2000 Standard Edition
> > ---
> > I do have license for running SQL Server on a machine. Do I need to get
> > separate license for installing bcp on a user machine and using bcp from the
> > user machine to export data out from SQL Server ?
> > Thanks,
> > payyans
> >
>

bcp licensing

Hi,
SQL Server 2000 Standard Edition
---
I do have license for running SQL Server on a machine. Do I need to get
separate license for installing bcp on a user machine and using bcp from the
user machine to export data out from SQL Server ?
Thanks,
payyanspayyans,
Yes, you can but you need a client access license (CAL) from the client
that bcp is running on.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
payyans wrote:
> Hi,
> SQL Server 2000 Standard Edition
> ---
> I do have license for running SQL Server on a machine. Do I need to get
> separate license for installing bcp on a user machine and using bcp from t
he
> user machine to export data out from SQL Server ?
> Thanks,
> payyans
>|||Thanks Mark
"Mark Allison" wrote:

> payyans,
> Yes, you can but you need a client access license (CAL) from the client
> that bcp is running on.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> payyans wrote:
>

BCP error

Hi,
Env: win2k, mssql 8.00.194, Standard Edition

Please help me to make the following bcp to work.
I want to save RS from store procedure to ascii file, using BCP. The sp creates temporary tables and the final select in sp is exec sp_executesql @.comm.
The following example demonstrates the problem:

declare @.bcpCommand nvarchar(100)
set @.bcpCommand = 'bcp "exec sp_helpdb" queryout "\\kkkk\bcp_dbs.log" -c'
exec master..xp_cmdshell @.bcpCommand

I'm getting the following error:
Password:
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]BCP host-files must contain at least one column
NULL

Thanksdeclare @.bcpCommand nvarchar(100)
set @.bcpCommand = 'bcp "set fmtonly off exec sp_helpdb" queryout "c:\test.txt" -c'
exec master..xp_cmdshell @.bcpCommand|||Damn...who was that (un)masked man??

Very nice...but it's as clear as mud

BOL

Returns only meta data to the client.

Syntax
SET FMTONLY { ON | OFF }

Remarks
No rows are processed or sent to the client as a result of the request when SET FMTONLY is turned ON.

The setting of SET FMTONLY is set at execute or run time and not at parse time.

Permissions
SET FMTONLY permissions default to all users.

Examples
This example changes the SET FMTONLY setting to ON and executes a SELECT statement. The setting causes the statement to return the column information only; no rows of data are returned.

SET FMTONLY ON
GO
USE pubs
GO
SELECT *
FROM pubs.dbo.authors
GO|||Thanks for the replay - it works .

basic Server setup and user accounts

I have just installed SQL server 2005 standard edition - how do I create a
basic server and user accounts in order to then install Project Server?
Hi
Project Server is not yet officially certified to run with SQL 2005.
Postings in the project server news groups discuss how you can work around
this to get it working, but you should not use this on a production system
http://www.microsoft.com/office/comm...=&sloc=en -us
http://blogs.lv0.net/mpatest/archive...11/18/182.aspx
John
"Steve Scott" wrote:

> I have just installed SQL server 2005 standard edition - how do I create a
> basic server and user accounts in order to then install Project Server?

basic Server setup and user accounts

I have just installed SQL server 2005 standard edition - how do I create a
basic server and user accounts in order to then install Project Server?Hi
Project Server is not yet officially certified to run with SQL 2005.
Postings in the project server news groups discuss how you can work around
this to get it working, but you should not use this on a production system
http://www.microsoft.com/office/com...exp=&sloc=en-us
http://blogs.lv0.net/mpatest/archiv.../11/18/182.aspx
John
"Steve Scott" wrote:

> I have just installed SQL server 2005 standard edition - how do I create a
> basic server and user accounts in order to then install Project Server?

basic Server setup and user accounts

I have just installed SQL server 2005 standard edition - how do I create a
basic server and user accounts in order to then install Project Server?Hi
Project Server is not yet officially certified to run with SQL 2005.
Postings in the project server news groups discuss how you can work around
this to get it working, but you should not use this on a production system
http://www.microsoft.com/office/community/en-us/default.mspx?query=SQL+2005&dg=microsoft.public.project.server&cat=en-us-microsoftproject&lang=en&cr=US&pt=a1d023a3-f612-4da2-acb8-fda8f850d645&catlist=&dglist=&ptlist=&exp=&sloc=en-us
http://blogs.lv0.net/mpatest/archive/2005/11/18/182.aspx
John
"Steve Scott" wrote:
> I have just installed SQL server 2005 standard edition - how do I create a
> basic server and user accounts in order to then install Project Server?

Basic SAS Question on aggregation

Hello, I'm running SAS on SQL Server 05 Standard edition.

I noticed the 'Semi-Additive' features are not available in SQL Std Edition.

I have some time phased cost data that I don't know how to handle using only the 'Sum' feature

For example:

Week 1: Expenses =100 (based on sum of all expenses in the fact table)

Week 2: Expenses = 80 (ditto)

Week 3: Expenses = 0 (no records in fact table for this week)

Week 4: Expenses = 0 (ditto)

Monthly Total: 180

Now, I want to have a column that is a running total of expenses. Like so:

Week 1: Total Spent = 100

Week 2: Total Spent = 180

Week 3: Total Spent = 180

Week 4: Total Spent = 180

Monthly total = 180

Any clue how to approach this?

Hello. You will need to create a calculated member for this and write some MDX like:

SUM(YTD([TimeDimension].[TimeWeekHierarchy].CurrentMember), [Measure].[Total Spent]))

It will give you accumulated values.

HTH

Thomas Ivarsson

|||It would be better if you use AGGREGATE instead of SUM|||

Create Member CurrentCube.[Measures].[Total Spent]
as
SUM(YTD([time].[week].CurrentMember), [Measure].[Total Spent]))

this give me a syntax error... sorry I'm a MDX newbie.

|||You have set up a recursive calculation here, creating [Total Spent] which attempts to sum itself (resulting in an infinite loop). I suspect that you meant to use a different measure inside the sum() function.|||yeah...I did.|||

My mistake. I should have written Expenses for the Measure in the calculated member([Measure].[Expenses]) .

Regards

Thomas Ivarsson