sql error: January 2012

Friday, January 27, 2012

"Attempt to repair any minor problems." What is the point?

What is the point of having this checkbox on the Database Mainenance Plan
properties (Integrity tab) window?
For the plan to fix minor problems, it requires the db to be in Single User
Mode.
"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
processed. Database needs to be in single user mode."
For the plan to execute it requires SQLAgent to be running.
For SqlAgent to be running, it requires NOT Single User Mode.The message indicates that the *database* needs to be in single-user mode.
This should not be confused with the *server* being in single-user mode.
Personally, I prefer to fix errors manually rather than do this in a
maintenance plan.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Travis" <travis@.c*Y*C*l*Eutah.com> wrote in message
news:%23GMp%238tMEHA.1608@.TK2MSFTNGP12.phx.gbl...
> What is the point of having this checkbox on the Database Mainenance Plan
> properties (Integrity tab) window?
>
> For the plan to fix minor problems, it requires the db to be in Single
User
> Mode.
> "[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
> processed. Database needs to be in single user mode."
> For the plan to execute it requires SQLAgent to be running.
> For SqlAgent to be running, it requires NOT Single User Mode.
>
>|||I have done a maintenance plan and I have this error:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on 31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free space)...
Rebuilding indexes for table 'AccessStatusMap'
......................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628: [Microsoft][ODBC SQL Server Driver][SQL Server]A floating point exception occurred in the user process. Current transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.
=BFDo Anybody know, why is it the cause of this error?
Sincerely,
Ignacio
>--Original Message--
>What is the point of having this checkbox on the Database Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be running.
>For SqlAgent to be running, it requires NOT Single User Mode.
>
>.
>|||My guess is you have some invalid float data in the table/index. Turn on
trace flag 2570 and run DBCC CHECKTABLE on the table in question. 2570
switches on some extra data range value checking of things like floats and
dates. FYI: this functionality is controlled by documented T-SQL in SQL
Server 2005 rather than a trace flag.
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ignacio" <anonymous@.discussions.microsoft.com> wrote in message
news:1bfe01c44737$1dc83550$3501280a@.phx.gbl...
I have done a maintenance plan and I have this error:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged
on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on
31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free
space)...
Rebuilding indexes for table 'AccessStatusMap'
......................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating
point exception occurred in the user process. Current
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
execution completed. If DBCC printed error messages,
contact your system administrator.
¿Do Anybody know, why is it the cause of this error?
Sincerely,
Ignacio
>--Original Message--
>What is the point of having this checkbox on the Database
Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to
be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair
statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be
running.
>For SqlAgent to be running, it requires NOT Single User
Mode.
>
>.
>

"Application Log is Full"

Can anyone tell me how to empty the Application log ,as I keep getting Application is Full message on the SQL box.
Many thanks
ZI believe this would be one of the three event logs that the OS maintains (application, security, system).

You should run event viewer and either increase space for the log, or allow it to rollover and drop oldest entries (or both). Many times the applucation log will fill up when you have sql server (or other apps) throwing numerous errors over a period of time.

"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access deni

hi all,

this is punya,

and i am having a problem which was encountered by youin the past. My actual proble is " I am having vs.net 2005 along with MS SQL Server 2000 (Server1) in my system. The MS SQL Server is database server for some of my collegues. Whenever i want to connect to my Server1 DBServer it is givng the following error message."

"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied"

and the other guys are able to connect to the same DBServer. and one thing i am able to connect to other DBServers which are in Lan..

please Help me.what does the connection string look like? windows or sql auth?

some samples here: http://www.connectionstrings.com

"..Transform requires script Text and Language.." error?

Hi,
I'm trying setup a package to replicate a database table into a another
database's table.
I thought a Data Driven Query Task would work. I got as far as making the
two connections and setting up the Data Driven Query's source SELECT (with
stored procedure I created in the source database) and destination table
under the Bindings tab.
However, when I run the task I get the error below
"ActiveX Scripting Transform requires script Text and Language and at least
one Phase function to be specified."
When I preview the data in under the task's Source tab, I see data AND the
destination table gets created but not data gets transfered. Can someone
please help on what this error means?
Also, I eventually want to update this destination table with several other
subsequent queries from other databases in order to conslidate related data
into one large reporting table but I have to get the initial population of
data to work first. This will be refreshed daily
Does this approach/package task seem to be applicable?
Thanks, Dave.
Dave,
you'd be best off posting in the separate DTS discussion group.
Rgds,
Paul Ibison
|||Open up your package, save it as a bas file and post it here.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||I have the exact same problem as this guy. Could you please help?
thanks
marlene
url:http://www.ureader.com/msg/1156295.aspx

"...remote name could not be resolved" when using custom Web App

Hi all,
I'm getting a headache trying to figure out what is going on here. I've set
up Reporting Services on 1 dev machine and 2 servers and using a Web
Application that I am developing to access Reporting Services to generate a
report for me. Everything works fine on both my development machine and one
of the servers, but the other server keeps on producing this error:
"The underlying connection was closed: The remote name could not be resolved."
As far as I can remember, every instance of RS was installed identically.
Also, I can use the Report Manager from the server and from networked
computers to generate reports with no issues. Its only upon my Web Apps
access to the RS that I get this error. Is this similar to the SSL issues a
lot of people have been discussing? I'm still quite a newbie when it comes to
sql server and iis, so if this has been answered elsewhere already, I'd
appreciate a link :)
AndreAfter a bit of debugging I found that the problem was actually just that a
static web refference to the report server was being used, and that was
pointing at the other server still.
All works fine now.

"...could not load DCOM"

Hello.
I have the same problem.
Version is
Microsoft SQL Server 2000 - 8.00.2039 - Service Pack 4 installed.
Before installation SP4 I had error "Unexpected NULL value returned for
column '[OpenXML].OutSourcedPartCount' from the OLE DB provider
'OpenXML'. This column cannot be NULL." when I didn't specified values
(no XML branches) for columns with default values.
Any ideas?
Zevakov Andrew
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message184753.htmlI can add that in event viewer I have such entries after calling my
stored proc :
Source: MSSQLSERVER
"Failed to Initialize COM (CoInitializeEx returned 80010119)"
"Heterogeneous Queries and Remote RPC will be disabled."
Zevakov Andrew
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message184753.html

"," (Comma) as Decimal Place - SQL SERVER 2000 /MSDE2000 does not work

Hi All,
If we change the System settings to Swedish(Finland), the decimal space is a
Comma "," instead of a Dot "." Now the problem is SQL Server does not
recognize this and gives error. We can not do collation setting for numeric
fields also.
Any help on the same will be highly appreciated.
Regards
Rajib
SQL Server is not affected by regional settings. You have to give him dots
only.
There is no such thing like "collation setting for numeric fields".
Please read more about collations.
Bojidar Alexandrov
"Rajib Chatterjee" <rajibc@.hotmail.com> wrote in message
news:OpHbNuZXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> If we change the System settings to Swedish(Finland), the decimal space is
a
> Comma "," instead of a Dot "." Now the problem is SQL Server does not
> recognize this and gives error. We can not do collation setting for
numeric
> fields also.
> Any help on the same will be highly appreciated.
> Regards
> Rajib
>
>
|||SQL Server is not affected by regional settings. You have to give him dots
only.
There is no such thing like "collation setting for numeric fields".
Please read more about collations.
Bojidar Alexandrov
"Rajib Chatterjee" <rajibc@.hotmail.com> wrote in message
news:OpHbNuZXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> If we change the System settings to Swedish(Finland), the decimal space is
a
> Comma "," instead of a Dot "." Now the problem is SQL Server does not
> recognize this and gives error. We can not do collation setting for
numeric
> fields also.
> Any help on the same will be highly appreciated.
> Regards
> Rajib
>
>

