SQL About AMO: guys

Showing posts with label guys. Show all posts

Monday, March 19, 2012

Access 2000 connection failing to SQL Server2000

Hi guys,
I have an Access .adp project which is connecting to a SQL Server 2000 database. I am using Windows NT authentication.
When I open my access project I get an error message indicating that the stored procedure called from my start up form could not be executed. The problem is that the connection does not appear to have created.
In the main menu I click File and select Connection
The server is correctly selected in the drop down list on the pop up screen.
I click on 'Test Connection' and the I get a message indicating success. Now my project is connected and I can continue through the other forms and reports, executing stored procedures and getting records in my reports.
Any ideas on why the project is not connecting on start up, and why simply testing the connection appears to resolve the problem?
Has it something to do with DNS?First of what is the SP level on SQL server and what is the exact error message?

Access - SQL 2005

Hi Guys/Girls...
I'm using SQL 2005 integration services to copy data from an existing access
database. The access datbase contains a field, with the type of NTEXT. I am
trying to write the corresponding data to a table with a nvarchar(8000)
field.
I'm also trying to use the 'Data Conversion' data flow transformation,
however I am unsure what to convert the NTEXT to? I've tried a variety of
supported types, however I always seem to get an error stipulating that the
output stream stipulated does not support the NTEXT conversion.
Has anybody tried anything like this yet?
Thanks,
Justin> I'm using SQL 2005 integration services to copy data from an existing
> access database. The access datbase contains a field, with the type of
> NTEXT.
Access does not have a data type called NTEXT. This is gong to be MEMO in
Access, and I think Integration Services is telling you to use NTEXT in SQL
Server. I am going to suggest you use NVARCHAR(MAX) as the destination data
type.
A|||Hi Aaron,
I do not wish to import into a NTEXT field in my SQL2005 database, but would
prefer that Integration Services do the implicit conversion to a
Varchar(8000) using the 'Data Conversion' data flow transformation.
Thanks,
Justin
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:enxdpaq%23FHA.984@.tk2msftngp13.phx.gbl...
> Access does not have a data type called NTEXT. This is gong to be MEMO in
> Access, and I think Integration Services is telling you to use NTEXT in
> SQL Server. I am going to suggest you use NVARCHAR(MAX) as the
> destination data type.
> A
>

Sunday, March 11, 2012

abt Stored Procedure ...

hello guys ..

today i came with a Common question...

i am developing a website in that, I am using Stored procedure for all queries ( select, insert, update, delete )

is it good to run all queries in stored procedure ... or we should run only the SELECT queries by SP ... i need ur valuable suggestion ...

cheers ...i am waiting for some experienced person's answer ... is anybody here ??|||

Quote:

Originally Posted by rameshcse2005

i am waiting for some experienced person's answer ... is anybody here ??

hi,
You can use any sql statement inside your stored procedure...

According to me if you use stored procedures in your applications it will be good, if you need any database change just manipulate your sp, no need of rebuild or recompile your application.. all you need is organizing your application and stored procedures. better the design you have better the result you get|||You can use all the DML statments inside a procedure.|||Thank you very much for ur valuable suggestion ... :-)

and i have another doubt ?

how to pass multiple value in same parameter in SQL stored procedure ??

for example i have to write stored procedure for this query

DELETE FROM tableName where ID in (id1,id2,id3) ?|||You need to pass a refcursor to the procedure to dynamically pass any number of parameters for the IN operator..|||Thanks for ur suggestion ... i w'l try & let u know if any doubts ... :-)|||

Quote:

Originally Posted by rameshcse2005

Thanks for ur suggestion ... i w'l try & let u know if any doubts ... :-)

hi
you can do this as follows

send the id as a string seperated by ,(comma)

in your stored procedure use the following query

DELETE FROM tableName where ID in
( select id from tableName
where (','+isnull(@.parameter,convert(varchar(10),Id) )+',') like
('%,'+convert(varchar(20),Id)+ ',%')
)

In the above query if you pass null value to the @.Parameter then all the records will be deleted, if you send the id values seperated by coma then specific records only will be deleted

Thursday, March 8, 2012

Absolute Newbie Question

Hi guys! I'm a complete beginner of this and have just started learning scripting recently therefore I hope anyone here could give me some help.

Basically this is what I've done already, I have an ASP form here for user to fill in, then a confirm page (displaying the form data) is shown when the user's submitted the form.

Now, the next step I'd like to do is to store those data into a database (MS SQL Server 2000) when the user hits the confirm button in the confirm page. Since I've no experience of using SQL Server or doing anything like this before, can anyone please kindly tell me where to get started or where to find some good examples/tutorials?

