@@ERROR & CREATE TABLE

Hi

I've been looking at scripting some create tables, but want to know if the table created successfully. I've been doing the following:

DECLARE @.ERRCODE INT

CREATE TABLE x
SET @.ERRCODE = @.@.ERROR

This works ok, if there is no erroor. However if I run this again, then obviously I get the error "This object already exists" and the script stops executing.

Is there a way that I can capture the error using @.@.ERROR and still let the script run ?

Thanks in advance

MicksterWell, you shouldn't. "On Error Resume Next" is not present in T-SQL. What you should do is perform a validation for presence of object before attempting to create it.if objectproperty(object_id('dbo.x'), 'isusertable')=1 drop table dbo.x

create table dbo.x (f1 int, ...)|||Thanks, but I already understand that I should check for the existance of the object - as stated in my last mail. I want to check the table is being created correctly incase of other events, like permissions, file full, etc.

GridView

Hi
I need to add in gridview control asp code "delete from t1 whereid=@.id1"
how to declare @.id1 because the server give me mistake
down is the code of asp i use GridView how i can link @.id with field there id?

Thank u and have a nice day
best regards
the code if u need it i use c#

<ASP:SQLDATASOURCE id=SqlDataSource1 <br ConnectionString="<%$ ConnectionStrings:libraryConnectionString %>" runat="server"><BR></ASP:SQLDATASOURCE></ASP:BOUNDFIELD

I don't understand what the <br is doing in the tag, as well as why the data source control is in a bound field; I don't believe BoundField allows text in the tag, as well as child controls.

But you do that through:

<asp:sqldatasource id="s" runat="server" ConnectionString=".." DeleteCommand="yoru query">
<DeleteParameters>
<asp:Parameter Name="@.id" Type="Integer" />
</DeleteParameters>
</asp:sqldatasource>

Something like that.

/L*v C:\temp\logfile

Hi!
I found that using /L*v with the setup procedure creates a verbose log
file. Is there any way to add a verbose log file to an existing database?
Stefan
hi Stefan,
"Stefan M. Huber" <looseleaf@.gmx.net> ha scritto nel messaggio
news:opsfqz6rois9ddfw@.news.individual.de
> Hi!
> I found that using /L*v with the setup procedure creates a verbose
> log file. Is there any way to add a verbose log file to an existing
> database?
> Stefan
/L*v is a setup parameter, which enables the setup logging features...
I do not understand your requirements regarding "add a verbose log file to
an existing database"...
all SQL Server databases do have a transaction log file at least, and the
logging mode is dependent to the recovery setting, as described in
http://msdn.microsoft.com/library/de...kprst_6rqr.asp
...
can you please elaborate your requirements?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||On Tue, 12 Oct 2004 11:05:25 +0200, Andrea Montanari
<andrea.sqlDMO@.virgilio.it> wrote:

> hi Stefan,
> "Stefan M. Huber" <looseleaf@.gmx.net> ha scritto nel messaggio
> news:opsfqz6rois9ddfw@.news.individual.de
> /L*v is a setup parameter, which enables the setup logging features...
> I do not understand your requirements regarding "add a verbose log file
> to an existing database"...
> all SQL Server databases do have a transaction log file at least, and the
> logging mode is dependent to the recovery setting, as described in
> http://msdn.microsoft.com/library/de...kprst_6rqr.asp
> ..
> can you please elaborate your requirements?
I am having troubles when connecting to MSDE 1.0 after installing XP SP2:
The inital connection takes an eternity (10 seconds on lightning fast
machines, up to 90 seconds on my older working machine). In this time,
sqlsvr.exe causes 100% processor load and a lot of I/O stress. I'd simply
like to find out what is going on.
After the initial connection lag, operation continues normally.
We connect through Delphi 5 using ADO.
any pointers appreciated (upgrading to D7 is not an option; it's not my
decision)
Stefan
|||hi Stefan,
"Stefan M. Huber" <looseleaf@.gmx.net> ha scritto nel messaggio
news:opsfq3c3uks9ddfw@.news.individual.de
> I am having troubles when connecting to MSDE 1.0 after installing XP
> SP2: The inital connection takes an eternity (10 seconds on lightning
> fast machines, up to 90 seconds on my older working machine). In this
> time, sqlsvr.exe causes 100% processor load and a lot of I/O stress.
> I'd simply like to find out what is going on.
> After the initial connection lag, operation continues normally.
> We connect through Delphi 5 using ADO.
> any pointers appreciated (upgrading to D7 is not an option; it's not
> my decision)
> Stefan
XP sp2 causes a lot of connection issues, see
http://www.michna.com/kb/WxSP2.htm for instance...
for related SQL Server issues please have a look at
http://support.microsoft.com/default.aspx?kbid=841249
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||On Tue, 12 Oct 2004 13:04:27 +0200, Andrea Montanari
<andrea.sqlDMO@.virgilio.it> wrote:

> XP sp2 causes a lot of connection issues, see
> http://www.michna.com/kb/WxSP2.htm for instance...
> for related SQL Server issues please have a look at
> http://support.microsoft.com/default.aspx?kbid=841249
Thanks for the pointers, Andrea. We've gone through the second one
already; I'll double check if we missed something there.
Do you think that an upgrade to MSDE 2000 would cure some issues?
Stefan, off reading
|||hi Stefan,
"Stefan M. Huber" <looseleaf@.gmx.net> ha scritto nel messaggio
news:opsfq89i1ws9ddfw@.news.individual.de
> ..
> Thanks for the pointers, Andrea. We've gone through the second one
> already; I'll double check if we missed something there.
> Do you think that an upgrade to MSDE 2000 would cure some issues?
> Stefan, off reading
actually not, but MSDE 2000 can be worth upgrading becouse several
improvements in the database engine...
I only installed a Virtual Machine of WinXP sp 2 but had (fortunately) no
related issue to connectivity..
opened the TCP port required for network connections and enlisted a range of
subnet IP addresses... all is ok..
... and I hope to be that lucky when upgrading the real physical machine
=;-D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||On Tue, 12 Oct 2004 15:39:23 +0200, Andrea Montanari
<andrea.sqlDMO@.virgilio.it> wrote:

> hi Stefan,
> "Stefan M. Huber" <looseleaf@.gmx.net> ha scritto nel messaggio
> news:opsfq89i1ws9ddfw@.news.individual.de
> actually not, but MSDE 2000 can be worth upgrading becouse several
> improvements in the database engine...
Yes; as long as we can easily handle upgrading issues, like the password
in all our connection strings.

> I only installed a Virtual Machine of WinXP sp 2 but had (fortunately) no
> related issue to connectivity..
> opened the TCP port required for network connections and enlisted a
> range of subnet IP addresses... all is ok..
> ... and I hope to be that lucky when upgrading the real physical machine
> =;-D
I'd rather set up a complete testing machine beforehand
Good luck and thanks,
Stefan

.NET Framework 1.1 and SQL server express 2005?

Hi

I am running VS.NET 2003 on my computer and wish to try to install the *free* SQL server express 2005 .

The problem is I can't install SQL express as it asks me to install .NET framework 2.0 first.

I wonder if I do so, will I be able to work with VS.NET 2003?

Thanks,

Yes VS.NET 2003 would work just fine. Multiple versions of .NET framework can run easily.

.NET Custom UDF - "Internal error: An unexpected exception occured."

Hi!

I have developed some .NET UDF for MSAS2005.
I compiled it, added assembly to database and tested it - it works.
But works only on my test seerver. On life server I've got this message:
"Internal error: An unexpected exception occured."
Assembly is registered as unrestricted.
I've maid simple test function in own assembly file, which just gives back 1.
It also works on test- and does not work on life server.
Customer will kill me :-( ....
P.S. Last post-SP1-fix (form July) is installed.

I (and a few other people) have been working on writing some stored procs for AS which will be available for public download soon, and we've seen this error a lot. The only information I can give you about it is that it seems to be sporadic and happen more often on lower-spec machines. I believe it's already been logged as a bug; until it's fixed, in my opinion you can't really use AS stored procs in a production environment.

Sorry...

Chris

|||

Thanx Chris for reply,
but it is not our case, because our Life-Server has much more Performance

|||

Are there any updates on this issue? I get this same error on our production server even though it never happened in development and testing (2 different servers).

The problem is very erratic and may happen or not happen in a given cube depending on how the query is built.

Any help would be appreciated.

|||

Hi All,

We have come across this error too but can only find evidence of Microsoft fixing this issue in SP1... http://support.microsoft.com/kb/912429/. However this issue is described as happening not in AS stored procs but in standard queries made even from SSMS.

Does anyone have any information or links etc that shows that this particular issue relating to SPs has been acknowledged by Microsoft? It's been requested by our project manager...

As per usual, any feedback will be gratefully received.

Rob.

|||

The error "Internal error: An unexpected exception occured." is generic in a sense, that it is raised when AS detects any internal inconsistency. So the KB912429 is about different cause. However, the following KB seems more relevant: http://support.microsoft.com/kb/918753/

Yura - I suggest you contact PSS and request this hotfix. Alternatively, you can wait for SP2, where this hotfix is rolled into.

HTH,

Mosha (http://www.mosha.com/msolap)

|||

We have already found (and solve) a problem. This error happends then, when R-ROLAP partition and something is not correct with DataTypes.

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method?

|||

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

|||

Mosha Pasumansky wrote:

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

Ok, now I got it. Is it only way? I mean, is it possible to have both - result of execution and trace messages? Like by .NET StoredProcedures in SQL Server - Pipe.Send(...) method give you possibility to send Rows, RewSets (as result set) and strings (as a-la PRINT messages).
But in SSAS we have only "chanel" - result. It could be string, numeric or RecordSet, but only one way - correct?

|||Yes, in SSAS there is only one result - either MDDataSet or Rowset. The only way to have second channel is to write into Trace which can be monitored with Profiler. There is no equivalent to SQL Server Pipe.Send() method.|||No solution yet!! I installed SQL SP2 (CTP) and I still have the same problem. Anyone please help !! I hope Microsoft is listening.|||No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.|||

Mosha Pasumansky wrote:

... If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.

Done! You can vote for this feature here:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=261868

|||Hi Mosha,

Sorry for replying late on same. I still have the problem Internal error: An unexpected exception occured." when I use a custom UDF. The UDF expects total of three array (SetToArray) parameter and I believe that' sthe problem. The UDF works fine with one array parameter.

Oh yes, this problem still exists with Sql Server SP2

Original Quote from Mosha - "No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it."

.NET Custom UDF - "Internal error: An unexpected exception occured."

Hi!

I have developed some .NET UDF for MSAS2005.
I compiled it, added assembly to database and tested it - it works.
But works only on my test seerver. On life server I've got this message:
"Internal error: An unexpected exception occured."
Assembly is registered as unrestricted.
I've maid simple test function in own assembly file, which just gives back 1.
It also works on test- and does not work on life server.
Customer will kill me :-( ....
P.S. Last post-SP1-fix (form July) is installed.

I (and a few other people) have been working on writing some stored procs for AS which will be available for public download soon, and we've seen this error a lot. The only information I can give you about it is that it seems to be sporadic and happen more often on lower-spec machines. I believe it's already been logged as a bug; until it's fixed, in my opinion you can't really use AS stored procs in a production environment.

Sorry...

Chris

|||

Thanx Chris for reply,
but it is not our case, because our Life-Server has much more Performance

|||

Are there any updates on this issue? I get this same error on our production server even though it never happened in development and testing (2 different servers).

The problem is very erratic and may happen or not happen in a given cube depending on how the query is built.

Any help would be appreciated.

|||

Hi All,

We have come across this error too but can only find evidence of Microsoft fixing this issue in SP1... http://support.microsoft.com/kb/912429/. However this issue is described as happening not in AS stored procs but in standard queries made even from SSMS.

Does anyone have any information or links etc that shows that this particular issue relating to SPs has been acknowledged by Microsoft? It's been requested by our project manager...

As per usual, any feedback will be gratefully received.

Rob.

|||

The error "Internal error: An unexpected exception occured." is generic in a sense, that it is raised when AS detects any internal inconsistency. So the KB912429 is about different cause. However, the following KB seems more relevant: http://support.microsoft.com/kb/918753/

Yura - I suggest you contact PSS and request this hotfix. Alternatively, you can wait for SP2, where this hotfix is rolled into.

HTH,

Mosha (http://www.mosha.com/msolap)

|||

We have already found (and solve) a problem. This error happends then, when R-ROLAP partition and something is not correct with DataTypes.

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method?

|||

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

|||

Mosha Pasumansky wrote:

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

Ok, now I got it. Is it only way? I mean, is it possible to have both - result of execution and trace messages? Like by .NET StoredProcedures in SQL Server - Pipe.Send(...) method give you possibility to send Rows, RewSets (as result set) and strings (as a-la PRINT messages).
But in SSAS we have only "chanel" - result. It could be string, numeric or RecordSet, but only one way - correct?

|||Yes, in SSAS there is only one result - either MDDataSet or Rowset. The only way to have second channel is to write into Trace which can be monitored with Profiler. There is no equivalent to SQL Server Pipe.Send() method.|||No solution yet!! I installed SQL SP2 (CTP) and I still have the same problem. Anyone please help !! I hope Microsoft is listening.|||No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.|||

Mosha Pasumansky wrote:

... If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.

Done! You can vote for this feature here:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=261868

|||Hi Mosha,

Sorry for replying late on same. I still have the problem Internal error: An unexpected exception occured." when I use a custom UDF. The UDF expects total of three array (SetToArray) parameter and I believe that' sthe problem. The UDF works fine with one array parameter.

Oh yes, this problem still exists with Sql Server SP2

Original Quote from Mosha - "No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it."

.NET Custom UDF - "Internal error: An unexpected exception occured."

Hi!

I have developed some .NET UDF for MSAS2005.
I compiled it, added assembly to database and tested it - it works.
But works only on my test seerver. On life server I've got this message:
"Internal error: An unexpected exception occured."
Assembly is registered as unrestricted.
I've maid simple test function in own assembly file, which just gives back 1.
It also works on test- and does not work on life server.
Customer will kill me :-( ....
P.S. Last post-SP1-fix (form July) is installed.

I (and a few other people) have been working on writing some stored procs for AS which will be available for public download soon, and we've seen this error a lot. The only information I can give you about it is that it seems to be sporadic and happen more often on lower-spec machines. I believe it's already been logged as a bug; until it's fixed, in my opinion you can't really use AS stored procs in a production environment.

Sorry...

Chris

|||

Thanx Chris for reply,
but it is not our case, because our Life-Server has much more Performance

|||

Are there any updates on this issue? I get this same error on our production server even though it never happened in development and testing (2 different servers).

The problem is very erratic and may happen or not happen in a given cube depending on how the query is built.

Any help would be appreciated.

|||

Hi All,

We have come across this error too but can only find evidence of Microsoft fixing this issue in SP1... http://support.microsoft.com/kb/912429/. However this issue is described as happening not in AS stored procs but in standard queries made even from SSMS.

Does anyone have any information or links etc that shows that this particular issue relating to SPs has been acknowledged by Microsoft? It's been requested by our project manager...

As per usual, any feedback will be gratefully received.

Rob.

|||

The error "Internal error: An unexpected exception occured." is generic in a sense, that it is raised when AS detects any internal inconsistency. So the KB912429 is about different cause. However, the following KB seems more relevant: http://support.microsoft.com/kb/918753/

Yura - I suggest you contact PSS and request this hotfix. Alternatively, you can wait for SP2, where this hotfix is rolled into.

HTH,

Mosha (http://www.mosha.com/msolap)

|||

We have already found (and solve) a problem. This error happends then, when R-ROLAP partition and something is not correct with DataTypes.

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method?

|||

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

|||

Mosha Pasumansky wrote:

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

Ok, now I got it. Is it only way? I mean, is it possible to have both - result of execution and trace messages? Like by .NET StoredProcedures in SQL Server - Pipe.Send(...) method give you possibility to send Rows, RewSets (as result set) and strings (as a-la PRINT messages).
But in SSAS we have only "chanel" - result. It could be string, numeric or RecordSet, but only one way - correct?

|||Yes, in SSAS there is only one result - either MDDataSet or Rowset. The only way to have second channel is to write into Trace which can be monitored with Profiler. There is no equivalent to SQL Server Pipe.Send() method.|||No solution yet!! I installed SQL SP2 (CTP) and I still have the same problem. Anyone please help !! I hope Microsoft is listening.|||No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.|||

Mosha Pasumansky wrote:

... If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.

Done! You can vote for this feature here:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=261868

|||Hi Mosha,

Sorry for replying late on same. I still have the problem Internal error: An unexpected exception occured." when I use a custom UDF. The UDF expects total of three array (SetToArray) parameter and I believe that' sthe problem. The UDF works fine with one array parameter.

Oh yes, this problem still exists with Sql Server SP2

Original Quote from Mosha - "No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it."

.NET Custom UDF - "Internal error: An unexpected exception occured."

Hi!

I have developed some .NET UDF for MSAS2005.
I compiled it, added assembly to database and tested it - it works.
But works only on my test seerver. On life server I've got this message:
"Internal error: An unexpected exception occured."
Assembly is registered as unrestricted.
I've maid simple test function in own assembly file, which just gives back 1.
It also works on test- and does not work on life server.
Customer will kill me :-( ....
P.S. Last post-SP1-fix (form July) is installed.

I (and a few other people) have been working on writing some stored procs for AS which will be available for public download soon, and we've seen this error a lot. The only information I can give you about it is that it seems to be sporadic and happen more often on lower-spec machines. I believe it's already been logged as a bug; until it's fixed, in my opinion you can't really use AS stored procs in a production environment.

Sorry...

Chris

|||

Thanx Chris for reply,
but it is not our case, because our Life-Server has much more Performance

|||

Are there any updates on this issue? I get this same error on our production server even though it never happened in development and testing (2 different servers).

The problem is very erratic and may happen or not happen in a given cube depending on how the query is built.

Any help would be appreciated.

|||

Hi All,

We have come across this error too but can only find evidence of Microsoft fixing this issue in SP1... http://support.microsoft.com/kb/912429/. However this issue is described as happening not in AS stored procs but in standard queries made even from SSMS.

Does anyone have any information or links etc that shows that this particular issue relating to SPs has been acknowledged by Microsoft? It's been requested by our project manager...

As per usual, any feedback will be gratefully received.

Rob.

|||

The error "Internal error: An unexpected exception occured." is generic in a sense, that it is raised when AS detects any internal inconsistency. So the KB912429 is about different cause. However, the following KB seems more relevant: http://support.microsoft.com/kb/918753/

Yura - I suggest you contact PSS and request this hotfix. Alternatively, you can wait for SP2, where this hotfix is rolled into.

HTH,

Mosha (http://www.mosha.com/msolap)

|||

We have already found (and solve) a problem. This error happends then, when R-ROLAP partition and something is not correct with DataTypes.

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method?

|||

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

|||

Mosha Pasumansky wrote:

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

Ok, now I got it. Is it only way? I mean, is it possible to have both - result of execution and trace messages? Like by .NET StoredProcedures in SQL Server - Pipe.Send(...) method give you possibility to send Rows, RewSets (as result set) and strings (as a-la PRINT messages).
But in SSAS we have only "chanel" - result. It could be string, numeric or RecordSet, but only one way - correct?

|||Yes, in SSAS there is only one result - either MDDataSet or Rowset. The only way to have second channel is to write into Trace which can be monitored with Profiler. There is no equivalent to SQL Server Pipe.Send() method.|||No solution yet!! I installed SQL SP2 (CTP) and I still have the same problem. Anyone please help !! I hope Microsoft is listening.|||No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.|||

Mosha Pasumansky wrote:

... If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.

Done! You can vote for this feature here:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=261868

|||Hi Mosha,

Sorry for replying late on same. I still have the problem Internal error: An unexpected exception occured." when I use a custom UDF. The UDF expects total of three array (SetToArray) parameter and I believe that' sthe problem. The UDF works fine with one array parameter.

Oh yes, this problem still exists with Sql Server SP2

Original Quote from Mosha - "No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it."

.NET Custom UDF - "Internal error: An unexpected exception occured."

Hi!

I have developed some .NET UDF for MSAS2005.
I compiled it, added assembly to database and tested it - it works.
But works only on my test seerver. On life server I've got this message:
"Internal error: An unexpected exception occured."
Assembly is registered as unrestricted.
I've maid simple test function in own assembly file, which just gives back 1.
It also works on test- and does not work on life server.
Customer will kill me :-( ....
P.S. Last post-SP1-fix (form July) is installed.

I (and a few other people) have been working on writing some stored procs for AS which will be available for public download soon, and we've seen this error a lot. The only information I can give you about it is that it seems to be sporadic and happen more often on lower-spec machines. I believe it's already been logged as a bug; until it's fixed, in my opinion you can't really use AS stored procs in a production environment.

Sorry...

Chris

|||

Thanx Chris for reply,
but it is not our case, because our Life-Server has much more Performance

|||

Are there any updates on this issue? I get this same error on our production server even though it never happened in development and testing (2 different servers).

The problem is very erratic and may happen or not happen in a given cube depending on how the query is built.

Any help would be appreciated.

|||

Hi All,

We have come across this error too but can only find evidence of Microsoft fixing this issue in SP1... http://support.microsoft.com/kb/912429/. However this issue is described as happening not in AS stored procs but in standard queries made even from SSMS.

Does anyone have any information or links etc that shows that this particular issue relating to SPs has been acknowledged by Microsoft? It's been requested by our project manager...

As per usual, any feedback will be gratefully received.

Rob.

|||

The error "Internal error: An unexpected exception occured." is generic in a sense, that it is raised when AS detects any internal inconsistency. So the KB912429 is about different cause. However, the following KB seems more relevant: http://support.microsoft.com/kb/918753/

Yura - I suggest you contact PSS and request this hotfix. Alternatively, you can wait for SP2, where this hotfix is rolled into.

HTH,

Mosha (http://www.mosha.com/msolap)

|||

We have already found (and solve) a problem. This error happends then, when R-ROLAP partition and something is not correct with DataTypes.

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method?

|||

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

|||

Mosha Pasumansky wrote:

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

Ok, now I got it. Is it only way? I mean, is it possible to have both - result of execution and trace messages? Like by .NET StoredProcedures in SQL Server - Pipe.Send(...) method give you possibility to send Rows, RewSets (as result set) and strings (as a-la PRINT messages).
But in SSAS we have only "chanel" - result. It could be string, numeric or RecordSet, but only one way - correct?

|||Yes, in SSAS there is only one result - either MDDataSet or Rowset. The only way to have second channel is to write into Trace which can be monitored with Profiler. There is no equivalent to SQL Server Pipe.Send() method.|||No solution yet!! I installed SQL SP2 (CTP) and I still have the same problem. Anyone please help !! I hope Microsoft is listening.|||No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.|||

Mosha Pasumansky wrote:

... If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.

Done! You can vote for this feature here:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=261868

|||Hi Mosha,

Sorry for replying late on same. I still have the problem Internal error: An unexpected exception occured." when I use a custom UDF. The UDF expects total of three array (SetToArray) parameter and I believe that' sthe problem. The UDF works fine with one array parameter.

Oh yes, this problem still exists with Sql Server SP2

Original Quote from Mosha - "No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it."

.NET Custom UDF - "Internal error: An unexpected exception occured."

Hi!

I have developed some .NET UDF for MSAS2005.
I compiled it, added assembly to database and tested it - it works.
But works only on my test seerver. On life server I've got this message:
"Internal error: An unexpected exception occured."
Assembly is registered as unrestricted.
I've maid simple test function in own assembly file, which just gives back 1.
It also works on test- and does not work on life server.
Customer will kill me :-( ....
P.S. Last post-SP1-fix (form July) is installed.

I (and a few other people) have been working on writing some stored procs for AS which will be available for public download soon, and we've seen this error a lot. The only information I can give you about it is that it seems to be sporadic and happen more often on lower-spec machines. I believe it's already been logged as a bug; until it's fixed, in my opinion you can't really use AS stored procs in a production environment.

Sorry...

Chris

|||

Thanx Chris for reply,
but it is not our case, because our Life-Server has much more Performance

|||

Are there any updates on this issue? I get this same error on our production server even though it never happened in development and testing (2 different servers).

The problem is very erratic and may happen or not happen in a given cube depending on how the query is built.

Any help would be appreciated.

|||

Hi All,

We have come across this error too but can only find evidence of Microsoft fixing this issue in SP1... http://support.microsoft.com/kb/912429/. However this issue is described as happening not in AS stored procs but in standard queries made even from SSMS.

Does anyone have any information or links etc that shows that this particular issue relating to SPs has been acknowledged by Microsoft? It's been requested by our project manager...

As per usual, any feedback will be gratefully received.

Rob.

|||

The error "Internal error: An unexpected exception occured." is generic in a sense, that it is raised when AS detects any internal inconsistency. So the KB912429 is about different cause. However, the following KB seems more relevant: http://support.microsoft.com/kb/918753/

Yura - I suggest you contact PSS and request this hotfix. Alternatively, you can wait for SP2, where this hotfix is rolled into.

HTH,

Mosha (http://www.mosha.com/msolap)

|||

We have already found (and solve) a problem. This error happends then, when R-ROLAP partition and something is not correct with DataTypes.

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method?

|||

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

|||

Mosha Pasumansky wrote:

Mutch more necessary are trace messages for Custom UDFs. You told what this messages are simple DataRows - could be, but how to send them? With which .NET API method ?

You can build standard rowset inside sproc and return it from there. Then, if you invoke it with CALL sproc you can get rowset back to the client tool (such as SSMS).

Ok, now I got it. Is it only way? I mean, is it possible to have both - result of execution and trace messages? Like by .NET StoredProcedures in SQL Server - Pipe.Send(...) method give you possibility to send Rows, RewSets (as result set) and strings (as a-la PRINT messages).
But in SSAS we have only "chanel" - result. It could be string, numeric or RecordSet, but only one way - correct?

|||Yes, in SSAS there is only one result - either MDDataSet or Rowset. The only way to have second channel is to write into Trace which can be monitored with Profiler. There is no equivalent to SQL Server Pipe.Send() method.|||No solution yet!! I installed SQL SP2 (CTP) and I still have the same problem. Anyone please help !! I hope Microsoft is listening.|||No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.|||

Mosha Pasumansky wrote:

... If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it.

Done! You can vote for this feature here:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=261868

|||Hi Mosha,

Sorry for replying late on same. I still have the problem Internal error: An unexpected exception occured." when I use a custom UDF. The UDF expects total of three array (SetToArray) parameter and I believe that' sthe problem. The UDF works fine with one array parameter.

Oh yes, this problem still exists with Sql Server SP2

Original Quote from Mosha - "No solution to what problem ? The original problem that started this thread is solved in SP1 (and therefore in SP2). And if you are refering to the new feature request of equivalent of SQL's Pipe.Send - than you shouldn't have expected new features out of the service pack. Service pack is to fix existing problems (whether wrong results, major performance issues or crashes), not to introduce new functionality. If you would like to see new functionality in the next version, the best way is to open an issue on 'connect', and let people vote for it."

**Update**

Hi
I'm working with SQL2000, and I defined the below structure:
MasterTable(No numeric(3),desc char(40)) No is PK
DetailTable(No numeric(3),code numeric(4),other char(40)) No&Code are PK
and I defined an Update Cascade for their relation.and I have an update
trigger on MasterTable.
My question:
when I update the MasterTable, which one occures first(the casecade
action,or update trigger on that)?
I would be grateful if somebody could give me a hint.
ThanksReferential Integrity frist, then the After trigger.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--

**sum**

Hi
I've follwoing data in table1 in SQL server2000,and I want to get the
result as below:
table1 result
Id Qty
-- --
1 500 1 500
2 502 2 1002
3 400 3 1402
4 140 4 1542
how is it possible in select statement?
Any help would be thankful.Here you go
CREATE TABLE #Table1(id int PRIMARY KEY, Quantity int NOT NULL)
INSERT INTO #Table1 VALUES(1,500)
INSERT INTO #Table1 VALUES(2,502)
INSERT INTO #Table1 VALUES(3,400)
INSERT INTO #Table1 VALUES(4,140)
SELECT id,
(SELECT SUM(Quantity) FROM #Table1 WHERE id <= O.id) As RunningTotal
FROM #Table1 O
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
<R> wrote in message news:opsyn8fezjmw7tkz@.system109.parskhazar.net...
> Hi
> I've follwoing data in table1 in SQL server2000,and I want to get the
> result as below:
> table1 result
> Id Qty
> -- --
> 1 500 1 500
> 2 502 2 1002
> 3 400 3 1402
> 4 140 4 1542
>
> how is it possible in select statement?
> Any help would be thankful.|||I missed the ORDER BY
SELECT id,
(SELECT SUM(Quantity) FROM #Table1 WHERE id <= O.id) As RunningTotal
FROM #Table1 O
ORDER By ID
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"Roji. P. Thomas" <thomasroji@.gmail.com> wrote in message
news:ecqyxfV0FHA.3892@.TK2MSFTNGP12.phx.gbl...
> Here you go
>
> CREATE TABLE #Table1(id int PRIMARY KEY, Quantity int NOT NULL)
> INSERT INTO #Table1 VALUES(1,500)
> INSERT INTO #Table1 VALUES(2,502)
> INSERT INTO #Table1 VALUES(3,400)
> INSERT INTO #Table1 VALUES(4,140)
> SELECT id,
> (SELECT SUM(Quantity) FROM #Table1 WHERE id <= O.id) As RunningTotal
> FROM #Table1 O
>
> --
> Roji. P. Thomas
> Net Asset Management
> http://toponewithties.blogspot.com
>
> <R> wrote in message news:opsyn8fezjmw7tkz@.system109.parskhazar.net...
>

**SQL-DMO Error 21776

Hi
I want to change the sa password ,but following error appearred,
"Error 21776; SQL-DMO the name 'dbo' was not found in the user collection
,if the name is a qualified name,use [] to seperate various parts of the
name, and try again."
I'd be grateful if anybody can help me.Hi
Will these help:
http://support.microsoft.com/defaul...kb;en-us;218172
or possibly:
http://support.microsoft.com/defaul...kb;en-us;239133
John
"maryam rezvani" wrote:

> Hi
> I want to change the sa password ,but following error appearred,
> "Error 21776; SQL-DMO the name 'dbo' was not found in the user collection
> ,if the name is a qualified name,use [] to seperate various parts of the
> name, and try again."
> I'd be grateful if anybody can help me.
>
>
>

**SQL-DMO 21776**

Hi
I want to change the sa password ,but following error appearred( the picture
enclosed),
"Error 21776; SQL-DMO the name 'dbo' was not found in the user collection
,if the name is a qualified name,use [] to seperate various parts of the
name, and try again."
I'd be grateful if anybody can help me.DMO doesn't like NULL database owners. You may get this message when one or
more database owners are invalid due to a restore, attach or because the
database owner's Windows account was removed.
You can identify problem databases with:
SELECT name
FROM master..sysdatabases
WHERE SUSER_SNAME(sid) IS NULL
You can then use sp_changedbowner to specify a valid database owner login.
See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"maryam rezvani" <rezvani@.parskhazar.net> wrote in message
news:%23Yx%236ohKFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hi
> I want to change the sa password ,but following error appearred( the
> picture
> enclosed),
> "Error 21776; SQL-DMO the name 'dbo' was not found in the user collection
> ,if the name is a qualified name,use [] to seperate various parts of the
> name, and try again."
> I'd be grateful if anybody can help me.
>
>
>

**Restoring just the data part of a DB **

Hi
I'm working with SQL 2000,and I've a backup of a full recovery DB from
another server,how can I restore this DB on my server without restoring the
log file,cause it needs a lot space?
Any help would be thankful.You can't. See my prior post (no need to re-post to a new thread). Shrink th
e database before you do
the backup, or make sure you have enough disk space to do the restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"M R" <rezvani@.parskhazar.net> wrote in message news:%23tBM1SfVFHA.3076@.TK2MSFTNGP10.phx.gb
l...
> Hi
> I'm working with SQL 2000,and I've a backup of a full recovery DB from
> another server,how can I restore this DB on my server without restoring th
e
> log file,cause it needs a lot space?
> Any help would be thankful.
>|||but I've got the backup from another server which I've no access to that
server to shrink it first,
and I can't make more than avalable space now I have,so is there any other
solution?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uXytGXfVFHA.3944@.TK2MSFTNGP10.phx.gbl...
> You can't. See my prior post (no need to re-post to a new thread). Shrink
the database before you do
> the backup, or make sure you have enough disk space to do the restore.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "M R" <rezvani@.parskhazar.net> wrote in message
news:%23tBM1SfVFHA.3076@.TK2MSFTNGP10.phx.gbl...
the
>|||I'm afraid not. You could try and open a support case with MS and see if the
re exist any hack for
this, but there's no supported or documented way to accomplish this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"M R" <rezvani@.parskhazar.net> wrote in message news:e90bd5fVFHA.616@.TK2MSFTNGP12.phx.gbl..
.
> but I've got the backup from another server which I've no access to that
> server to shrink it first,
> and I can't make more than avalable space now I have,so is there any other
> solution?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:uXytGXfVFHA.3944@.TK2MSFTNGP10.phx.gbl...
> the database before you do
> news:%23tBM1SfVFHA.3076@.TK2MSFTNGP10.phx.gbl...
> the
>

**Restoring a db with size 167049KB**

Hi
I'm working with SQL2000 and I want to restore a db which I've got from
another server into my server with this size : 167049KB,and I've 11gb on
Drive E,but following error appearred after restoring:
"There's insufficient free space on disk volume 'e:' to create the
database.the database requires 28614066176 additional free bytes ,while only
2147155 968 bytes are available. Restore databse is terminated abnormally."
why?Can anybody help me?
Any help would be thankful.Do RESTORE FILELISTONLY and check the sum of size for the database files. Th
is is the size of the
database files when you took the backup and this is the space you need to do
restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"M R" <rezvani@.parskhazar.net> wrote in message news:OTxT%23eeVFHA.3424@.TK2MSFTNGP09.phx.gb
l...
> Hi
> I'm working with SQL2000 and I want to restore a db which I've got from
> another server into my server with this size : 167049KB,and I've 11gb on
> Drive E,but following error appearred after restoring:
> "There's insufficient free space on disk volume 'e:' to create the
> database.the database requires 28614066176 additional free bytes ,while on
ly
> 2147155 968 bytes are available. Restore databse is terminated abnormally.
"
> why?Can anybody help me?
> Any help would be thankful.
>|||Looks like the database you backed up might have lot of free space in the
data file (.mdf/ .ndf) or/and Huge Log file(.ldf).Check the original
database size. Just looking the backup size of the database could be
deceiving. The backup file is the size of the data in your database it does
not include the free space.
Try to backup the transaction log in the original database/ if you don't
need the transaction backup truncate the log file and shrink the log file
to a reasonable size. Do not shrink the data file (.mdf / .ndf) that might
create fragmentation on the data.
-regards
Sarav...
"M R" <rezvani@.parskhazar.net> wrote in message
news:OTxT%23eeVFHA.3424@.TK2MSFTNGP09.phx.gbl...
> Hi
> I'm working with SQL2000 and I want to restore a db which I've got from
> another server into my server with this size : 167049KB,and I've 11gb on
> Drive E,but following error appearred after restoring:
> "There's insufficient free space on disk volume 'e:' to create the
> database.the database requires 28614066176 additional free bytes ,while
only
> 2147155 968 bytes are available. Restore databse is terminated
abnormally."
> why?Can anybody help me?
> Any help would be thankful.
>

**Restore error**

Hi
I define a login name 'L1' in SQL2000 the owner of it's db called 'db1' .L1
should backup and restore (restoring as new db too) it's databes ,so I set
the L1 as a 'db_owner' and 'db_backupoperator' and 'database creator' in db1
and 'db_owner' in master too.now it can backup the database successfully but
when it wants to restore the db as a new one at the end of progressing the
blue bar of restoring following error appearred :
"Server user 'L1' is not a valid user in database 'db1' ,restore db is
terminated abnormally."
any help would be thakful.Hi
You don't say if these are on the same server! But this may help
http://support.microsoft.com/defaul...kb;en-us;240872
John
"M R" wrote:

> Hi
> I define a login name 'L1' in SQL2000 the owner of it's db called 'db1' .L
1
> should backup and restore (restoring as new db too) it's databes ,so I set
> the L1 as a 'db_owner' and 'db_backupoperator' and 'database creator' in d
b1
> and 'db_owner' in master too.now it can backup the database successfully b
ut
> when it wants to restore the db as a new one at the end of progressing the
> blue bar of restoring following error appearred :
> "Server user 'L1' is not a valid user in database 'db1' ,restore db is
> terminated abnormally."
> any help would be thakful.
>
>|||These are on the same server,
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:714B1D9E-A21F-4850-AFE6-8A85137E05DD@.microsoft.com...
> Hi
> You don't say if these are on the same server! But this may help
> http://support.microsoft.com/defaul...kb;en-us;240872
> John
> "M R" wrote:
>
.L1
set
db1
but
the|||Hi
If you change the owner of the database before backing up do you have
the same problem?
You may want to try dropping the user/login and re-create them.
John

**longest text in SQL**

Hi
I'm working with SQL 2000 and I want to know what data type is suitable
for long texts and what's the limit for its length?
Any help would be thankful.You can use TEXT or NTEXT.
TEXT has a limit of 2GB, but does not support Unicode data. NTEXT has a
limit of 1 GB and can support Unicode data.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
<R> wrote in message news:ops8av5uypmw7tkz@.system109.parskhazar.net...
> Hi
> I'm working with SQL 2000 and I want to know what data type is suitable
> for long texts and what's the limit for its length?
> Any help would be thankful.|||varchar(8000) can hold 8000 bytes and can be used in string functions
text can hold 2GB but can only be a variable by being a parameter on a
stored procedure/function and can only be used in certain string functions
and cannot be assigned.
nvarchar(4000) holds 4000 bytes and is unicode.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
<R> wrote in message news:ops8av5uypmw7tkz@.system109.parskhazar.net...
> Hi
> I'm working with SQL 2000 and I want to know what data type is suitable
> for long texts and what's the limit for its length?
> Any help would be thankful.|||text datatype takes 2GB of data. If 8k is enough go with the varchar or char
datatypes.
MC
<R> wrote in message news:ops8av5uypmw7tkz@.system109.parskhazar.net...
> Hi
> I'm working with SQL 2000 and I want to know what data type is suitable
> for long texts and what's the limit for its length?
> Any help would be thankful.

**login problem**

Hi
I am working with SQL 2000 and I have a resotred database with these users
in branch of its users :
DB1
user login
-- --
dbo X
L1L1
L2L2
but in other databases I have the following list:
DB2
user login
-- --
dbo sa
XX
L1L1
L2L2
I always create login names and user names with the same name, so in
related databases they will appear like above and a row of (dbo,sa) which
is default in each database.now I want to change the list of my first
database in order to be similar like the second list. how does it
possible? in other word,how can I have the row of (dbo,X) in 2 rows of
(dbo,sa) , (X,X)?
Thank you in advance.
Hi
Lookup sp_changedbowner stored procedure in the BOL
<R> wrote in message news:ops47g3iu4mw7tkz@.system109.parskhazar.net...
> Hi
> I am working with SQL 2000 and I have a resotred database with these users
> in branch of its users :
> DB1
> user login
> -- --
> dbo X
> L1 L1
> L2 L2
> but in other databases I have the following list:
> DB2
> user login
> -- --
> dbo sa
> X X
> L1 L1
> L2 L2
> I always create login names and user names with the same name, so in
> related databases they will appear like above and a row of (dbo,sa) which
> is default in each database.now I want to change the list of my first
> database in order to be similar like the second list. how does it
> possible? in other word,how can I have the row of (dbo,X) in 2 rows of
> (dbo,sa) , (X,X)?
> Thank you in advance.
|||Uri's answer was correct but you may find these useful for stuff along those
lines:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's 2000
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/colu...rdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://www.sqlservercentral.com/scri...tions/1598.asp Script
Roles and Permissions
Andrew J. Kelly SQL MVP
<R> wrote in message news:ops47g3iu4mw7tkz@.system109.parskhazar.net...
> Hi
> I am working with SQL 2000 and I have a resotred database with these users
> in branch of its users :
> DB1
> user login
> -- --
> dbo X
> L1 L1
> L2 L2
> but in other databases I have the following list:
> DB2
> user login
> -- --
> dbo sa
> X X
> L1 L1
> L2 L2
> I always create login names and user names with the same name, so in
> related databases they will appear like above and a row of (dbo,sa) which
> is default in each database.now I want to change the list of my first
> database in order to be similar like the second list. how does it
> possible? in other word,how can I have the row of (dbo,X) in 2 rows of
> (dbo,sa) , (X,X)?
> Thank you in advance.

**login problem**

Hi
I am working with SQL 2000 and I have a resotred database with these users
in branch of its users :
DB1
user login
-- --
dbo X
L1 L1
L2 L2
but in other databases I have the following list:
DB2
user login
-- --
dbo sa
X X
L1 L1
L2 L2
I always create login names and user names with the same name, so in
related databases they will appear like above and a row of (dbo,sa) which
is default in each database.now I want to change the list of my first
database in order to be similar like the second list. how does it
possible? in other word,how can I have the row of (dbo,X) in 2 rows of
(dbo,sa) , (X,X)?
Thank you in advance.Hi
Lookup sp_changedbowner stored procedure in the BOL
<R> wrote in message news:ops47g3iu4mw7tkz@.system109.parskhazar.net...
> Hi
> I am working with SQL 2000 and I have a resotred database with these users
> in branch of its users :
> DB1
> user login
> -- --
> dbo X
> L1 L1
> L2 L2
> but in other databases I have the following list:
> DB2
> user login
> -- --
> dbo sa
> X X
> L1 L1
> L2 L2
> I always create login names and user names with the same name, so in
> related databases they will appear like above and a row of (dbo,sa) which
> is default in each database.now I want to change the list of my first
> database in order to be similar like the second list. how does it
> possible? in other word,how can I have the row of (dbo,X) in 2 rows of
> (dbo,sa) , (X,X)?
> Thank you in advance.|||Uri's answer was correct but you may find these useful for stuff along those
lines:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's 2000
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/col...se
s.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://www.sqlservercentral.com/scr...utions/1598.asp Script
Roles and Permissions
Andrew J. Kelly SQL MVP
<R> wrote in message news:ops47g3iu4mw7tkz@.system109.parskhazar.net...
> Hi
> I am working with SQL 2000 and I have a resotred database with these users
> in branch of its users :
> DB1
> user login
> -- --
> dbo X
> L1 L1
> L2 L2
> but in other databases I have the following list:
> DB2
> user login
> -- --
> dbo sa
> X X
> L1 L1
> L2 L2
> I always create login names and user names with the same name, so in
> related databases they will appear like above and a row of (dbo,sa) which
> is default in each database.now I want to change the list of my first
> database in order to be similar like the second list. how does it
> possible? in other word,how can I have the row of (dbo,X) in 2 rows of
> (dbo,sa) , (X,X)?
> Thank you in advance.