"," (Comma) as Decimal Place - SQL SERVER 2000 /MSDE2000 does not work

change the System settings to Swedish(Finland), the decimal space is a Comma

Hi All,
If we change the System settings to Swedish(Finland), the decimal space is a Comma "," instead of a Dot "." Now the problem is SQL Server does not recognize this and gives error. We can not do collation setting for numeric fields also.
Any help on the same will be highly appreciated.
RegardsSQL Server is not affected by regional settings. You have to give him dots
only.
There is no such thing like "collation setting for numeric fields".
Please read more about collations.
Bojidar Alexandrov
"Rajib Chatterjee" <rajibc@.hotmail.com> wrote in message
news:OpHbNuZXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> If we change the System settings to Swedish(Finland), the decimal space is
a
> Comma "," instead of a Dot "." Now the problem is SQL Server does not
> recognize this and gives error. We can not do collation setting for
numeric
> fields also.
> Any help on the same will be highly appreciated.
> Regards
> Rajib
>
>
|||SQL Server is not affected by regional settings. You have to give him dots
only.
There is no such thing like "collation setting for numeric fields".
Please read more about collations.
Bojidar Alexandrov
"Rajib Chatterjee" <rajibc@.hotmail.com> wrote in message
news:OpHbNuZXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> If we change the System settings to Swedish(Finland), the decimal space is
a
> Comma "," instead of a Dot "." Now the problem is SQL Server does not
> recognize this and gives error. We can not do collation setting for
numeric
> fields also.
> Any help on the same will be highly appreciated.
> Regards
> Rajib
>
>

Hi. I have another problem. Anyone please?