Thanks very much in advance!Hai friend

Usw this tutorial this is helpfull for your asp mysql intgration

http://tutorials.programmingsite.co.uk/aspmysql.php

about writes/sec SQL server

Hi Guys,
Do you know how many writes/sec SQL server is capable of performing
generally? Trying to work out what % of a DB we would be consuming. ThanksProbably many more than you will even need. But it is usually not SQL
Server that is the bottle neck. It is mostly the hardware that will
determine how many writes per second you can do.
--
Andrew J. Kelly SQL MVP
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
> Hi Guys,
> Do you know how many writes/sec SQL server is capable of performing
> generally? Trying to work out what % of a DB we would be consuming. Thanks
>|||How many transactions the sql server can handle for a minutes. Thanks.
"Andrew J. Kelly" wrote:
> Probably many more than you will even need. But it is usually not SQL
> Server that is the bottle neck. It is mostly the hardware that will
> determine how many writes per second you can do.
> --
> Andrew J. Kelly SQL MVP
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
> > Hi Guys,
> > Do you know how many writes/sec SQL server is capable of performing
> > generally? Trying to work out what % of a DB we would be consuming. Thanks
> >
> >
>
>|||try to navigate to www.tpc.org: you'll find a lot of different answers.
The number of transactions/min depends on a lot of factrors:
- Hardware
- Infrastructure
- OS
- physical and logical design of the DB
- logical design and implementation of the transaction
- etc.
Usualy any RDBMS is implemented to give the most efficiency, but...
Gilberto
"Iter" wrote:
> How many transactions the sql server can handle for a minutes. Thanks.
>
> "Andrew J. Kelly" wrote:
> > Probably many more than you will even need. But it is usually not SQL
> > Server that is the bottle neck. It is mostly the hardware that will
> > determine how many writes per second you can do.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> > "Iter" <Iter@.discussions.microsoft.com> wrote in message
> > news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
> > > Hi Guys,
> > > Do you know how many writes/sec SQL server is capable of performing
> > > generally? Trying to work out what % of a DB we would be consuming. Thanks
> > >
> > >
> >
> >
> >|||Like I said it is mainly up to the hardware and how the application and
schema were developed. I have worked on SQL Servers that do over 60K
transactions per second. The TPC link that was given would be a good
resource but that does nothing to show how much your system will do.
--
Andrew J. Kelly SQL MVP
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:098E0931-DD8C-403F-8837-5091D21AE42A@.microsoft.com...
> How many transactions the sql server can handle for a minutes. Thanks.
>
> "Andrew J. Kelly" wrote:
>> Probably many more than you will even need. But it is usually not SQL
>> Server that is the bottle neck. It is mostly the hardware that will
>> determine how many writes per second you can do.
>> --
>> Andrew J. Kelly SQL MVP
>> "Iter" <Iter@.discussions.microsoft.com> wrote in message
>> news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
>> > Hi Guys,
>> > Do you know how many writes/sec SQL server is capable of performing
>> > generally? Trying to work out what % of a DB we would be consuming.
>> > Thanks
>> >
>> >
>>|||"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:098E0931-DD8C-403F-8837-5091D21AE42A@.microsoft.com...
> How many transactions the sql server can handle for a minutes. Thanks.
How big are your transactions?
Are you committing 5 bytes or 5 gigabytes?
How many disks do you have?
How fast are they?
Quite seriously, your question is really a bit open ended.
Note, even with the TPC benchmarks that Andrew pointed you towards, that's
really a matter of "how much money you want to spend."
With more money, MS could probably post even better numbers. But until
someone betters them enough, they won't bother.
>
> "Andrew J. Kelly" wrote:
>> Probably many more than you will even need. But it is usually not SQL
>> Server that is the bottle neck. It is mostly the hardware that will
>> determine how many writes per second you can do.
>> --
>> Andrew J. Kelly SQL MVP
>> "Iter" <Iter@.discussions.microsoft.com> wrote in message
>> news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
>> > Hi Guys,
>> > Do you know how many writes/sec SQL server is capable of performing
>> > generally? Trying to work out what % of a DB we would be consuming.
>> > Thanks
>> >
>> >
>>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Simple answer: enough for your needs - given sufficient hardware. :-) And
it doesn't take a kajillion dollars worth of hardware to get REALLY good
performance either!
--
TheSQLGuru
President
Indicium Resources, Inc.
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:098E0931-DD8C-403F-8837-5091D21AE42A@.microsoft.com...
> How many transactions the sql server can handle for a minutes. Thanks.
>
> "Andrew J. Kelly" wrote:
>> Probably many more than you will even need. But it is usually not SQL
>> Server that is the bottle neck. It is mostly the hardware that will
>> determine how many writes per second you can do.
>> --
>> Andrew J. Kelly SQL MVP
>> "Iter" <Iter@.discussions.microsoft.com> wrote in message
>> news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
>> > Hi Guys,
>> > Do you know how many writes/sec SQL server is capable of performing
>> > generally? Trying to work out what % of a DB we would be consuming.
>> > Thanks
>> >
>> >
>>

