Wednesday, March 28, 2012
I don't think the log reader is working
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...
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
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.