Hi. I have another problem. Anyone please? Your answers will be greatly appreciated. My code is like this :
=iif(Fields!TDeact.Value = 0, "N/A",Fields!TDeactn.Value/Fields!TDeact.Value)
- this code is to eliminate the problem: "attempted to divide by zero";
however, it does not work. Still there's an error showing in my report, instead of the "N/A" i set in my code, it shows "#Error".
Anyone please, i have a deadline to meet for the realse of our project we're doing right now. Thanks.I think the issue is trying to have 2 separate data types to be displayed in
the same cell. You may try to change "N/A" to some other representation...
NaN etc...
"tulips_2812" wrote:
> Hi. I have another problem. Anyone please? Your answers will be greatly
> appreciated. My code is like this :
> =iif(Fields!TDeact.Value = 0, "N/A",
> Fields!TDeactn.Value/Fields!TDeact.Value)
> - this code is to eliminate the problem: "attempted to divide by zero";
> however, it does not work. Still there's an error showing in my report,
> instead of the "N/A" i set in my code, it shows "#Error".
> Anyone please, i have a deadline to meet for the realse of our project
> we're doing right now. Thanks.
>|||Try using 0, iif(deact.value = 0,0,deact.value)
--
U. Tokklas
"mike" wrote:
> I think the issue is trying to have 2 separate data types to be displayed in
> the same cell. You may try to change "N/A" to some other representation...
> NaN etc...
> "tulips_2812" wrote:
> > Hi. I have another problem. Anyone please? Your answers will be greatly
> > appreciated. My code is like this :
> >
> > =iif(Fields!TDeact.Value = 0, "N/A",
> > Fields!TDeactn.Value/Fields!TDeact.Value)
> >
> > - this code is to eliminate the problem: "attempted to divide by zero";
> > however, it does not work. Still there's an error showing in my report,
> > instead of the "N/A" i set in my code, it shows "#Error".
> >
> > Anyone please, i have a deadline to meet for the realse of our project
> > we're doing right now. Thanks.
> >
> >|||All parts of the IIF statement are evaluated, whether true or false.
You could write a code block to handle your problem. Search writing custom
code in the help.
=Code.Divide(Fields!TDeactn.Value,Fields!TDeact.Value)
Function Divide (byval nom as integer, byval denom as integer)
if denom > 0 then
return nom/denom
else
return "n/a"
end if
"Tokklas" wrote:
> Try using 0, iif(deact.value = 0,0,deact.value)
> --
> U. Tokklas
>
> "mike" wrote:
> > I think the issue is trying to have 2 separate data types to be displayed in
> > the same cell. You may try to change "N/A" to some other representation...
> > NaN etc...
> >
> > "tulips_2812" wrote:
> >
> > > Hi. I have another problem. Anyone please? Your answers will be greatly
> > > appreciated. My code is like this :
> > >
> > > =iif(Fields!TDeact.Value = 0, "N/A",
> > > Fields!TDeactn.Value/Fields!TDeact.Value)
> > >
> > > - this code is to eliminate the problem: "attempted to divide by zero";
> > > however, it does not work. Still there's an error showing in my report,
> > > instead of the "N/A" i set in my code, it shows "#Error".
> > >
> > > Anyone please, i have a deadline to meet for the realse of our project
> > > we're doing right now. Thanks.
> > >
> > >|||I wrote a piece of code:
Function DivideByZero(sValue1 as Object, sValue2 as Object)
If (sValue1 <> 0 AND sValue2 = 0) OR (sValue1 = 0 AND sValue2 <> 0) then
Return "NA"
Elseif sValue1 = 0 AND sValue2 = 0 then
Return "NA"
Else
Return (sValue1 - sValue2) / sValue2
End If
End Function
"tulips_2812" wrote:
> Hi. I have another problem. Anyone please? Your answers will be greatly
> appreciated. My code is like this :
> =iif(Fields!TDeact.Value = 0, "N/A",
> Fields!TDeactn.Value/Fields!TDeact.Value)
> - this code is to eliminate the problem: "attempted to divide by zero";
> however, it does not work. Still there's an error showing in my report,
> instead of the "N/A" i set in my code, it shows "#Error".
> Anyone please, i have a deadline to meet for the realse of our project
> we're doing right now. Thanks.
>|||Hello Harolds,
You're code was so fantastic. thank you very much. It really, really
helped..i just added End Function in the last part :)
Regards,
Althea|||I wrote a similar code. But I can not use this code in footer for calculate
sum.
Anyone solve this problem?
"Kerry" wrote:
> I wrote a piece of code:
> Function DivideByZero(sValue1 as Object, sValue2 as Object)
> If (sValue1 <> 0 AND sValue2 = 0) OR (sValue1 = 0 AND sValue2 <> 0) then
> Return "NA"
> Elseif sValue1 = 0 AND sValue2 = 0 then
> Return "NA"
> Else
> Return (sValue1 - sValue2) / sValue2
> End If
> End Function
> "tulips_2812" wrote:
> > Hi. I have another problem. Anyone please? Your answers will be greatly
> > appreciated. My code is like this :
> >
> > =iif(Fields!TDeact.Value = 0, "N/A",
> > Fields!TDeactn.Value/Fields!TDeact.Value)
> >
> > - this code is to eliminate the problem: "attempted to divide by zero";
> > however, it does not work. Still there's an error showing in my report,
> > instead of the "N/A" i set in my code, it shows "#Error".
> >
> > Anyone please, i have a deadline to meet for the realse of our project
> > we're doing right now. Thanks.
> >
> >|||Page header and footer have no access to the Fields collection.
You can have a textbox (may be hidden/invisible on a page and then aggregate
value of the textbox in page header/footer (Sum(ReportItems!mytextbox.Value)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Savage" <Savage@.discussions.microsoft.com> wrote in message
news:14E1E6DB-7F3A-41A0-B415-4598BB8DF480@.microsoft.com...
>I wrote a similar code. But I can not use this code in footer for calculate
> sum.
> Anyone solve this problem?
> "Kerry" wrote:
>> I wrote a piece of code:
>> Function DivideByZero(sValue1 as Object, sValue2 as Object)
>> If (sValue1 <> 0 AND sValue2 = 0) OR (sValue1 = 0 AND sValue2 <> 0)
>> then
>> Return "NA"
>> Elseif sValue1 = 0 AND sValue2 = 0 then
>> Return "NA"
>> Else
>> Return (sValue1 - sValue2) / sValue2
>> End If
>> End Function
>> "tulips_2812" wrote:
>> > Hi. I have another problem. Anyone please? Your answers will be greatly
>> > appreciated. My code is like this :
>> >
>> > =iif(Fields!TDeact.Value = 0, "N/A",
>> > Fields!TDeactn.Value/Fields!TDeact.Value)
>> >
>> > - this code is to eliminate the problem: "attempted to divide by zero";
>> > however, it does not work. Still there's an error showing in my report,
>> > instead of the "N/A" i set in my code, it shows "#Error".
>> >
>> > Anyone please, i have a deadline to meet for the realse of our project
>> > we're doing right now. Thanks.
>> >
>> >|||I was talking about Table footer.
"Alexandre Mineev MSFT" wrote:
> Page header and footer have no access to the Fields collection.
> You can have a textbox (may be hidden/invisible on a page and then aggregate
> value of the textbox in page header/footer (Sum(ReportItems!mytextbox.Value)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Savage" <Savage@.discussions.microsoft.com> wrote in message
> news:14E1E6DB-7F3A-41A0-B415-4598BB8DF480@.microsoft.com...
> >I wrote a similar code. But I can not use this code in footer for calculate
> > sum.
> > Anyone solve this problem?
> >
> > "Kerry" wrote:
> >
> >> I wrote a piece of code:
> >>
> >> Function DivideByZero(sValue1 as Object, sValue2 as Object)
> >>
> >> If (sValue1 <> 0 AND sValue2 = 0) OR (sValue1 = 0 AND sValue2 <> 0)
> >> then
> >> Return "NA"
> >> Elseif sValue1 = 0 AND sValue2 = 0 then
> >> Return "NA"
> >> Else
> >> Return (sValue1 - sValue2) / sValue2
> >> End If
> >> End Function
> >>
> >> "tulips_2812" wrote:
> >>
> >> > Hi. I have another problem. Anyone please? Your answers will be greatly
> >> > appreciated. My code is like this :
> >> >
> >> > =iif(Fields!TDeact.Value = 0, "N/A",
> >> > Fields!TDeactn.Value/Fields!TDeact.Value)
> >> >
> >> > - this code is to eliminate the problem: "attempted to divide by zero";
> >> > however, it does not work. Still there's an error showing in my report,
> >> > instead of the "N/A" i set in my code, it shows "#Error".
> >> >
> >> > Anyone please, i have a deadline to meet for the realse of our project
> >> > we're doing right now. Thanks.
> >> >
> >> >
>
>|||The function DivideByZero should be Public and you should call it as
=Code.DivideByZero(x,y)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Savage" <Savage@.discussions.microsoft.com> wrote in message
news:0EDDB40E-B10B-4D0C-9543-E4C07A984BB1@.microsoft.com...
>I was talking about Table footer.
>
> "Alexandre Mineev MSFT" wrote:
>> Page header and footer have no access to the Fields collection.
>> You can have a textbox (may be hidden/invisible on a page and then
>> aggregate
>> value of the textbox in page header/footer
>> (Sum(ReportItems!mytextbox.Value)
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Savage" <Savage@.discussions.microsoft.com> wrote in message
>> news:14E1E6DB-7F3A-41A0-B415-4598BB8DF480@.microsoft.com...
>> >I wrote a similar code. But I can not use this code in footer for
>> >calculate
>> > sum.
>> > Anyone solve this problem?
>> >
>> > "Kerry" wrote:
>> >
>> >> I wrote a piece of code:
>> >>
>> >> Function DivideByZero(sValue1 as Object, sValue2 as Object)
>> >>
>> >> If (sValue1 <> 0 AND sValue2 = 0) OR (sValue1 = 0 AND sValue2 <> 0)
>> >> then
>> >> Return "NA"
>> >> Elseif sValue1 = 0 AND sValue2 = 0 then
>> >> Return "NA"
>> >> Else
>> >> Return (sValue1 - sValue2) / sValue2
>> >> End If
>> >> End Function
>> >>
>> >> "tulips_2812" wrote:
>> >>
>> >> > Hi. I have another problem. Anyone please? Your answers will be
>> >> > greatly
>> >> > appreciated. My code is like this :
>> >> >
>> >> > =iif(Fields!TDeact.Value = 0, "N/A",
>> >> > Fields!TDeactn.Value/Fields!TDeact.Value)
>> >> >
>> >> > - this code is to eliminate the problem: "attempted to divide by
>> >> > zero";
>> >> > however, it does not work. Still there's an error showing in my
>> >> > report,
>> >> > instead of the "N/A" i set in my code, it shows "#Error".
>> >> >
>> >> > Anyone please, i have a deadline to meet for the realse of our
>> >> > project
>> >> > we're doing right now. Thanks.
>> >> >
>> >> >
>>

" the object invoked has disconnected from its clients"

I′m configuing a transacional replicationand after concluding it does not function, it is in the status initiating and later it gives the message: " the object invoked has disconnected from its clients"
Can you help me?
I have never heard of this error wrt replication.
The following article indicates it is a windows issue and the resolutions hopefully will help: http://www.kbalertz.com/Feedback_293631.aspx
Another poster upgraded his MDAC version to 2.8 and claims this solved his issue, although upgrading MDAC would not seem to be connected to the above article. Anyway, please let us know if you go down either route and how it works out.
Regards,
Paul Ibison

" TempDB" space error

I noticed the following error
Error 1101, Serverity: 17, State: 10
Could not allocate new page for database 'TEMPDB'. There
are no more pages available in filegroup Default. space
can be create by dorpping objects, adding additional file
or allowing file growth."
Now our " TempDB" is configured with auto filegrowth and
the drive has enogh free space (say more than 20G).
Current TempDB datafile 3G, logfile 1M ( ? is this problem)
Not sure why we got this error. Please help take a look.Thanks john,
I think that's the key. put log as 1M, even though 10%
increase each time, still could not catch up with
transaction.
I will put more. thanks.
Hansen
>--Original Message--
>Hansen
>If your tempdb is 1mb that is almost certainly your
>problem. Even with autogrow, with it starting that small,
>it just can not grow fast enough to keep up with the need
>for it.
>Try 300mb and see how it goes. There is no magic formula
>and depends on your processing, but usually 10% to 20% of
>the size of your largest database is about right. If it's
>not it may at least be able to grow fast enough from that
>start.
>Regards
>John
>.
>

Urgent Please Help - Conserving Page Real Estate

When the page header properties are set as 'PrintOnFirstPage' = False, so
that it doesn't show on the first page, it still seems to take up space on
the first page.
Is there a way to compress this space?
The pseudo report header that I created in the body (to show up only on page
1) is showing up about an inch lower than it really should when the report
renders. I am thinking that this is probably because the page header space
is still being consumed, even though it isn't literally being printed there.
Am I right? Is there a way to conserve that page real estate?
Thanks,
LisaThis is a bug. I don't know of any way to collapse out that space until we
get the bug fixed.
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
news:O4ZqFEFZEHA.4092@.TK2MSFTNGP11.phx.gbl...
> When the page header properties are set as 'PrintOnFirstPage' = False, so
> that it doesn't show on the first page, it still seems to take up space on
> the first page.
> Is there a way to compress this space?
> The pseudo report header that I created in the body (to show up only on
page
> 1) is showing up about an inch lower than it really should when the report
> renders. I am thinking that this is probably because the page header
space
> is still being consumed, even though it isn't literally being printed
there.
> Am I right? Is there a way to conserve that page real estate?
> Thanks,
> Lisa
>
>|||Thank you.
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:u9OQBqFZEHA.3476@.tk2msftngp13.phx.gbl...
> This is a bug. I don't know of any way to collapse out that space until
we
> get the bug fixed.
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
> news:O4ZqFEFZEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > When the page header properties are set as 'PrintOnFirstPage' = False,
so
> > that it doesn't show on the first page, it still seems to take up space
on
> > the first page.
> > Is there a way to compress this space?
> >
> > The pseudo report header that I created in the body (to show up only on
> page
> > 1) is showing up about an inch lower than it really should when the
report
> > renders. I am thinking that this is probably because the page header
> space
> > is still being consumed, even though it isn't literally being printed
> there.
> > Am I right? Is there a way to conserve that page real estate?
> >
> > Thanks,
> >
> > Lisa
> >
> >
> >
>

help! how to save user inputs from checkbox list to database?

Hi,

I'm new to ASP.NET 2.0. I'll like to ask how do one save user input from txtbox, radiobttnlist or checkboxlist into database?

Im implementing a suvrey form here by the way.

-any reference webs,

-any pointers from experts?

Thank you for your time in reading this email

Kayln

Hi,

here is an example:

Private Sub btnSubmit_Click(ByVal sender As Object, ByVal e As eventArgs) Handles btnSubmit.Click

SqlDataSource1.InsertParameters.Add("DataBase_Field_Name", System.TypeCode.String, CheckBoxList1.SelectedValue)

SqlDataSource1.Insert()

End Sub

Hope it helps,

Regards

--------------------------------

Please do not forget to mark as answered the correct answer. Thanks

|||

HiStoian Bucovich,

I do not understand your example. Do i implement it in the source code or do i attach it to what I already have if so where do i place it exactly?

Thnk you for your time

Kayln

|||

HiPrincessKitana,

in my example I am using separate file for code behind (it doesn't realy matter)

- in .aspx file you should have sqldatasource1 connecting you to your database table and allowing you to insert, delete, update and for sure your CheckBoxList1 with its items set by value="1" for example + a button (btnSubmit)

- in your code behind file .aspx.vb you should place the above code to handle after the checkbox was selected and button was clicked event all you have to configure is to set the proper DB column name ("DataBase_Field_Name") and the typecode that you will insert in this example I am showing String

Hope it helps

Regards

------------------------------

Please do not forget to mark as answered the correct answer. Thanks

|||

Dear Stoian,

lets go through this real slowly, cos Im still very green in this.

1) I have tocreate a database table say icecream flavor. so my options can are vanilla, chocolate or strawberry.

2) Ineed to place sqldatasource in my web form to retrieve this database.

3)Go on which my question ie which flavor do you like..then i have a checkboxlist with its datasource set to my sqldatasource.I do not understand "your CheckBoxList1 with its items set by value="1""

4)then I place a button , have it ID property: btnSubmit, Textbutton: Submit

5)then Idble click on the submit button to place an event handler, ie copy and paste below into my event handler?

********Private Sub btnSubmit_Click(ByVal sender As Object, ByVal e As eventArgs) Handles btnSubmit.Click

SqlDataSource1.InsertParameters.Add("DataBase_Field_Name", System.TypeCode.String, CheckBoxList1.SelectedValue)

SqlDataSource1.Insert()

End Sub***********

6) I do not understand ""all you have to configure is to set the proper DB column name ("DataBase_Field_Name") and the typecode that you will insert in this example I am showing String"

Distressed Kayln [:( ]

|||

Hi PrincessKitana,

First of all nice nick name, second I am sorry for my late replay, and third the answer:

- first you have to make your database lets name it "flavors" and create table in it lets say its name will be "icecreams" and this table must have the following entries:

1. ID data type "int" allow null "unchecked" set as primary key and autoincrement "yes"

2. Flavors data type "nvarchar(100)" allow null "checked"

Thats all for the data base

So long so good, next is to set the sqldatasource in your lets say Default.aspx file (just drag and drop the control named "SqlDataSource" and select your database and credentials etc. (p.s. if you need help about this please feel free to ask)

Then its time to make your CheckBoxList control and set its values:

<asp:CheckBoxListID="CheckBoxList1"runat="server">

<asp:ListItemSelected="true"Value="Vanilla">Vanilla</asp:ListItem>

<asp:ListItemValue="chocolate">chocolate</asp:ListItem>

<asp:ListItemValue="strawberry">strawberry</asp:ListItem>

</asp:CheckBoxList>

Then build your submit button

<asp:Button ID="btnSubmit" runat="server" Text="Submit" />

Its time to do some work in code behind (I am using VB in this example), double click the submit button in design view and you will see:

Private Sub bntSubmit_Click(ByVal sender As Object .........etc.

End Sub

Paste in it the code that I show you above and change only the field "DataBase_Field_Name" to "Flavors"

Thats it hope it helps

Regards

---------------------------

Please do not forget to mark as "Answer" the correct answer. Thanks

|||

Dear Stoian,

yes thank you for the compliment. anyway thanks to you, i managed to figure out your example but i have this problem that came up.

dun really know what it is??

SqlDataSource1.InsertParameters.Add("flavors", System.TypeCode.String, CheckBoxList1.SelectedValue)
{ SqlDataSource1.Insert() }------>>Inserting is not supported by data source 'SqlDataSource1' unless InsertCommand is specified.

CHeeRs,
Kayln

|||

Hi,

I guess you didn't checked Insert/Delete/Update field when you make your SqlDataSource connection any way, here is the complete code

- Default.aspx

<%@.PageLanguage="VB"AutoEventWireup="false"CodeFile="Default.aspx.vb"Inherits="_Default" %>

<!DOCTYPEhtmlPUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <htmlxmlns="http://www.w3.org/1999/xhtml">

<headrunat="server">

<title>Untitled Page</title>

</head>

<div>

<asp:SqlDataSourceID="SqlDataSource1"

runat="server"

ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

DeleteCommand="DELETE FROM [icecreams] WHERE [ID] = @.ID"

InsertCommand="INSERT INTO [icecreams] ([Flavors]) VALUES (@.Flavors)"

SelectCommand="SELECT * FROM [icecreams]"

UpdateCommand="UPDATE [icecreams] SET [Flavors] = @.Flavors WHERE [ID] = @.ID">

<asp:ParameterName="ID"Type="Int32"/> </DeleteParameters>

<asp:ParameterName="Flavors"Type="String"/>

<asp:ParameterName="ID"Type="Int32"/>

</UpdateParameters>

</asp:SqlDataSource>

<asp:CheckBoxListID="CheckBoxList1"runat="server">

<asp:ListItemSelected="true"Value="Vanilla">Vanilla</asp:ListItem>

<asp:ListItemValue="chocolate ">chocolate</asp:ListItem>

<asp:ListItemValue="strawberry">strawberry</asp:ListItem>

</asp:CheckBoxList>

<br/>

<asp:ButtonID="btnSubmit"runat="server"Text="Submit"/>

</div>

</form> </body>

</html>

- Default.aspx.vb code

PartialClass _Default

Inherits System.Web.UI.Page

PrivateSub btnSubmit_Click(ByVal senderAsObject,ByVal eAs EventArgs)Handles btnSubmit.ClickSqlDataSource1.InsertParameters.Add("Flavors", System.TypeCode.String, CheckBoxList1.SelectedValue)

SqlDataSource1.Insert()

EndSub

EndClass

- and web.config

<?xmlversion="1.0"?><!--

Note: As an alternative to hand editing this file you can use the

web admin tool to configure settings for your application. Use

the Website->Asp.Net Configuration option in Visual Studio.

A full list of settings and comments can be found in

machine.config.comments usually located in

\Windows\Microsoft.Net\Framework\v2.x\Config

-->

<addname="ConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\flavors.mdf;Integrated Security=True;User Instance=True"

providerName="System.Data.SqlClient" />

</connectionStrings>

<system.web>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

Visual Basic options:

Set strict="true" to disallow all data type conversions

where data loss can occur.

Set explicit="true" to force declaration of all variables.

-->

<compilationdebug="true"strict="false"explicit="true">

</compilation>

<pages>

<addnamespace="System"/>

<addnamespace="System.Collections"/>

<addnamespace="System.Collections.Generic"/>

<addnamespace="System.Collections.Specialized"/>

<addnamespace="System.Configuration"/>

<addnamespace="System.Text"/>

<addnamespace="System.Text.RegularExpressions"/>

<addnamespace="System.Web"/>

<addnamespace="System.Web.Caching"/>

<addnamespace="System.Web.SessionState"/>

<addnamespace="System.Web.Security"/>

<addnamespace="System.Web.Profile"/>

<addnamespace="System.Web.UI"/>

<addnamespace="System.Web.UI.WebControls"/>

<addnamespace="System.Web.UI.WebControls.WebParts"/>

<addnamespace="System.Web.UI.HtmlControls"/>

</namespaces> </pages>

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

--> <authenticationmode="Windows"/>

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

</customErrors>

--> </system.web>

</configuration>

All you have to do is to make the database as told you above :)

Hope it helps

Regards

Stoian

CDATA doesn't seem to be working

I have this bit of SQL
NULL as [license_Overflow!3!!cdata]
unioned to another query that populates it
cr.licenseOverflow
However my output doesn't include CDATA.
<resLicense>
<license_Overflow><P>I am in a P
tag</P></license_Overflow>
</resLicense>
Am I doing something wrong?john.wilker@.gmail.com wrote:
> I have this bit of SQL
> NULL as [license_Overflow!3!!cdata]
> unioned to another query that populates it
> cr.licenseOverflow
> However my output doesn't include CDATA.
> <resLicense>
> <license_Overflow><P>I am in a P
> tag</P></license_Overflow>
> </resLicense>
> Am I doing something wrong?
FAQ. See http://xml.silmaril.ie/authors/cdata/ and
the following question http://xml.silmaril.ie/authors/html/
///Peter|||Thanks Peter. I actually need cdata to handle markup from an older
system that allowed markup in fields.
Is there an option aside of making the XSL handle all the possible
markup tags we're likely to see. We have no control over what gets put
in, so it's be a royal pain to try to handle it all in XSL, no?
Shouldn't !!cdata do what I want? Or am I not understanding how it
works?|||FOR XML EXPLICIT is supposed to produce a CDATA section given a !cdata
directive.
However, if you use SQL Server 2005 and FOR XML produces XML type (has
"TYPE" directive) or assigned to XML-typed variable/parameter/column then it
is expected. XML data type does not preserve CDATA sections. If it's not
your case please post a repro.
Thanks,
Eugene
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<john.wilker@.gmail.com> wrote in message
news:1144970072.177577.118700@.e56g2000cwe.googlegroups.com...
>I have this bit of SQL
> NULL as [license_Overflow!3!!cdata]
> unioned to another query that populates it
> cr.licenseOverflow
> However my output doesn't include CDATA.
> <resLicense>
> <license_Overflow><P>I am in a P
> tag</P></license_Overflow>
> </resLicense>
> Am I doing something wrong?
>|||John wrote:
> Thanks Peter. I actually need cdata to handle markup from an older
> system that allowed markup in fields.
That can be a pain all right.

> Is there an option aside of making the XSL handle all the possible
> markup tags we're likely to see. We have no control over what gets put
> in, so it's be a royal pain to try to handle it all in XSL, no?
Once you have template matching everything *else*, add
<xsl:template match="*">
<xsl:copy>
<xsl:for-each select="@.*">
<xsl:copy-of select="."/>
</xsl:for-each>
<xsl:apply-templates/>
</xsl:copy>
</xsl:template>
This will recursively copy everything otherwise unmatched,
preserving both the element and attribute markup.

> Shouldn't !!cdata do what I want? Or am I not understanding how it
> works?
CDATA sections should be avoided unless *absolutely* necessary.
///Peter

! PLEASE HELP !! Collation selection on install

Hi, I need to change the collation when I install SQL Express 2005 to SQL_LATIN1_GENERAL_CP1_CI_AS but the drop down on setup only allows

LATIN1_GENERAL.

How do I get the correct collation to appear?

Thanks for any help/tips

hi,

as you can see in http://msdn2.microsoft.com/en-us/library/ms144250.aspx, SQL collations are for compatibility with older settings and are not directly listed (as you want them) in the installation wizard.... you can "only" choose a Windows collation, that lists all the variations of each particular collation, or SQL collation, that you have to "customize" to fit your needs.. so, for SQL_LATIN1_GENERAL_CP1_CI_AS you have to choose Dictionary order, case-insensitive, 1252 character set (or alternate locale to fit your needs)..

regards

|||Kool....thanks a million that did the trick ;-)

!

Dear all,

I was given a project to transfer our database into sql server database.

In our previous database we used the datatype int4 for some columns to create some views and in some queries that we used to build our datawindows. In SQLServer 2000 i created a user defined function named int4. I can execute it with the line select dbo.int4(poso) from employee .

Unfortrunately this way make me to rebuild all my datawindows and replace int4( with dbo.int4( . Is there any way to execute queries using user defined function but omitting the first part name dbo. I mean to manage execute the command select int4(poso) from employee \\let int4 be a user definded function.

If i create an ODBC function i must use select fn int4(poso) from employee

I thing i could solve this if i could create a system function int4() but i have no idea how it can be done.

If i can’t solve this, i thing it will decided than is impossible to move to sqlserver Database. Has anyone any suggestions?

Thanks in advance,

Best regards,

In SQL Server, you are not allowed to create a system functions. There is no other choice. You have to use the dbo.int4().

But I am not sure what you are doing inside this function. How important it is. If it is permanent for all the query call, better update the values on the main table itself (using update statement) & take care while inserting these values.

|||

No, you will have to use the owner /schema prefix for the new defined function.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Hellen, please do not multipost.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Firstly many thanks for your reply!!!

As i said, i want to create this function so as not to change at all the code of our programs. Inside the code we use select statements and we use in a lot of points int4(). It is necessary as i have functions that i use to my database and i want to have the optional to use sqlserver database without changing at all my code.

As you said it is not possible in Sql Server as i am not allowed to create system functions. Is it possible inSql Server 2005 or 2008 to create system functions?

Any ideas of how i could create an odbc function but include the function in a select statement without the fn prefix? Or should i abandon the idea of moving to a strong database?

|||

No, this is not possible as far as I know. You should consider trying to change the code logic to support this (strong9 syntax :-)

Jens K. Suessmeyer

http://www.sqlserver2005.de

Something seriously wrong

We have one database that is actually quite small, about 1.8GB. Upon moving
this db to SQL2K5 we get an error everytime we attempt to view the "Views"
folder. The error is:
Value cannot be null.
Parameter name: context (ObjectExplorer)
No more detail is available. I've gone back to the source database, removed
all views and repeated the process. Even with no views in the database we
get the same error when clicking on the "Views" folder in SQL Managment
Studio. All other db's have migrated fine.
NOW I figured I'd use the compare utility we have (We use Red Gates SQL
Compare) to compare the schema from that database to another server with an
old copy. This worked a few weeks ago, now it gives the error "Specified
cast is invalid" which sounds very likely to be related. This happens on
all servers running a copy of this database regardless of SQL Server
version. So at some point something bad was introduced. I'm just not sure
where to look, it sounds metadata related possibly but I'd hope there's some
other way of determining this other than going to a 6 week old backup and
hoping the issue isn't there.
Any help is greeted with humble thanks...we're really stuck.Tim,
Did you run the Upgrade Advisor on the DB before the move to 2005? This
might tell you something that does not migrate.
Chris Wood
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:uLgna8WaGHA.504@.TK2MSFTNGP03.phx.gbl...
> We have one database that is actually quite small, about 1.8GB. Upon
> moving this db to SQL2K5 we get an error everytime we attempt to view the
> "Views" folder. The error is:
> Value cannot be null.
> Parameter name: context (ObjectExplorer)
> No more detail is available. I've gone back to the source database,
> removed all views and repeated the process. Even with no views in the
> database we get the same error when clicking on the "Views" folder in SQL
> Managment Studio. All other db's have migrated fine.
> NOW I figured I'd use the compare utility we have (We use Red Gates SQL
> Compare) to compare the schema from that database to another server with
> an old copy. This worked a few weeks ago, now it gives the error
> "Specified cast is invalid" which sounds very likely to be related. This
> happens on all servers running a copy of this database regardless of SQL
> Server version. So at some point something bad was introduced. I'm just
> not sure where to look, it sounds metadata related possibly but I'd hope
> there's some other way of determining this other than going to a 6 week
> old backup and hoping the issue isn't there.
> Any help is greeted with humble thanks...we're really stuck.
>|||Yes I did. It only flagged a couple of sprocs with a syntax change (using
aliases in the order by clause)....
I might not have been clear. We encountered the issue during migration, BUT
then going back to our SQL 2000 servers currently in production this error
was encountered when using a specific tool. So, the issue is present BEFORE
migration.
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:eZTYegXaGHA.5004@.TK2MSFTNGP02.phx.gbl...
> Tim,
> Did you run the Upgrade Advisor on the DB before the move to 2005? This
> might tell you something that does not migrate.
> Chris Wood
> "Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
> news:uLgna8WaGHA.504@.TK2MSFTNGP03.phx.gbl...
>> We have one database that is actually quite small, about 1.8GB. Upon
>> moving this db to SQL2K5 we get an error everytime we attempt to view the
>> "Views" folder. The error is:
>> Value cannot be null.
>> Parameter name: context (ObjectExplorer)
>> No more detail is available. I've gone back to the source database,
>> removed all views and repeated the process. Even with no views in the
>> database we get the same error when clicking on the "Views" folder in SQL
>> Managment Studio. All other db's have migrated fine.
>> NOW I figured I'd use the compare utility we have (We use Red Gates SQL
>> Compare) to compare the schema from that database to another server with
>> an old copy. This worked a few weeks ago, now it gives the error
>> "Specified cast is invalid" which sounds very likely to be related. This
>> happens on all servers running a copy of this database regardless of SQL
>> Server version. So at some point something bad was introduced. I'm just
>> not sure where to look, it sounds metadata related possibly but I'd hope
>> there's some other way of determining this other than going to a 6 week
>> old backup and hoping the issue isn't there.
>> Any help is greeted with humble thanks...we're really stuck.
>

Reporting Services Error !

I have installed SQL Server Reporting Services and I recieve the following error when I attempt to call the reportserver from the URL.

"Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the 'Refresh' button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur. "

In the event log, the following error is recorded..."

"aspnet_wp.exe could not be started. The error code for the failure is 80004005. This error can be caused when the worker process account has insufficient rights to read the .NET Framework files. Please ensure that the .NET Framework is correctly installed and that the ACLs on the installation directory allow access to the configured account. "

I have ran "aspnet_regiis -i" after installing reporting services...
I have validated that ASPNET has the correct permissions...
I have validated that ASPNET user account has not been lockedout...
I have restarted the Report Server service...
I have restarted the IIS service...
I even have restarted the server...

Does anyone have any other ideas that may help! Thank you in advance.Try this url it is permissions related. Hope this helps.

http://support.microsoft.com/default.aspx?scid=kb;en-us;315158

Kind regards,
Gift Peddie|||My server is not a domain controller. The instructions on the link that you provided addresses the issue if it is a domain controller.

I did check my machine.config file and the <processModel> contains:

userName="machine"
password="AutoGenerate"

Why wouldn't this work for a non-domain controller server?|||Also, by the way, I have installed the .Net 1.1 hot fix|||I am sorry I did not ask you if you installed the Reporting Services and SQL Server with Service accounts because when SQL Server is installed in a Networked box is it good practice to use Service accounts so you will not get all the permissions related errors. Hope this helps.

Kind regards,
Gift Peddie|||I am using the domain service account. Would I need to change the machine.config file to different settings other than below?

userName="machine"
password="AutoGenerate"

Also, when I attempt to run rsactivate, I recieve the following error:
Failure parsing the config file.
Invalid URI: The host name could not be parsed.

The config file that it is referring to is the rsreportserver.config.|||Reporting Service applications are run through IIS so the username should be the Asp.net worker process account which is different from the service account used to install Reproting Service. You may also need to give Asp.net account full permissions to the Reporting application root folder. Hope this helps.

Kind regards,
Gift Peddie

HELP ! Disappearing objects

We are supposed to be deploying to SQL2K5 this friday night. I've been
taking backups from our SQL 2K server and restoring them directly on our 2K5
box. Everything seems to work ok except for one of our databases. When I
expand the "views" in Sql Management Studio object browser I get an error
that says "Parameter cannot be null" and none of the objects are there!!!
All other object types seem fine and only this database exhibits this
behavior. I'm not sure how to track this down.the error message is actually this
Value cannot be null.
Parameter name: context (ObjectExplorer)
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:%23QwU%23MMaGHA.4788@.TK2MSFTNGP02.phx.gbl...
> We are supposed to be deploying to SQL2K5 this friday night. I've been
> taking backups from our SQL 2K server and restoring them directly on our
> 2K5 box. Everything seems to work ok except for one of our databases.
> When I expand the "views" in Sql Management Studio object browser I get an
> error that says "Parameter cannot be null" and none of the objects are
> there!!! All other object types seem fine and only this database exhibits
> this behavior. I'm not sure how to track this down.
>|||One thing that I know doesn't work in 2005 is databases in a too low compatibility mode (60 and 65,
I believe). I'd think that SSMS would give a better error message, but worth looking into.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:%23dtxLQMaGHA.3304@.TK2MSFTNGP04.phx.gbl...
> the error message is actually this
> Value cannot be null.
> Parameter name: context (ObjectExplorer)
> "Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
> news:%23QwU%23MMaGHA.4788@.TK2MSFTNGP02.phx.gbl...
>> We are supposed to be deploying to SQL2K5 this friday night. I've been taking backups from our
>> SQL 2K server and restoring them directly on our 2K5 box. Everything seems to work ok except for
>> one of our databases. When I expand the "views" in Sql Management Studio object browser I get an
>> error that says "Parameter cannot be null" and none of the objects are there!!! All other object
>> types seem fine and only this database exhibits this behavior. I'm not sure how to track this
>> down.
>|||And what if you query sys.objects? Are the object listed in
the catalog view? Or in the information_schema.views view?
I've hit a few flaky things like that with SSMS. Usually
when I hit the bug with the index error in SSMS, I start
seeing other object display issues until I close SSMS and
reopen. I think some, most of those are fixed in SP1 for SQL
2005.
-Sue
On Tue, 25 Apr 2006 16:51:57 -0700, "Tim Greenwood"
<tim_greenwood A-T yahoo D-O-T com> wrote:
>We are supposed to be deploying to SQL2K5 this friday night. I've been
>taking backups from our SQL 2K server and restoring them directly on our 2K5
>box. Everything seems to work ok except for one of our databases. When I
>expand the "views" in Sql Management Studio object browser I get an error
>that says "Parameter cannot be null" and none of the objects are there!!!
>All other object types seem fine and only this database exhibits this
>behavior. I'm not sure how to track this down.
>

