SQL SQLExpress: sp3

Showing posts with label sp3. Show all posts

Thursday, March 8, 2012

.NET DiffGram

I am running VS Studio 2003 and a VB.NET web application. I have installed
SQLXML 3 SP3 on both my .NET machine and my SQL server machine, and SOAP 3 on
db Server machine.
I have created a Diffgram from a dataset with writexml to stream and xsd
with SQL relations mapped. Yet when it tries to execute the SQLXMLcommand, I
continually get an Invalid Authorization Specification error.
I have not found anything about it online. Please let me know what I can do
to help the situation. I would love to use Diff gram instead of hand writing
the same XML consuming code into SQL server.
thanks
Hello,
Could you please send the repro so I can take a look ?
Thanks,
Monica Frintu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
|||This is an interesting error. Do you get this error while you are executing
the SqlXmlcommand? It would help a lot, if you can send your diffgram and
the managed code to execute it.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"gehrigsranch" <gehrigsranch@.discussions.microsoft.com> wrote in message
news:6BDCC7A7-0E15-46FD-810B-46558F0CB035@.microsoft.com...
>I am running VS Studio 2003 and a VB.NET web application. I have installed
> SQLXML 3 SP3 on both my .NET machine and my SQL server machine, and SOAP 3
> on
> db Server machine.
> I have created a Diffgram from a dataset with writexml to stream and xsd
> with SQL relations mapped. Yet when it tries to execute the
> SQLXMLcommand, I
> continually get an Invalid Authorization Specification error.
> I have not found anything about it online. Please let me know what I can
> do
> to help the situation. I would love to use Diff gram instead of hand
> writing
> the same XML consuming code into SQL server.
> thanks

Tuesday, March 6, 2012

.net connectivity and SQL connectivity problems

Hi,
Have a quick question. Having a problem connecting from the IIS server
(windows 2000 sp3) which hosts the asp.net application to retrieve data from
an SQL server (windows nt 4, sql 7). The error keeps coming up SQL server
does not exist or access denied. I've checked the permissions, etc and it
seems to be fine. I used query analyzer from the windows 2000 (has
enterprise connectivity tools) machine and it works. Here is the connection:
protected string myAdminConnectionString = "Provider=dbmssocn;Data
Source=PIMZZ00;Initial Catalog=PIM;User ID=temp;Password=temp";
also tried
protected string myAdminConnectionString = "Data Source=192.168.1.2;Initial
Catalog=PIM;User ID=temp;Password=temp";
I tried installing SQL server on the 2000 machine (had an extra license) but
MMC is getting an error. Has anyone seen this error before?
Application popup: mmc - Application Error: The instructions at 0x77abfcf5
referenced memory at 0x0000000" The memory could not be read.
In the event viewer it came up with:
The description for Event ID 19011 in Source (MSSQLServer) cannot be found.
The local computer may not have the necessary registry information or message
DLL files to display messages from a remote computer. The following
information is part of the event (SpnRegister): Error 1355.
Thanks - Zack
Hi Zack,
Two thoughts on this. One make a test UDL to test connectivity through
the provider. If this works, then open the UDL with Notepad and use the
same connection string in your application. If it fails, then make a
network trace from the client to capture the traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Friday, February 24, 2012

.BAK is growing up