Tuesday, March 6, 2012

about transaction replication initialization

Hi Guys,
In transaction replication, before seting up the replication, do we need to
keep same copy for Publisher and Subscriber. That is mean do we need to
create all objects in Subscriber database which need to replicate from
Publisher in advance or I don't need to create and init snap shot will create
those objects in Subscriber. for example, if I want to replicate a table, do
I neet to create this table in Subscriber ahead? Or init snap shot agent
will do that. Thanks.
By default, there is no requirement to create anything on the subscriber. It
is sometimes beneficial to do a nosync initialization, in which case what
you are saying is pertinent, but this is usually because the snapshot files
are so large and/or the data already exists onthe subscriber so we take
advantage of it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Thank you very much. But I have other question is: I have test replication
environment, where it was worked fine. But after I delete one table in
subscriber, it causes error that the table in subscriber is not existed. why
it was not created again automately? Thanks.
"Paul Ibison" wrote:

> By default, there is no requirement to create anything on the subscriber. It
> is sometimes beneficial to do a nosync initialization, in which case what
> you are saying is pertinent, but this is usually because the snapshot files
> are so large and/or the data already exists onthe subscriber so we take
> advantage of it.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||It isn't really designed for you to be editing the subscriber's schema in
this way. To reinitialize this table, drop the subscription to the table
then drop the article. Add the article then add the subscription, start the
snapshot agent and it'll be sent over.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hello Iter,
Schemas are not maintained but rather are modified when the schema at the
publisher changes.
It is assumed schema changes will not be modified at the subscriber.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
[vbcol=seagreen]
> Thank you very much. But I have other question is: I have test
> replication environment, where it was worked fine. But after I delete
> one table in subscriber, it causes error that the table in subscriber
> is not existed. why it was not created again automately? Thanks.
> "Paul Ibison" wrote:
|||Thank you guys. If I want to modify the schemas in the publisher, e.g. add
new columns, how can I make changes in subscriber to make them identical?
Thanks
"Simon Sabin" wrote:

> Hello Iter,
> Schemas are not maintained but rather are modified when the schema at the
> publisher changes.
> It is assumed schema changes will not be modified at the subscriber.
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
>
>
|||It largely depends on what version of SQL Server you are currently using.
There is also a difference between altering a table's existing column and
adding or dropping columns. For the latter on SQL Server 2000 please take a
look at sp_repladdcolumn/sp_repldropcolumn. For SQL Server 2005 or changing
existing columns please take a look at these articles:
http://www.replicationanswers.com/AddColumn.asp
http://www.replicationanswers.com/AlterSchema2005.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

About trace flag 8588

Hi Guys,
I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
while the session is enlisted in a distributed transaction that has an active
savepoint. I setup two sql server 2000 in two windows 2003 server, both
install sql server sp1. I created linked server and setup MCDTC on both
server. When I run application that include distributed transaction, I got
error above. I re-check MCDTC, permission and so on, but I still got that
issue. Could some one help me to fix it? Thanks in advance.For more information about using trace flags and startup parameters, see the
"DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
Online.
To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Once you update the service pack your problem will get fixed. Please update
the same and lemme know if it works...
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"Iter" wrote:
> Hi Guys,
> I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
> while the session is enlisted in a distributed transaction that has an active
> savepoint. I setup two sql server 2000 in two windows 2003 server, both
> install sql server sp1. I created linked server and setup MCDTC on both
> server. When I run application that include distributed transaction, I got
> error above. I re-check MCDTC, permission and so on, but I still got that
> issue. Could some one help me to fix it? Thanks in advance.
>|||Thank you very much. But for my case, the server is windows 2003 and have
already installed service pack 1. Is there something else that I need to
install? Thanks.
"Sreejith G" wrote:
> For more information about using trace flags and startup parameters, see the
> "DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
> Online.
> To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
> Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
> Once you update the service pack your problem will get fixed. Please update
> the same and lemme know if it works...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
> "Iter" wrote:
> > Hi Guys,
> > I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
> > while the session is enlisted in a distributed transaction that has an active
> > savepoint. I setup two sql server 2000 in two windows 2003 server, both
> > install sql server sp1. I created linked server and setup MCDTC on both
> > server. When I run application that include distributed transaction, I got
> > error above. I re-check MCDTC, permission and so on, but I still got that
> > issue. Could some one help me to fix it? Thanks in advance.
> >