doesn't work in LIKE wildcards?

I have table of stocks that includes a varchar field that can optionally hold
a formula. You can identify formulas because the first character is "=". You
can also include the names of other stocks in the formula by surrounding the
ticker in !'s. For instance:
=!MSFT! * 2
I need to find all the formulas that do contain a ticker in them, so that I
can look up the stocks they refer to.
The obvious solution is ... WHERE formula LIKE '=%!'. The obvious solution
does not work. Removing the ! returns all the formulas. Anyone know what
would cause this? ! does not appear in the docs as a reserved word or
wildcard.
MauryHello Maury,
> I have table of stocks that includes a varchar field that can
> optionally hold a formula. You can identify formulas because the first
> character is "=". You can also include the names of other stocks in
> the formula by surrounding the ticker in !'s. For instance:
> =!MSFT! * 2
> I need to find all the formulas that do contain a ticker in them, so
> that I can look up the stocks they refer to.
> The obvious solution is ... WHERE formula LIKE '=%!'. The obvious
> solution does not work. Removing the ! returns all the formulas.
> Anyone know what would cause this? ! does not appear in the docs as a
> reserved word or wildcard.
> Maury
>
I think it's the fact that you didn't add a trailing %
where formula like %!%
Jesse Houwing
jesse.houwing at sogeti.n|||Ohh geez, nevermind!

