please help me in fixing this bug...................!!

Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.

http://forums.asp.net/p/981020/1750831.aspx#1750831

please help -- 512 error when generating replication script

Hi,

I'm trying to script out my replication objects using
the 'Generate SQL Script...' option under Tools >
Replication in Enterprise Manager. Under 'Replication
components to script', I check 'Distributor properties'
and 'Publications in these databases:' and choose all
databases listed. I get a 512 error:

Error 512: Subquery returned more than 1 value. This is
not permitted when the subquery follows =, !=, <, <=, >,
>= or when the subquery is used as an expression.

The server is 2000 sp2, and the Ent Mgr client is 2000.
Using the same Ent Mgr client to script replication
objects in other 2000 sp2 servers, I don't receive any
errors.

I appreciate any help you can provide.

Thanks,
LB
.Try scripting individually.

Please - OLE DB Provider for SQL Server (0x80004005) Cannot generate SSPI context

Please can anybody help me in fixing this error I am getting on ASP page while accessing ASP database page using an SQL server database.

I am using Windows 2000 Service Pack 4 with Internet Exp. 6. The system also has developing software VB6 and IIS. It is connecting well with VB application but is not accessing through IIS.

I have checked all MS Knowledge Base but could not find workaround. MS accepts it as a bug but I could not find quick and easy solution,

Thanking you in anticipation,

Zulfiqar AliSSPI points to an authentication error connecting to your SQL Server instance.

have you tried creating a SQL Server logon and passing that to your connection string? If that works, then there's an issue with your Windows authentication.....

If it doesn't, then you have a more general problem connecting to your database|||

No, but to do this, I need to re-install the SQL server. I am trying to avoid this. Is it possible to change main SQL server login without re-installing SQL Server?

Regards

|||hata error

PK field generate by SQL server using Bulkload

Hi, I'm a bit of Bulkload newbie.
I would like to import XML files into my SQL2k table,
but PK field (identity-yes field) in this table has to be
generated by SQL server.
What have I to write in my XSD file for this PK field?
Thanks for guru :-)Just make sure that bulkload has KeepIdentity=False set on the API, that
should do it.
Irwina
"Gen" <anonymous@.discussions.microsoft.com> wrote in message
news:061301c52a47$36077470$a501280a@.phx.gbl...
> Hi, I'm a bit of Bulkload newbie.
> I would like to import XML files into my SQL2k table,
> but PK field (identity-yes field) in this table has to be
> generated by SQL server.
> What have I to write in my XSD file for this PK field?
> Thanks for guru :-)|||It works!
Thank you so much

>--Original Message--
>Just make sure that bulkload has KeepIdentity=False set
on the API, that
>should do it.
>Irwina
>"Gen" <anonymous@.discussions.microsoft.com> wrote in
message
>news:061301c52a47$36077470$a501280a@.phx.gbl...
be
>
>.
>

PK field generate by SQL server using Bulkload

Hi, I'm a bit of Bulkload newbie.
I would like to import XML files into my SQL2k table,
but PK field (identity-yes field) in this table has to be
generated by SQL server.
What have I to write in my XSD file for this PK field?
Thanks for guru :-)
Just make sure that bulkload has KeepIdentity=False set on the API, that
should do it.
Irwina
"Gen" <anonymous@.discussions.microsoft.com> wrote in message
news:061301c52a47$36077470$a501280a@.phx.gbl...
> Hi, I'm a bit of Bulkload newbie.
> I would like to import XML files into my SQL2k table,
> but PK field (identity-yes field) in this table has to be
> generated by SQL server.
> What have I to write in my XSD file for this PK field?
> Thanks for guru :-)
|||It works!
Thank you so much

>--Original Message--
>Just make sure that bulkload has KeepIdentity=False set
on the API, that
>should do it.
>Irwina
>"Gen" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:061301c52a47$36077470$a501280a@.phx.gbl...
be
>
>.
>

PIVOT question

I have a basic table consisting of several thousand records. Im trying to generate a pivot query for a report. the table consists of records, each of which has a recieved date ( small date time ) and a tranactioncount ( int ) . Im looking to generate a PIVOT to show the show the month and year counts for the files recieved

ie

YEAR | JAN FEB MAR APR etc

2004 ! 2 34 67 43

2005 | 12 2 3 1

can anybody explain in laymans terms how to do this

Thank you in advance

are you using SQL 2000 or 2005 ?

If 2005, use the pivot function|||i am using sql2005, ive looked up the documentation on the PIVOT function but still am having diffaculity in applying it|||

To do this in 2000, check out my reply of this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=249991&SiteID=1

However, the PIVOT method in 2005 is better. What errors are you getting?

|||

You can do something like below using PIVOT operator:

select p.yr as Year, p.[1] as [Jan], p.[2] as [Feb], ....

from (select year(receivedate) as yr, month(receivedate) as mn, trancnt from tbl) as t

pivot (sum(t.trancnt) for t.mn in ([1], [2], [3], ...)) as p

|||

I am curious to know what are the practical uses of the Pivot function assuming you do not grant end users acces to your database.

On my side, I use the pivot function to pack more data in Reporting Services while avoiding the Matrix reports shortcomings, however it is very tedious to build. If you want if maitenance free. You have to break the rule of "NO dynamic SQL ever".

Any thoughts?

Philippe

|||Yes, the use cases of PIVOT operator is very restrictive right now. If you want to pivot on say multiple measures or aggregates then you have to use the traditional SQL approach of CASE expressions and GROUP BY in the query. The dynamic list generation for PIVOT operator is also something we have heard frequently from customers. A future version of SQL Server might provide additional enhancements, optimizations for PIVOT which will improve the usage & performance of the query. So if you find instances where you can achieve the result using PIVOT operator then use it instead of the CASE / GROUP BY approach. Hope this clarifies.