Hello ,Folks
SQL Server 2000 (sp3)
I have posted this question yesterday and still have not got an idea why it
is happening.
I have a database 11GB and every night I do a full backup (WITH INIT) of
the database that .BAK file was always around 11 GB as well
Two days ago it finnished (backup operation) with 16GB .bak file. The
.MDF,.LDF files have not grown since.
The question is WHY is my .BAK file grew so much? What could be a
reason?
ThanksHi Alex
From the sp_spaceused information you figures don't correspond
database_name database_size unallocated space
-- -- --
dbname 28511.69 MB 519.01 MB
reserved data index_size unused
-- -- -- --
23568632 KB 6408816 KB 6066240 KB 11093576 KB
This says your database is 27GB and there is 10GB unused space, so 16GB for
a backup seems reasonable.
John
"Alex" wrote:
> Hello ,Folks
> SQL Server 2000 (sp3)
> I have posted this question yesterday and still have not got an idea why it
> is happening.
> I have a database 11GB and every night I do a full backup (WITH INIT) of
> the database that .BAK file was always around 11 GB as well
> Two days ago it finnished (backup operation) with 16GB .bak file. The
> ..MDF,.LDF files have not grown since.
> The question is WHY is my .BAK file grew so much? What could be a
> reason?
> Thanks
>
>|||John
Yes , you are right, the database contains three files , however , it has
been all time that the .BAK file was 11GB , so what happened at night to
grow to 16GB?
Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...
> Hi Alex
> From the sp_spaceused information you figures don't correspond
> database_name database_size unallocated space
> -- -- --
> dbname 28511.69 MB 519.01 MB
> reserved data index_size unused
> -- -- -- --
> 23568632 KB 6408816 KB 6066240 KB 11093576 KB
>
> This says your database is 27GB and there is 10GB unused space, so 16GB
> for
> a backup seems reasonable.
> John
> "Alex" wrote:
>> Hello ,Folks
>> SQL Server 2000 (sp3)
>> I have posted this question yesterday and still have not got an idea why
>> it
>> is happening.
>> I have a database 11GB and every night I do a full backup (WITH INIT)
>> of
>> the database that .BAK file was always around 11 GB as well
>> Two days ago it finnished (backup operation) with 16GB .bak file. The
>> ..MDF,.LDF files have not grown since.
>> The question is WHY is my .BAK file grew so much? What could be a
>> reason?
>> Thanks
>>|||Hi Alex
The simple answer would be that there is more information in the file!
Unless you are archiving data from your database then you would expect a
steady growth. A 4GB increment would indicate something abnormal has
happened, such as someone copyied a large table. To find out space used by
each table you could run something like:
CREATE TABLE #spaceused ( name nvarchar(128),
rows char(11),
reserved varchar(18),
data varchar(18),
index_size varchar(18),
unused varchar(18),
reservedK AS CAST(LEFT(reserved,charindex(' ', reserved)-1) AS BIGINT) )
EXEC sp_msforeachtable 'INSERT INTO #spaceused ( name, rows, reserved, data,
index_size, unused ) EXEC sp_spaceused [?]'
SELECT * FROM #spaceused
ORDER BY reservedK DESC
DROP TABLE #spaceused
John
"Alex" wrote:
> John
> Yes , you are right, the database contains three files , however , it has
> been all time that the .BAK file was 11GB , so what happened at night to
> grow to 16GB?
> Thanks
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...
> > Hi Alex
> >
> > From the sp_spaceused information you figures don't correspond
> >
> > database_name database_size unallocated space
> > -- -- --
> > dbname 28511.69 MB 519.01 MB
> >
> > reserved data index_size unused
> > -- -- -- --
> > 23568632 KB 6408816 KB 6066240 KB 11093576 KB
> >
> >
> > This says your database is 27GB and there is 10GB unused space, so 16GB
> > for
> > a backup seems reasonable.
> >
> > John
> >
> > "Alex" wrote:
> >
> >> Hello ,Folks
> >>
> >> SQL Server 2000 (sp3)
> >>
> >> I have posted this question yesterday and still have not got an idea why
> >> it
> >> is happening.
> >>
> >> I have a database 11GB and every night I do a full backup (WITH INIT)
> >> of
> >> the database that .BAK file was always around 11 GB as well
> >> Two days ago it finnished (backup operation) with 16GB .bak file. The
> >> ..MDF,.LDF files have not grown since.
> >>
> >> The question is WHY is my .BAK file grew so much? What could be a
> >> reason?
> >>
> >> Thanks
> >>
> >>
> >>
>
>

.BAK is growing up

.BAK file is growing up