using Inner join when the field in my data table has the Null default value:

I have a datatable : Data_Table and a look up table: Lk_table. Myfield that Iuse in Inner Join is defined in both thedata and look table.

So I build my query like this:

SELECT * FROM dbo. Data_Table INNER JOIN

dbo. Lk_table ON dbo.Data_Table.MyField = dbo.Lk_table.Myfield

The pb, sometimes Ihave myfield still with its default null value in the datatable: Data_Table.So, I end up getting 0 record when I execute the query shown above.

How do I turn that around so that even if myfield in Data_Tableis Null, I still get the records from Data_Table. (I don t want a set ofrecords including all possible values from the look up table: Lk_Table)

Try to use LEFT join instead of inner join:

SELECT * FROM dbo. Data_Table LEFT JOIN dbo. Lk_table
ON dbo.Data_Table.MyField = dbo.Lk_table.Myfield

|||

Try to use LEFT join instead of inner join:

SELECT * FROM dbo. Data_Table LEFT JOIN dbo. Lk_table
ON dbo.Data_Table.MyField = dbo.Lk_table.Myfield

Or use such query:

SELECT * FROM dbo. Data_Table ,dbo. Lk_table
WHERE dbo.Data_Table.MyField = dbo.Lk_table.Myfield

OR dbo.Data_Table.MyField is null

