Showing posts with label available. Show all posts
Showing posts with label available. Show all posts

Wednesday, March 28, 2012

I don't think the log reader is working

Simply says that there are no transactions available. But when I go to my
production app and add some things it still says the same thing.
--K
please contact me offline on this one.
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
"Kristy" <pleasepostreply@.here.com> wrote in message
news:e5gCnBRMFHA.3928@.TK2MSFTNGP09.phx.gbl...
> Simply says that there are no transactions available. But when I go to my
> production app and add some things it still says the same thing.
> --K
>
|||Okay, I sent an email to your account. Thank you.
--Kristy
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23hsrl5SMFHA.1308@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> please contact me offline on this one.
> --
> 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
> "Kristy" <pleasepostreply@.here.com> wrote in message
> news:e5gCnBRMFHA.3928@.TK2MSFTNGP09.phx.gbl...
my
>
|||I haven't got it yet, please resend - you can also try hilaryk @. att.net
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
"Kristy" <pleasepostreply@.here.com> wrote in message
news:ec9gRFUMFHA.1948@.TK2MSFTNGP14.phx.gbl...
> Okay, I sent an email to your account. Thank you.
> --Kristy
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23hsrl5SMFHA.1308@.tk2msftngp13.phx.gbl...
> my
>
sql

I don't remember...

Dear folks,
Could you please so kind to tell me where the fixed type data stored are? I
mean, in what system table are available these data?
"bigint, binary, float, decimal", and so on
Thanks in advance and regards,
Enricsystypes
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:0FEAE3E6-C6D8-400E-B210-F999DEBE6D17@.microsoft.com...
> Dear folks,
> Could you please so kind to tell me where the fixed type data stored are?
I
> mean, in what system table are available these data?
> "bigint, binary, float, decimal", and so on
> Thanks in advance and regards,
> Enric|||thanx
"Tibor Karaszi" wrote:

> systypes
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:0FEAE3E6-C6D8-400E-B210-F999DEBE6D17@.microsoft.com...
>
>

Friday, March 23, 2012

I cant get the xml data type

I have just installed SQL server 2005 - Developer edition and the problem i get is: i dont have xml datatype available to me. I was able to use the xml datatye as long as i was using SQL server Express edition on a different machine. Please note that i have also applies SQL server 2005 SP-1 aswell but found no change in the datatypes available. I need urgent help in this regard.

During the installation i didnot install the reporting services as i did not need them.Has it something to do with it?XML datatype is avaiable for all SQL Server 2005 variation and service packs. Can you be more specific about "i dont have xml datatype available to me" ?|||

Well I meant that when i create a new table through design or query and type xml it generates and error message that xml datatyope is not defined. And here are the configuration of my machine:

OS: Windows XP - SP2

Hardware check: Intel Pentium 3 GHz processor 1 GB DDR RAM

I installed SQL server 2000 first and then SQL server 2005 dev. edition.

|||

Are you sure that you run the script against your SQL Server 2005 instance and not the SQL Server 2000 instance? What do you get if you say

select @.@.version

?

Thanks

Michael

Monday, March 19, 2012

I cannot debug inside VS 2005 Developer Edition

Two questions...

1. I saw that you must have the Professional Edition and above to debug stored procedures. Is this available in the Developer Edition.

2. If #1 is okay, why do i not have the menu item, "Step Into Procedure" or whatever it's called?

Thank you,


Brian

What i installed was SQL Server 2005 Developer Edition, it came with a MSDN Professional Subscription. So i have the Professional Edition but i do not have the "Step Into Procedure" menu item when right-clicking a stored procedure within the Server Explorer? Maybe noteworthy here is that i did not install any of the languages, does that make a difference?

When i view debug options for Just-In-Time, i see a warning stating, "Another debugger has registered itself as the Just-In-Time debugger. To repair, enable Just-In-Time debugging or run Visual Studio repair." Could this be the reason for not having the ability to debug stored procedures?

Thanks,

Brian

|||

That means a problem with the current that doesn't have the Administrator privileges, check that out.

http://msdn2.microsoft.com/en-us/library/5hs4b7a6(VS.80).aspx fyi.