Hello.
SQL Server 2000 (SP3)
I monitor my db's size and it has not changed about a month , however .BAK
file is grown up for about 5gb. Is it possible?
Db size is about 30gb and we have autogrow feature turned on (10 percent)
ThanksAlthough your db size is 30 gigs. It could be that there was ample free
space in it and it is filling up.|||Although your db size is 30 gigs, it could be that there was ample free
space in it and it is filling up.|||Hi,
Since if the file backup file growth is very high; then i feel that you are
appending to the backup file.
Execute the below command to check how many backup sets you have in your
backup file.
RESTORE Headeronly FROM disk='c:\master.bak'
A client can use RESTORE HEADERONLY to retrieve all the backup header
information for all backups on a particular backup device. The header
information is sent as a row by the server for each backup on a given backup
device in a table
Thanks
Hari
SQL Server MVP
"Alex" <test@.test.com> wrote in message
news:eNrI6J62GHA.3944@.TK2MSFTNGP04.phx.gbl...
> Hello.
> SQL Server 2000 (SP3)
> I monitor my db's size and it has not changed about a month , however
> .BAK file is grown up for about 5gb. Is it possible?
> Db size is about 30gb and we have autogrow feature turned on (10 percent)
> Thanks
>|||Hari
> Since if the file backup file growth is very high; then i feel that you
> are appending to the backup file.
No, it suddenly happened (growing .BAK ) last night and we have been
using WITH INIT option for all time.
So I have only one file in .BAK sets
Any ideas please
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23qhOwp62GHA.4764@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Since if the file backup file growth is very high; then i feel that you
> are appending to the backup file.
> Execute the below command to check how many backup sets you have in your
> backup file.
> RESTORE Headeronly FROM disk='c:\master.bak'
>
> A client can use RESTORE HEADERONLY to retrieve all the backup header
> information for all backups on a particular backup device. The header
> information is sent as a row by the server for each backup on a given
> backup device in a table
> Thanks
> Hari
> SQL Server MVP
> "Alex" <test@.test.com> wrote in message
> news:eNrI6J62GHA.3944@.TK2MSFTNGP04.phx.gbl...
>> Hello.
>> SQL Server 2000 (SP3)
>> I monitor my db's size and it has not changed about a month , however
>> .BAK file is grown up for about 5gb. Is it possible?
>> Db size is about 30gb and we have autogrow feature turned on (10
>> percent)
>> Thanks
>|||Hello,
Can you execute a SP_Spaceused on that database and see how much is utilized
for data and index.
THanks
Hari
SQL Server MVP
"Alex" <test@.test.com> wrote in message
news:%23FWeB372GHA.3476@.TK2MSFTNGP04.phx.gbl...
> Hari
>> Since if the file backup file growth is very high; then i feel that you
>> are appending to the backup file.
> No, it suddenly happened (growing .BAK ) last night and we have been
> using WITH INIT option for all time.
> So I have only one file in .BAK sets
> Any ideas please
>
>
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23qhOwp62GHA.4764@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> Since if the file backup file growth is very high; then i feel that you
>> are appending to the backup file.
>> Execute the below command to check how many backup sets you have in your
>> backup file.
>> RESTORE Headeronly FROM disk='c:\master.bak'
>>
>> A client can use RESTORE HEADERONLY to retrieve all the backup header
>> information for all backups on a particular backup device. The header
>> information is sent as a row by the server for each backup on a given
>> backup device in a table
>> Thanks
>> Hari
>> SQL Server MVP
>> "Alex" <test@.test.com> wrote in message
>> news:eNrI6J62GHA.3944@.TK2MSFTNGP04.phx.gbl...
>> Hello.
>> SQL Server 2000 (SP3)
>> I monitor my db's size and it has not changed about a month , however
>> .BAK file is grown up for about 5gb. Is it possible?
>> Db size is about 30gb and we have autogrow feature turned on (10
>> percent)
>> Thanks
>>
>|||Hi,Hari
Here iis an output
database_name
database_size unallocated space
------
-- --
dbname
28511.69 MB 519.01 MB
reserved data index_size
unused
-- -- -- --
23568632 KB 6408816 KB 6066240 KB 11093576 KB
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%238MZOy92GHA.4164@.TK2MSFTNGP05.phx.gbl...
> Hello,
> Can you execute a SP_Spaceused on that database and see how much is
> utilized for data and index.
> THanks
> Hari
> SQL Server MVP
> "Alex" <test@.test.com> wrote in message
> news:%23FWeB372GHA.3476@.TK2MSFTNGP04.phx.gbl...
>> Hari
>> Since if the file backup file growth is very high; then i feel that you
>> are appending to the backup file.
>> No, it suddenly happened (growing .BAK ) last night and we have been
>> using WITH INIT option for all time.
>> So I have only one file in .BAK sets
>> Any ideas please
>>
>>
>>
>> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
>> news:%23qhOwp62GHA.4764@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> Since if the file backup file growth is very high; then i feel that you
>> are appending to the backup file.
>> Execute the below command to check how many backup sets you have in your
>> backup file.
>> RESTORE Headeronly FROM disk='c:\master.bak'
>>
>> A client can use RESTORE HEADERONLY to retrieve all the backup header
>> information for all backups on a particular backup device. The header
>> information is sent as a row by the server for each backup on a given
>> backup device in a table
>> Thanks
>> Hari
>> SQL Server MVP
>> "Alex" <test@.test.com> wrote in message
>> news:eNrI6J62GHA.3944@.TK2MSFTNGP04.phx.gbl...
>> Hello.
>> SQL Server 2000 (SP3)
>> I monitor my db's size and it has not changed about a month , however
>> .BAK file is grown up for about 5gb. Is it possible?
>> Db size is about 30gb and we have autogrow feature turned on (10
>> percent)
>> Thanks
>>
>>
>