About trace flag 8588

Hi Guys,
I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
while the session is enlisted in a distributed transaction that has an activ
e
savepoint. I setup two sql server 2000 in two windows 2003 server, both
install sql server sp1. I created linked server and setup MCDTC on both
server. When I run application that include distributed transaction, I got
error above. I re-check MCDTC, permission and so on, but I still got that
issue. Could some one help me to fix it? Thanks in advance.For more information about using trace flags and startup parameters, see the
"DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
Online.
To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Once you update the service pack your problem will get fixed. Please update
the same and lemme know if it works...
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"Iter" wrote:

> Hi Guys,
> I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remot
e
> while the session is enlisted in a distributed transaction that has an act
ive
> savepoint. I setup two sql server 2000 in two windows 2003 server, both
> install sql server sp1. I created linked server and setup MCDTC on both
> server. When I run application that include distributed transaction, I got
> error above. I re-check MCDTC, permission and so on, but I still got that
> issue. Could some one help me to fix it? Thanks in advance.
>|||Thank you very much. But for my case, the server is windows 2003 and have
already installed service pack 1. Is there something else that I need to
install? Thanks.
"Sreejith G" wrote:
[vbcol=seagreen]
> For more information about using trace flags and startup parameters, see t
he
> "DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
> Online.
> To use trace flag 8599, obtain the latest service pack for SQL Server 2000
:
> Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
> Once you update the service pack your problem will get fixed. Please updat
e
> the same and lemme know if it works...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread an
d time
> asking back if its 2000 or 2005]
>
> "Iter" wrote:
>

About Trace Flag 1204 report

Hi Guys,
I want to ask a simple question,where can I get Trace Flag 1204 report, from
event view or somewhere else? ThanksYou find it in the SQL Server errorlog file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:F495BD05-8568-4F87-8994-5F26892359D9@.microsoft.com...
> Hi Guys,
> I want to ask a simple question,where can I get Trace Flag 1204 report, fr
om
> event view or somewhere else? Thanks

About Trace Flag 1204 report

Hi Guys,
I want to ask a simple question,where can I get Trace Flag 1204 report, from
event view or somewhere else? ThanksYou find it in the SQL Server errorlog file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:F495BD05-8568-4F87-8994-5F26892359D9@.microsoft.com...
> Hi Guys,
> I want to ask a simple question,where can I get Trace Flag 1204 report, from
> event view or somewhere else? Thanks

Saturday, February 25, 2012

about tempdb

Guys,
I have question regarding tempdb. I have several dbs in my server and size
is totally 22G. I checked the tempdb, it is roughly 6G, is it normal? In
addition, for replication, where can I find snapshot agent folder? because I
want to change the folder, how can I do that? Thanks.Hello,
Tempdb - 6GB
This is normal. If you have temporary operations like ORDER BY, GROUP BY or
Temporary table creation then it is usual that TEMPDB will grow.
But I recommend you to size the tempdb based on your requirement; Autogrowth
on tempdb will cause more resource utilization.
I have not moved a snapshot folder and hence I can not comment on this
Thanks
Hari
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:1C90F76D-7C73-4866-9E30-CB9110182D93@.microsoft.com...
> Guys,
> I have question regarding tempdb. I have several dbs in my server and size
> is totally 22G. I checked the tempdb, it is roughly 6G, is it normal? In
> addition, for replication, where can I find snapshot agent folder? because
> I
> want to change the folder, how can I do that? Thanks.
>

about tempdb

Guys,
I have question regarding tempdb. I have several dbs in my server and size
is totally 22G. I checked the tempdb, it is roughly 6G, is it normal? In
addition, for replication, where can I find snapshot agent folder? because I
want to change the folder, how can I do that? Thanks.
Hello,
Tempdb - 6GB
This is normal. If you have temporary operations like ORDER BY, GROUP BY or
Temporary table creation then it is usual that TEMPDB will grow.
But I recommend you to size the tempdb based on your requirement; Autogrowth
on tempdb will cause more resource utilization.
I have not moved a snapshot folder and hence I can not comment on this
Thanks
Hari
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:1C90F76D-7C73-4866-9E30-CB9110182D93@.microsoft.com...
> Guys,
> I have question regarding tempdb. I have several dbs in my server and size
> is totally 22G. I checked the tempdb, it is roughly 6G, is it normal? In
> addition, for replication, where can I find snapshot agent folder? because
> I
> want to change the folder, how can I do that? Thanks.
>