'' The definition of object [object name] has changed since it was compiled'' error when alt

Hello All

Not sure if this is the right forum to post this question to, so if it's not, please accept my apologies.

I'm working in SQL Server 2005 with a database that was migrated to 2005 from SQL Server 2000. I have to alter a trigger on a table for some functionality changes, and when I modify the trigger and then access it through the application the database is working with, I receive this error:

There was a error in the [stored procedure name] procedure. Error Number: -2147217900 Error Description: [Microsoft][ODBC SQL Server Driver][SQL Server]The definition of object '[trigger name]' has changed since it was compiled.

[stored procedure name] and [trigger name] are where the actual names appear in the message.

I've tried running sp_recompile on the trigger, stored procedure, and table that are associated with this, and nothing works. I have dropped the trigger, which allows the save process to complete (but doesn't perform the required functionality, of course), and then re-created the trigger, but the error message still comes up. The compatibility level for the database is SQL Server 2000 (80) (as it was migrated from SQL Server 2000 as I mentioned above).

Has anyone seen this, and if so, how can I fix it?

Thanks in advance for your help!

Jay

Try the Transact-SQL forum.

|||Is there a specific reason that you didn't move to compatibilty 9.0 after the upgrade. You can check and upgrade.

--check compatibility level
EXEC sp_dbcmptlevel '<DatabaseName>'--change compatibility level to 9.0
EXEC sp_dbcmptlevel '<DatabaseName>', '90'
I don't think, it is directly related to your issue though!
|||