.BAK file is growing up

Sunday, February 19, 2012

...Contains more than the maximum number of prefixes. The maximum is 3.

SQL Server 2000 8.00.760 (SP3)

I've been working on a test system and the following UDF worked fine.
It runs in the "current" database, and references another database on
the same server called 127-SuperQuote.

CREATE FUNCTION fnGetFormattedAddress(@.WorkID int)

RETURNS varchar(130)

BEGIN

DECLARE

@.Address1 As varchar(50)
@.ReturnAddress As varchar(130)

SELECT
@.Address1 = [127-SuperQuote].dbo.tblCompany.Address1
FROM
[Work] INNER JOIN
[127-SuperQuote].dbo.tblCompany ON [Work].ClientID =
[127-SuperQuote].dbo.tblCompany.CompanyID
WHERE
[Work].WorkID = @.WorkID

IF @.Address1 IS NOT NULL
SET @.ReturnAddress = @.ReturnAddress + @.Address1 + CHAR(13)+ CHAR(10)

RETURN @.ReturnAddress

END

So now the system has gone live and it turns out that the live
"SuperQuote" database is on a different server.

I've linked the server and changed the function as below, but I get an
error both in QA and when checking Syntax in the UDF builder:

The number name 'Zen.SuperQuote.dbo.tblCompany' contains more than the
maximum number of prefixes. The maximum is 3.

CREATE FUNCTION fnGetFormattedAddress(@.WorkID int)

RETURNS varchar(130)

BEGIN

DECLARE

@.Address1 As varchar(50)
@.ReturnAddress As varchar(130)

SELECT
@.Address1 = Zen.SuperQuote.dbo.tblCompany.Address1
FROM
[Work] INNER JOIN
Zen.SuperQuote.dbo.tblCompany ON [Work].ClientID =
Zen.SuperQuote.dbo.tblCompany.CompanyID
WHERE
[Work].WorkID = @.WorkID

IF @.Address1 IS NOT NULL
SET @.ReturnAddress = @.ReturnAddress + @.Address1 + CHAR(13)+ CHAR(10)

RETURN @.ReturnAddress

END

How can I get round this? By the way, I've rather simplified the
function to ease readability. Also, I haven't posted any DDL because I
don't think that's the problem!

Thanks

Edwardteddysnips@.hotmail.com wrote:
[...]

Alias, you dolt!

Sorry if I've wasted anyone's time.

Edward|||Thanks for wasting even more of everyone's time by not indicating your mistake and having this useless thread replicated to dozens of other forums!

From http://www.developmentnow.com/g/95_...ximum-is-3-.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Thursday, March 8, 2012

.NET DiffGram

Tuesday, March 6, 2012

.net connectivity and SQL connectivity problems

Friday, February 24, 2012

.BAK is growing up

.BAK is growing up

.BAK is growing up

.BAK file is growing up

.BAK file is growing up

.BAK file is growing up

Sunday, February 19, 2012

...Contains more than the maximum number of prefixes. The maximum is 3.

SQL SQLExpress

Blog Archive

About Me