About sys.fn_indexinfo in SQL2005 MOC 2733A

Hi guys,
i reading the MOC 2733A for SQL2005 and found the "sys.fn_indexinfo"
function in a module 5 but when i run a sys.fn_indexinfo how indicated a
error showed
Seems that not exist ... it's possible ? It was replaced ?
If so how i can view a index defrag status ?
Thanks in advance.You might have an version of the course that was based on a beta of the product. My guess is that
the function you want is sys.dm_db_index_physical_stats.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<io.com@.newsgroup.nospam> wrote in message news:O6mSA$DzGHA.3908@.TK2MSFTNGP05.phx.gbl...
> Hi guys,
> i reading the MOC 2733A for SQL2005 and found the "sys.fn_indexinfo" function in a module 5 but
> when i run a sys.fn_indexinfo how indicated a error showed
> Seems that not exist ... it's possible ? It was replaced ?
> If so how i can view a index defrag status ?
> Thanks in advance.
>|||Yes it's right.
Found!
bye.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGPTSCEzGHA.4972@.TK2MSFTNGP03.phx.gbl...
> You might have an version of the course that was based on a beta of the
> product. My guess is that the function you want is
> sys.dm_db_index_physical_stats.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <io.com@.newsgroup.nospam> wrote in message
> news:O6mSA$DzGHA.3908@.TK2MSFTNGP05.phx.gbl...
>> Hi guys,
>> i reading the MOC 2733A for SQL2005 and found the "sys.fn_indexinfo"
>> function in a module 5 but when i run a sys.fn_indexinfo how indicated a
>> error showed
>> Seems that not exist ... it's possible ? It was replaced ?
>> If so how i can view a index defrag status ?
>> Thanks in advance.
>>
>|||Hi IO,
So far as I know, number of information in MOC 2733 is changed since it is
based on SQL 2005 beta. If you have any other questions, feel free to post
in our newsgroup. We are glad to provide assistance.
Have a good day!
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>From: <io.com@.newsgroup.nospam>
>>References: <O6mSA$DzGHA.3908@.TK2MSFTNGP05.phx.gbl>
<uGPTSCEzGHA.4972@.TK2MSFTNGP03.phx.gbl>
>>Subject: Re: About sys.fn_indexinfo in SQL2005 MOC 2733A
>>Date: Wed, 30 Aug 2006 16:50:21 +0200
>>Lines: 36
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-RFC2646: Format=Flowed; Response
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
>>Message-ID: <#09RgOEzGHA.1536@.TK2MSFTNGP02.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 62.241.4.149
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP02.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:443733
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Yes it's right.
>>Found!
>>bye.
>>"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
>>message news:uGPTSCEzGHA.4972@.TK2MSFTNGP03.phx.gbl...
>> You might have an version of the course that was based on a beta of the
>> product. My guess is that the function you want is
>> sys.dm_db_index_physical_stats.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> <io.com@.newsgroup.nospam> wrote in message
>> news:O6mSA$DzGHA.3908@.TK2MSFTNGP05.phx.gbl...
>> Hi guys,
>> i reading the MOC 2733A for SQL2005 and found the "sys.fn_indexinfo"
>> function in a module 5 but when i run a sys.fn_indexinfo how indicated
a
>> error showed
>> Seems that not exist ... it's possible ? It was replaced ?
>> If so how i can view a index defrag status ?
>> Thanks in advance.
>>
>>
>>

Monday, March 19, 2012

Access 2000 connection failing to SQL Server2000

Access - SQL 2005

Sunday, March 11, 2012

abt Stored Procedure ...

Thursday, March 8, 2012

Absolute Newbie Question

about writes/sec SQL server

about writes/sec SQL server

about writes/sec SQL server

Tuesday, March 6, 2012

about transaction replication initialization

About trace flag 8588

About trace flag 8588

About Trace Flag 1204 report

About Trace Flag 1204 report

Saturday, February 25, 2012

about tempdb

about tempdb

About sys.fn_indexinfo in SQL2005 MOC 2733A

About sys.fn_indexinfo in SQL2005 MOC 2733A

About SQL2005 and SQL Agent icon

About SQL2000 memory usage

SQL About AMO

Blog Archive

About Me