Unfortunately, the database was upgraded before I joined the company, so I'm unsure as to the reason. I suspect they felt it would be better seeing the original database was on SQL Server 2000. I'll give this a try and see what happens. Thanks for the reply!

'' The definition of object [object name] has changed since it was compiled'' error when alt

Hello All

Not sure if this is the right forum to post this question to, so if it's not, please accept my apologies.

[stored procedure name] and [trigger name] are where the actual names appear in the message.

Has anyone seen this, and if so, how can I fix it?

Thanks in advance for your help!

Jay

Try the Transact-SQL forum.

|||Is there a specific reason that you didn't move to compatibilty 9.0 after the upgrade. You can check and upgrade.

'' The definition of object [object name] has changed since it was compiled'' error when alt

Hello All

Not sure if this is the right forum to post this question to, so if it's not, please accept my apologies.

[stored procedure name] and [trigger name] are where the actual names appear in the message.

Has anyone seen this, and if so, how can I fix it?

Thanks in advance for your help!

Jay

Try the Transact-SQL forum.

|||Is there a specific reason that you didn't move to compatibilty 9.0 after the upgrade. You can check and upgrade.

'' The definition of object [object name] has changed since it was compiled'' error when alt

Hello All

Not sure if this is the right forum to post this question to, so if it's not, please accept my apologies.

[stored procedure name] and [trigger name] are where the actual names appear in the message.

Has anyone seen this, and if so, how can I fix it?

Thanks in advance for your help!

Jay

Try the Transact-SQL forum.

|||Is there a specific reason that you didn't move to compatibilty 9.0 after the upgrade. You can check and upgrade.

SQL database- into-visual-table-construction

Hello,
First, thanks in advance for your time.
I would like to be able to turn my tables, already designed in SQL server,
into Entity-Relationship diagram so that i can visualize them. In other words
to get a ER model from my tables. Is there any tool that i can do this with?
- any other suggestions? -
thanks and best regards,
Siavash Solati
Sia_Canada wrote:
> Hello,
> First, thanks in advance for your time.
> I would like to be able to turn my tables, already designed in SQL
> server, into Entity-Relationship diagram so that i can visualize
> them. In other words to get a ER model from my tables. Is there any
> tool that i can do this with? - any other suggestions? -
> thanks and best regards,
> Siavash Solati
Most ER tools will reverse-engineer a database into a physical model,
including relationships if they're defined with primary and foreign
keys. Microsoft Visio will do this (in some editions). There are also a
slew of other tools that can do this as well: ERWin, System Architect
(if that's still around).
David Gugick
Imceda Software
www.imceda.com

rebuild master

hi,
is there a way to rebuild the master database in sql server 2005 without
installing SQL Server again. I try from the command line, but it sends me to
add/remove program, and from here there are is no option to do that.
in advance i'll appreciatte all your help.
Edmundo J. DavilaYou find instructions for how to rebuild in Books Online:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
More specifically:
start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
Above it from the BOL topic...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
> hi,
> is there a way to rebuild the master database in sql server 2005 without installing SQL Server
> again. I try from the command line, but it sends me to add/remove program, and from here there are
> is no option to do that.
> in advance i'll appreciatte all your help.
> Edmundo J. Davila|||Tibor,
That instruction send me to the add/remove programs, and as i said, there is
not option to rebuild master database from there.
Edmundo J. Davila
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió
en el mensaje de noticias
news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
> You find instructions for how to rebuild in Books Online:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
> More specifically:
> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName>
> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
> Above it from the BOL topic...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without
>> installing SQL Server again. I try from the command line, but it sends me
>> to add/remove program, and from here there are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>|||Are you running SQL Server Express? If so, why not just detach your user
databases, uninstall / reinstall, then re-attach your user databases?
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
> hi,
> is there a way to rebuild the master database in sql server 2005 without
> installing SQL Server again. I try from the command line, but it sends me
> to add/remove program, and from here there are is no option to do that.
> in advance i'll appreciatte all your help.
> Edmundo J. Davila|||Strange. I just tried the URL and it took me to the below topic:
How to: Install SQL Server 2005 from the Command Prompt
In there (towards the end) there's a sample on how to rebuild. Or are you saying that the START
command that I pasted (after adjustment) took you to add/Remove programs?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
> Tibor,
> That instruction send me to the add/remove programs, and as i said, there is not option to rebuild
> master database from there.
> Edmundo J. Davila
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió en el mensaje de
> noticias news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
>> REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without installing SQL Server
>> again. I try from the command line, but it sends me to add/remove program, and from here there
>> are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>|||How about this link?
How to: Install SQL Server 2005 from the Command Prompt:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
--
Ekrem Önsoy
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
> Tibor,
> That instruction send me to the add/remove programs, and as i said, there
> is not option to rebuild master database from there.
> Edmundo J. Davila
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> escribió en el mensaje de noticias
> news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName>
>> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without
>> installing SQL Server again. I try from the command line, but it sends
>> me to add/remove program, and from here there are is no option to do
>> that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>|||That is the same article as I posted, but I posted a local BOL URL...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
> How about this link?
> How to: Install SQL Server 2005 from the Command Prompt:
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
> --
> Ekrem Önsoy
>
> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said, there is not option to
>> rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió en el mensaje de
>> noticias news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
>> REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without installing SQL Server
>> again. I try from the command line, but it sends me to add/remove program, and from here there
>> are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>>
>|||Yes Tibor I know, I just thought this link could direct him to the mentioned
web site as the link you gave didn't work for him as far as I see.
--
Ekrem Önsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23fm8pD3JIHA.2064@.TK2MSFTNGP06.phx.gbl...
> That is the same article as I posted, but I posted a local BOL URL...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
>> How about this link?
>> How to: Install SQL Server 2005 from the Command Prompt:
>> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said,
>> there is not option to rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
>> escribió en el mensaje de noticias
>> news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName>
>> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005
>> without installing SQL Server again. I try from the command line, but
>> it sends me to add/remove program, and from here there are is no
>> option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>>
>|||OK, got it. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:5667FAAD-2499-41BF-AF08-6370F9453042@.microsoft.com...
> Yes Tibor I know, I just thought this link could direct him to the mentioned web site as the link
> you gave didn't work for him as far as I see.
> --
> Ekrem Önsoy
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23fm8pD3JIHA.2064@.TK2MSFTNGP06.phx.gbl...
>> That is the same article as I posted, but I posted a local BOL URL...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
>> news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
>> How about this link?
>> How to: Install SQL Server 2005 from the Command Prompt:
>> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said, there is not option to
>> rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió en el mensaje de
>> noticias news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
>> REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without installing SQL
>> Server again. I try from the command line, but it sends me to add/remove program, and from
>> here there are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>>
>>
>|||Unfortunatelly I had to remove and reinstall the instance from add/remove
programs from the control panel. It was impossible to do it with your
recommendations.
I appreciatte your help.
Regards,
Edmundo J. Davila
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió
en el mensaje de noticias news:eOZc3a3JIHA.2480@.TK2MSFTNGP05.phx.gbl...
> OK, got it. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:5667FAAD-2499-41BF-AF08-6370F9453042@.microsoft.com...
>> Yes Tibor I know, I just thought this link could direct him to the
>> mentioned web site as the link you gave didn't work for him as far as I
>> see.
>> --
>> Ekrem Önsoy
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:%23fm8pD3JIHA.2064@.TK2MSFTNGP06.phx.gbl...
>> That is the same article as I posted, but I posted a local BOL URL...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
>> news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
>> How about this link?
>> How to: Install SQL Server 2005 from the Command Prompt:
>> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said,
>> there is not option to rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
>> escribió en el mensaje de noticias
>> news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn
>> INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1
>> SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>>> hi,
>>> is there a way to rebuild the master database in sql server 2005
>>> without installing SQL Server again. I try from the command line,
>>> but it sends me to add/remove program, and from here there are is no
>>> option to do that.
>>>
>>> in advance i'll appreciatte all your help.
>>>
>>> Edmundo J. Davila
>>
>>
>>
>

' Question throwing exception

I have a comboBox with some names binded to it....With in the names some of them are like Store's Store, and like Danny's Gym...when i select names with ' in them i get this exception

Incorrect Syntax near 'S' Unclosed Question mark before the charectar string ORDER BY "SomeValue".....how could i go about fixing this?

should i include some king of function that pulls out those quotes? or what? any help with this issue

there are two properties of combobox that can be bound

selected value and the displaymember. you must bound selected value to the pk and use it

instead of the text with the quote problem

going back to the quote problem you might want to check this queries out

USE NORTHWIND
select 'that''s all folks' that's a double single quote
INSERT INTO CUSTOMERS(customerid,companyname, contactname)
values('SOXCL','THE SICK O''CLOCK', 'Jack O''donell')
select * from customers where companyname='THE SICK O''CLOCK'
delete from customers where customerid ='soxcl'

|||

You need to double up quotes in your strings, like changing:

'Danny's'

'Danny''s'

This is understood to be a single quote in the string. You should also figure some way to see the string being used for a query like this. If you saw the query:

select column from table where column like 'denny's' it would be obvious what the problem was.

Friday, January 27, 2012

"Attempt to repair any minor problems." What is the point?

"Application Log is Full"

"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access deni

"..Transform requires script Text and Language.." error?

"...remote name could not be resolved" when using custom Web App

"...could not load DCOM"

"," (Comma) as Decimal Place - SQL SERVER 2000 /MSDE2000 does not work

"," (Comma) as Decimal Place - SQL SERVER 2000 /MSDE2000 does not work

"," (Comma) as Decimal Place - SQL SERVER 2000 /MSDE2000 does not work

change the System settings to Swedish(Finland), the decimal space is a Comma

Hi. I have another problem. Anyone please?

" the object invoked has disconnected from its clients"

" TempDB" space error

Urgent Please Help - Conserving Page Real Estate

help! how to save user inputs from checkbox list to database?

CDATA doesn't seem to be working

! PLEASE HELP !! Collation selection on install

!

Something seriously wrong

Reporting Services Error !

HELP ! Disappearing objects

doesn't work in LIKE wildcards?

using Inner join when the field in my data table has the Null default value:

'' The definition of object [object name] has changed since it was compiled'' error when alt

'' The definition of object [object name] has changed since it was compiled'' error when alt

'' The definition of object [object name] has changed since it was compiled'' error when alt

'' The definition of object [object name] has changed since it was compiled'' error when alt

SQL database- into-visual-table-construction

rebuild master

rebuild master

' Question throwing exception

sql error

Blog Archive

About Me