General network error. Check your network documentation.

Hi ,
I am getting following error . Can anyone help me on this ?
General network error. Check your network documentation.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlInternalConnection.Execut eTransaction(String
sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.BeginTransacti on(IsolationLevel iso)
at System.Data.SqlClient.SqlConnection.BeginTransacti on()
I would appreicate if anyone can help me on this ?
Jitesh k
Hi,
Are you using Windows Server 2003 on SQL?
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
> Hi ,
> I am getting following error . Can anyone help me on this ?
> General network error. Check your network documentation.
> at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
> TdsParserState state)
> at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
> exception, TdsParserState state)
> at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
> cmdHandler, SqlDataReader dataStream)
> at System.Data.SqlClient.SqlInternalConnection.Execut eTransaction(String
> sqlBatch, String method)
> at System.Data.SqlClient.SqlConnection.BeginTransacti on(IsolationLevel
> iso)
> at System.Data.SqlClient.SqlConnection.BeginTransacti on()
> I would appreicate if anyone can help me on this ?
> --
> Jitesh k
>
|||Hi Danijel,
O/s is windows 2000
and SQL server 2000 with sp3a
Jitesh k
"Danijel Novak" wrote:

> Hi,
> Are you using Windows Server 2003 on SQL?
> --
> Danijel Novak
>
> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
> news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
>
>
|||Hi,
I found this solution:
I have set the CommandTimeOut of my command object and I have added
Pooling=False in my connection string.
Hope it helps..
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:CD016A68-EFA0-42CF-9B08-B730C8FBDB36@.microsoft.com...[vbcol=seagreen]
> Hi Danijel,
> O/s is windows 2000
> and SQL server 2000 with sp3a
> --
> Jitesh k
>
> "Danijel Novak" wrote:
|||what does pooling=False does ?
will it degrade performance ?
Jitesh k
"Danijel Novak" wrote:

> Hi,
> I found this solution:
> I have set the CommandTimeOut of my command object and I have added
> Pooling=False in my connection string.
> Hope it helps..
> --
> Danijel Novak
>
> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
> news:CD016A68-EFA0-42CF-9B08-B730C8FBDB36@.microsoft.com...
>
>
|||Hi,
Pooling=false means that connection you're establishing is not pooled in
connection pool.
Yes, it could influence your performance as connection must be created again
and it is not drawn from pool.
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:BF4B56AE-5A61-4E95-92A1-090EA88B8A85@.microsoft.com...[vbcol=seagreen]
> what does pooling=False does ?
> will it degrade performance ?
> --
> Jitesh k
>
> "Danijel Novak" wrote:

General network error. Check your network documentation.

Hi ,
I am getting following error . Can anyone help me on this ?
General network error. Check your network documentation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso)
at System.Data.SqlClient.SqlConnection.BeginTransaction()
I would appreicate if anyone can help me on this ?
--
Jitesh kHi,
Are you using Windows Server 2003 on SQL?
--
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
> Hi ,
> I am getting following error . Can anyone help me on this ?
> General network error. Check your network documentation.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> TdsParserState state)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, TdsParserState state)
> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
> cmdHandler, SqlDataReader dataStream)
> at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
> sqlBatch, String method)
> at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
> iso)
> at System.Data.SqlClient.SqlConnection.BeginTransaction()
> I would appreicate if anyone can help me on this ?
> --
> Jitesh k
>|||Hi Danijel,
O/s is windows 2000
and SQL server 2000 with sp3a
--
Jitesh k
"Danijel Novak" wrote:
> Hi,
> Are you using Windows Server 2003 on SQL?
> --
> Danijel Novak
>
> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
> news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
> > Hi ,
> >
> > I am getting following error . Can anyone help me on this ?
> > General network error. Check your network documentation.
> > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> > TdsParserState state)
> > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > exception, TdsParserState state)
> > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> > at System.Data.SqlClient.TdsParser.ReadBuffer()
> > at System.Data.SqlClient.TdsParser.ReadByte()
> > at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
> > cmdHandler, SqlDataReader dataStream)
> > at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
> > sqlBatch, String method)
> > at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
> > iso)
> > at System.Data.SqlClient.SqlConnection.BeginTransaction()
> >
> > I would appreicate if anyone can help me on this ?
> > --
> > Jitesh k
> >
>
>|||Hi,
I found this solution:
I have set the CommandTimeOut of my command object and I have added
Pooling=False in my connection string.
Hope it helps..
--
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:CD016A68-EFA0-42CF-9B08-B730C8FBDB36@.microsoft.com...
> Hi Danijel,
> O/s is windows 2000
> and SQL server 2000 with sp3a
> --
> Jitesh k
>
> "Danijel Novak" wrote:
>> Hi,
>> Are you using Windows Server 2003 on SQL?
>> --
>> Danijel Novak
>>
>> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
>> news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
>> > Hi ,
>> >
>> > I am getting following error . Can anyone help me on this ?
>> > General network error. Check your network documentation.
>> > at System.Data.SqlClient.SqlConnection.OnError(SqlException
>> > exception,
>> > TdsParserState state)
>> > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
>> > exception, TdsParserState state)
>> > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
>> > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
>> > at System.Data.SqlClient.TdsParser.ReadBuffer()
>> > at System.Data.SqlClient.TdsParser.ReadByte()
>> > at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
>> > cmdHandler, SqlDataReader dataStream)
>> > at
>> > System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
>> > sqlBatch, String method)
>> > at
>> > System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
>> > iso)
>> > at System.Data.SqlClient.SqlConnection.BeginTransaction()
>> >
>> > I would appreicate if anyone can help me on this ?
>> > --
>> > Jitesh k
>> >
>>|||what does pooling=False does ?
will it degrade performance ?
--
Jitesh k
"Danijel Novak" wrote:
> Hi,
> I found this solution:
> I have set the CommandTimeOut of my command object and I have added
> Pooling=False in my connection string.
> Hope it helps..
> --
> Danijel Novak
>
> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
> news:CD016A68-EFA0-42CF-9B08-B730C8FBDB36@.microsoft.com...
> > Hi Danijel,
> > O/s is windows 2000
> > and SQL server 2000 with sp3a
> >
> > --
> > Jitesh k
> >
> >
> >
> > "Danijel Novak" wrote:
> >
> >> Hi,
> >>
> >> Are you using Windows Server 2003 on SQL?
> >>
> >> --
> >> Danijel Novak
> >>
> >>
> >>
> >> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
> >> news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
> >> > Hi ,
> >> >
> >> > I am getting following error . Can anyone help me on this ?
> >> > General network error. Check your network documentation.
> >> > at System.Data.SqlClient.SqlConnection.OnError(SqlException
> >> > exception,
> >> > TdsParserState state)
> >> > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> >> > exception, TdsParserState state)
> >> > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> >> > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> >> > at System.Data.SqlClient.TdsParser.ReadBuffer()
> >> > at System.Data.SqlClient.TdsParser.ReadByte()
> >> > at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
> >> > cmdHandler, SqlDataReader dataStream)
> >> > at
> >> > System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
> >> > sqlBatch, String method)
> >> > at
> >> > System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
> >> > iso)
> >> > at System.Data.SqlClient.SqlConnection.BeginTransaction()
> >> >
> >> > I would appreicate if anyone can help me on this ?
> >> > --
> >> > Jitesh k
> >> >
> >>
> >>
> >>
>
>|||Hi,
Pooling=false means that connection you're establishing is not pooled in
connection pool.
Yes, it could influence your performance as connection must be created again
and it is not drawn from pool.
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:BF4B56AE-5A61-4E95-92A1-090EA88B8A85@.microsoft.com...
> what does pooling=False does ?
> will it degrade performance ?
> --
> Jitesh k
>
> "Danijel Novak" wrote:
>> Hi,
>> I found this solution:
>> I have set the CommandTimeOut of my command object and I have added
>> Pooling=False in my connection string.
>> Hope it helps..
>> --
>> Danijel Novak
>>
>> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
>> news:CD016A68-EFA0-42CF-9B08-B730C8FBDB36@.microsoft.com...
>> > Hi Danijel,
>> > O/s is windows 2000
>> > and SQL server 2000 with sp3a
>> >
>> > --
>> > Jitesh k
>> >
>> >
>> >
>> > "Danijel Novak" wrote:
>> >
>> >> Hi,
>> >>
>> >> Are you using Windows Server 2003 on SQL?
>> >>
>> >> --
>> >> Danijel Novak
>> >>
>> >>
>> >>
>> >> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
>> >> news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
>> >> > Hi ,
>> >> >
>> >> > I am getting following error . Can anyone help me on this ?
>> >> > General network error. Check your network documentation.
>> >> > at System.Data.SqlClient.SqlConnection.OnError(SqlException
>> >> > exception,
>> >> > TdsParserState state)
>> >> > at
>> >> > System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
>> >> > exception, TdsParserState state)
>> >> > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
>> >> > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
>> >> > at System.Data.SqlClient.TdsParser.ReadBuffer()
>> >> > at System.Data.SqlClient.TdsParser.ReadByte()
>> >> > at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
>> >> > cmdHandler, SqlDataReader dataStream)
>> >> > at
>> >> > System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
>> >> > sqlBatch, String method)
>> >> > at
>> >> > System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
>> >> > iso)
>> >> > at System.Data.SqlClient.SqlConnection.BeginTransaction()
>> >> >
>> >> > I would appreicate if anyone can help me on this ?
>> >> > --
>> >> > Jitesh k
>> >> >
>> >>
>> >>
>> >>
>>

General network error when you try to back up or restore a SQL Server 2000 on Windows 2000

I am receiving General network error when I try to back up a SQL Server
database on a computer that is running Windows Server 2000
I receive Following error when running DB maintenance job:
[2] Database master: Database Backup...
Destination: [\\LGA01\SysDbBackup_01\master_db_200503311443.BAK ]
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft][ODBC SQL
Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]General network error. Check
your network documentation.
[Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages for
database 'master', file 'mastlog' on file 1.
[3] Database model: Database Backup...
Destination: [\\LGA01\SysDbBackup_01\model_db_200503311443.B AK]
Please Help
Hi
Maintenance plans do not support UNC paths. You need to use T-SQL to do
that.
At the same time, check that the account that the SQL Service is running
under has permissions on the destination directory.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rafet Ducic" <rducic@.hotmail.com> wrote in message
news:OZbJL6iNFHA.164@.TK2MSFTNGP12.phx.gbl...
>I am receiving General network error when I try to back up a SQL Server
> database on a computer that is running Windows Server 2000
> I receive Following error when running DB maintenance job:
> [2] Database master: Database Backup...
> Destination: [\\LGA01\SysDbBackup_01\master_db_200503311443.BAK ]
> [Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft][ODBC
> SQL
> Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
> [Microsoft][ODBC SQL Server Driver][Named Pipes]General network error.
> Check
> your network documentation.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages for
> database 'master', file 'mastlog' on file 1.
> [3] Database model: Database Backup...
> Destination: [\\LGA01\SysDbBackup_01\model_db_200503311443.B AK]
> Please Help
>

General network error when you try to back up or restore a SQL Server 2000 on Windows

I am receiving General network error when I try to back up a SQL Server
database on a computer that is running Windows Server 2000
I receive Following error when running DB maintenance job:
[2] Database master: Database Backup...
Destination: & #91;\\LGA01\SysDbBackup_01\master_db_200
503311443.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft]&#
91;ODBC SQL
Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]General network
error. Check
your network documentation.
[Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages
for
database 'master', file 'mastlog' on file 1.
[3] Database model: Database Backup...
Destination: & #91;\\LGA01\SysDbBackup_01\model_db_2005
03311443.BAK]
Please HelpHi
Maintenance plans do not support UNC paths. You need to use T-SQL to do
that.
At the same time, check that the account that the SQL Service is running
under has permissions on the destination directory.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rafet Ducic" <rducic@.hotmail.com> wrote in message
news:OZbJL6iNFHA.164@.TK2MSFTNGP12.phx.gbl...
>I am receiving General network error when I try to back up a SQL Server
> database on a computer that is running Windows Server 2000
> I receive Following error when running DB maintenance job:
> [2] Database master: Database Backup...
> Destination: & #91;\\LGA01\SysDbBackup_01\master_db_200
503311443.BAK]
> [Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft]
[ODBC
> SQL
> Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
> [Microsoft][ODBC SQL Server Driver][Named Pipes]General networ
k error.
> Check
> your network documentation.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pag
es for
> database 'master', file 'mastlog' on file 1.
> [3] Database model: Database Backup...
> Destination: & #91;\\LGA01\SysDbBackup_01\model_db_2005
03311443.BAK]
> Please Help
>

General network error

Does anyone have an idea why some of the scheduled jobs
end with the following error message:
Executed as user: DATABASE\Administrator.
ConnectionCheckForData (CheckforData()). [SQLSTATE 01000]
(Message 10054) General network error. Check your
network documentation. [SQLSTATE 08S01] (Error 11). The
step failed.
I have also experienced this when running long queries
(usually > 30min) in Query Analyzer.
I set the timeout to 300 (default was 60 or 30) and
reduced the packet size to 1428 (default was 4096) and
these helped but only with some queries/jobs.
Any help would be greatly appreciated!
.mikaby reducing the packet size you reduced the amount of pipe that SQL Server u
ses to communicate over the network. Timeout is in seconds so 300 seconds t
ranslates to 5 minutes. If the reduction of your useable bandwith across th
e network causes your trans
fer of data to go over 5 minutes then you have a problem.|||Have had this problem recently, it seems a common error with quite a
few different symptoms. I will tell you our story, which may or may
not help.
For our case, we had this error executing dynamic SQL over ADO.NET,
but could also recreate the problem via Query Analyser using different
protocols.
We were using a complex query and got either your error or the
following:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Connection Broken
We only got this error under certain conditions but could reproduce it
faithfully under those conditions.
Sniffing around the newsgroups, the general opinion was that if you
changed the query slightly, then in some cases the problem just "went
away".
I found 2 solutions to our problem.
Solution 1
Our query was using a view and by putting a "TOP 100 PERCENT" clause
in the view the problem went away (for one instance only)
Solution 2
By using "OPTION(MERGE JOIN)" or "OPTION(LOOP JOIN)" in the SQL
statement, the problem went away. By forcing "OPTION(HASH JOIN)" the
problem re-appeared.
My theory is that merge joins were causing the problem (possibly in
conjunction with parallel query execution) but can't prove anything
because when you get this problem, you can't even get a query plan.
Looking at the query plan after using "TOP 100 PERCENT" I noticed that
there were no merge joins, although that proves nothing.
We have continued to get problems in other areas of our application
and find that "OPTION(LOOP JOIN)" with dynamic sql fixes the symptoms
but if anybody can find out the root causes and a fix I would
appreciate it if they let me know.
"Mika" <mika.ylinen@.corporateimage.se> wrote in message news:<126e501c3f65f$860582e0$a00
1280a@.phx.gbl>...
> Does anyone have an idea why some of the scheduled jobs
> end with the following error message:
> Executed as user: DATABASE\Administrator.
> ConnectionCheckForData (CheckforData()). [SQLSTATE 01000]
> (Message 10054) General network error. Check your
> network documentation. [SQLSTATE 08S01] (Error 11). The
> step failed.
> I have also experienced this when running long queries
> (usually > 30min) in Query Analyzer.
> I set the timeout to 300 (default was 60 or 30) and
> reduced the packet size to 1428 (default was 4096) and
> these helped but only with some queries/jobs.
> Any help would be greatly appreciated!
> .mika

GAC issue

I have .NET 1.1/Visual Studio 2003 and am trying to make the .NET C# code visible in SSIS -- I am a newcomer to GAC and did the following:

Set up a strong-name key pair

Put in the reference to it inside assemblyinfo

Put in PreBuild event to uninstall in GAC and PostBuild to install in GAC

All appeared fine

Set up project in SSIS

Put up Add Reference dialog and looked for project dll -- not there

I see from above something about putting the assembly into c:\windows\framework\... I do not have

a directory "framework" under "windows"

Is there another place I should put the assembly>

It references when I put the assembly in the V 2.0 dir, that is,

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Note: this is a version 1.1 assembly. Would there be any

problems with just going ahead and doing this?

|||GAC is a runtime thing. Putting the assembly in the appropriate .NET folder allows you to reference it for debugging and intellisense.sql

FWIW: Database Space Used (stored proc)

For what it's worth, I hacked up MS' sp_spacedused and created a new stored procedure called sp_dbspaceused. I made the following modifications:

1. It returns a single resultset (instead of multiple resultsets);
2. I eliminated the options that were specfically geared towards sizing of individual objects (no object name parameter and no update statistics parameter);
3. I eliminated the formatting from the result set (the numbers are expressed in KB)

Place the code into an admin database or (more risky and less "best practice") directly into your master database.

Usage:
USE MyDatabase
GO

EXEC AdminDatabase.dbo.sp_dbspaceused
GO

CREATE PROCEDURE sp_dbspaceused

as

declare @.id int -- The object id of @.objname.
declare @.pages int -- Working variable for size calc.
declare @.dbname sysname
declare @.dbsize dec(15,0)
declare @.logsize dec(15)
declare @.bytesperpage dec(15,0)
declare @.pagesperMB dec(15,0)

/*Create temp tables before any DML to ensure dynamic
** We need to create a temp table to do the calculation.
** reserved: sum(reserved) where indid in (0, 1, 255)
** data: sum(dpages) where indid < 2 + sum(used) where indid = 255 (text)
** indexp: sum(used) where indid in (0, 1, 255) - data
** unused: sum(reserved) - sum(used) where indid in (0, 1, 255)
*/
create table #spt_space
(
rows int null,
reserved dec(15) null,
data dec(15) null,
indexp dec(15) null,
unused dec(15) null
)

set nocount on

/*
** If @.id is null, then we want summary data.
*/
/* Space used calculated in the following way
** @.dbsize = Pages used
** @.bytesperpage = d.low (where d = master.dbo.spt_values) is
** the # of bytes per page when d.type = 'E' and
** d.number = 1.
** Size = @.dbsize * d.low / (1048576 (OR 1 MB))
*/
begin
select @.dbsize = sum(convert(dec(15),size))
from dbo.sysfiles
where (status & 64 = 0)

select @.logsize = sum(convert(dec(15),size))
from dbo.sysfiles
where (status & 64 <> 0)

select @.bytesperpage = low
from master.dbo.spt_values
where number = 1
and type = 'E'
select @.pagesperMB = 1048576 / @.bytesperpage
/*
select database_name = db_name(),
database_size =
ltrim(str((@.dbsize + @.logsize) / @.pagesperMB,15,2) + ' MB'),
'unallocated space' =
ltrim(str((@.dbsize -
(select sum(convert(dec(15),reserved))
from sysindexes
where indid in (0, 1, 255)
)) / @.pagesperMB,15,2)+ ' MB')
*/
print ' '
/*
** Now calculate the summary data.
** reserved: sum(reserved) where indid in (0, 1, 255)
*/
insert into #spt_space (reserved)
select sum(convert(dec(15),reserved))
from sysindexes
where indid in (0, 1, 255)

/*
** data: sum(dpages) where indid < 2
** + sum(used) where indid = 255 (text)
*/
select @.pages = sum(convert(dec(15),dpages))
from sysindexes
where indid < 2
select @.pages = @.pages + isnull(sum(convert(dec(15),used)), 0)
from sysindexes
where indid = 255
update #spt_space
set data = @.pages

/* index: sum(used) where indid in (0, 1, 255) - data */
update #spt_space
set indexp = (select sum(convert(dec(15),used))
from sysindexes
where indid in (0, 1, 255))
- data

/* unused: sum(reserved) - sum(used) where indid in (0, 1, 255) */
update #spt_space
set unused = reserved
- (select sum(convert(dec(15),used))
from sysindexes
where indid in (0, 1, 255))

select reserved = cast((reserved * d.low / 1024.) as bigint) ,
data = cast((data * d.low / 1024.) as bigint) ,
index_size = cast((indexp * d.low / 1024.) as bigint) ,
unused = cast((unused * d.low / 1024.) as bigint)
from #spt_space, master.dbo.spt_values d
where d.number = 1
and d.type = 'E'
end

return (0) -- sp_spaceused

GOI think this one is shorter ;):

select
reserved=(
select sum(convert(dec(15),reserved))
from sysindexes
where indid in (0, 1, 255))*8,
index_size = ((
select sum(convert(dec(15),used))
from sysindexes
where indid in (0, 1, 255))
- (
select (select sum(convert(dec(15),dpages))
from sysindexes
where indid < 2) + isnull(sum(convert(dec(15),used)), 0)
from sysindexes
where indid = 255))*8,
data=(
select (select sum(convert(dec(15),dpages))
from sysindexes
where indid < 2) + isnull(sum(convert(dec(15),used)), 0)
from sysindexes
where indid = 255)*8,
unused=((
select sum(convert(dec(15),reserved))
from sysindexes
where indid in (0, 1, 255))
- (
select sum(convert(dec(15),used))
from sysindexes
where indid in (0, 1, 255)))*8|||Yes it is. No one ever accused me of having an overabundance of imagination.

Thanks for the nice re-write.

Regards,

hmscott|||With compliments to rdjabarov and apologies to those who do this for a living , I offer up this version which will pull the results for each database...

Regards,

hmscott

ALTER PROC sp_dbSpaceUsed

AS

CREATE TABLE #TempSpace (
[Database] varchar(255),
Reserved dec(15),
Index_Size dec(15),
Data dec(15),
Unused dec(15)
)

DECLARE @.sSQL varchar(1000)

SELECT @.sSQL = 'INSERT INTO #TempSpace ([Database], Reserved, Index_Size, Data, Unused)
SELECT
''?'' as [Database],
reserved=(
select sum(convert(dec(15),reserved))
from [?]..sysindexes
where indid in (0, 1, 255))*8,
index_size = ((
select sum(convert(dec(15),used))
from [?]..sysindexes
where indid in (0, 1, 255))
- (
select (select sum(convert(dec(15),dpages))
from [?]..sysindexes
where indid < 2) + isnull(sum(convert(dec(15),used)), 0)
from [?]..sysindexes
where indid = 255))*8,
data=(
select (select sum(convert(dec(15),dpages))
from [?]..sysindexes
where indid < 2) + isnull(sum(convert(dec(15),used)), 0)
from [?]..sysindexes
where indid = 255)*8,
unused=((
select sum(convert(dec(15),reserved))
from [?]..sysindexes
where indid in (0, 1, 255))
- (
select sum(convert(dec(15),used))
from [?]..sysindexes
where indid in (0, 1, 255)))*8'

EXEC sp_MSforeachdb @.command1=@.sSQL

SELECT * FROM #TempSpace

DROP TABLE #TempSpace

Fuzzy Lookup Error

Hi

I get the following error when I use Fuzzy Lookup in a Data Flow task with TransactionOption property set to “Required”

[Fuzzy Lookup [61]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot create new connection because in manual or distributed transaction mode.".

When I Change the TransactionProperty to “Supported” it works fine.

I need the property set to Required for it does an undo in the event of a failure.

Any ideas on how to get the Fuzzy Lookup to work

Are you executing the package containing the data flow task from a parent package? I have seen an issue where the OLE DB connection does not properly defect from the transaction, and throws an error like you're seeing here. The work around was to execute the child package out of process.

~Matt

|||i dont have any child packages..|||

Set Required on the package container, and Supported on all child containers. Then they will automatically enlist with the transaction from the package container.

Why do you need a transaction around a lookup?

sql

Fush IDES

In sql profiler I see the following ObjectName called "Flush IDES". It
appears to occur after a commit of a user_transaction? It's
EventSubClass is all "0-begin" and "1-commit"s?
Does anybody know what this is?
My guess this is what you may see.
IDESThe IDES latch waitresource is used when the PFS page is scanned to
find free space and when the PFS page is updated to reflect allocations and
deallocations of pages. This latch is also used when single pages are
allocated to an existing object.Determine whether you have a clustered index
on the object in question.
reference.
http://support.microsoft.com/kb/822101/en-us
this is applicable to sql 200 sp4 and later versions.
You did not provide all the info from the trace to say for sure. So it is a
guess.
Thanks, Liliya
"Ken" wrote:

> In sql profiler I see the following ObjectName called "Flush IDES". It
> appears to occur after a commit of a user_transaction? It's
> EventSubClass is all "0-begin" and "1-commit"s?
> Does anybody know what this is?
>
sql

Fush IDES

In sql profiler I see the following ObjectName called "Flush IDES". It
appears to occur after a commit of a user_transaction? It's
EventSubClass is all "0-begin" and "1-commit"s?
Does anybody know what this is?My guess this is what you may see.
IDES The IDES latch waitresource is used when the PFS page is scanned to
find free space and when the PFS page is updated to reflect allocations and
deallocations of pages. This latch is also used when single pages are
allocated to an existing object. Determine whether you have a clustered index
on the object in question.
reference.
http://support.microsoft.com/kb/822101/en-us
this is applicable to sql 200 sp4 and later versions.
You did not provide all the info from the trace to say for sure. So it is a
guess.
--
Thanks, Liliya
"Ken" wrote:
> In sql profiler I see the following ObjectName called "Flush IDES". It
> appears to occur after a commit of a user_transaction? It's
> EventSubClass is all "0-begin" and "1-commit"s?
> Does anybody know what this is?
>

funny sql

The following sql updates 300 records(3000 records in the
marc_POt_lu_rd_post_code table) but the select element only returns one row.
I am attempting to update the 3000 rows which it does but it does it
incorrectly in that the results set from the select portion does not match
what the results set returns after the update. I added the extra postcode
criteria in the select to isolate what the update does but it still updates
the 3000 rows. Weird?
UPDATE marc_POt_lu_rd_post_code
SET County_id = c.County_id,
County_desc = c.County_Desc,
Parent_County_Id = c.Parent_County_Id,
Parent_County_desc = c.County_desc,
Sector_Id = d.Sector_Id,
Sector_Desc = d.Sector_Desc,
Area_Id = e.Area_Id,
Area_Desc = e.Area_Desc
-- Select *
FROM Pot_lu_County_Area_PostCodes a,
QUINN_st..GET_BCP_H_POSTCODES b,
Pot_lu_county c,
Pot_lu_Sectors d,
Pot_lu_Areas e
WHERE a.Postcode = b.Four_Char_Post_Codes
AND b.COUNTY = c.County_Desc
AND b.SECTOR = d.Sector_Desc
AND b.AREA = e.Area_Desc
and a.Postcode = b.Four_Char_Post_Codes
and b.Four_Char_Post_Codes = 'mk40'found the issue
"marcmc" wrote:

> The following sql updates 300 records(3000 records in the
> marc_POt_lu_rd_post_code table) but the select element only returns one ro
w.
> I am attempting to update the 3000 rows which it does but it does it
> incorrectly in that the results set from the select portion does not match
> what the results set returns after the update. I added the extra postcode
> criteria in the select to isolate what the update does but it still update
s
> the 3000 rows. Weird?
> UPDATE marc_POt_lu_rd_post_code
> SET County_id = c.County_id,
> County_desc = c.County_Desc,
> Parent_County_Id = c.Parent_County_Id,
> Parent_County_desc = c.County_desc,
> Sector_Id = d.Sector_Id,
> Sector_Desc = d.Sector_Desc,
> Area_Id = e.Area_Id,
> Area_Desc = e.Area_Desc
> -- Select *
> FROM Pot_lu_County_Area_PostCodes a,
> QUINN_st..GET_BCP_H_POSTCODES b,
> Pot_lu_county c,
> Pot_lu_Sectors d,
> Pot_lu_Areas e
> WHERE a.Postcode = b.Four_Char_Post_Codes
> AND b.COUNTY = c.County_Desc
> AND b.SECTOR = d.Sector_Desc
> AND b.AREA = e.Area_Desc
> and a.Postcode = b.Four_Char_Post_Codes
> and b.Four_Char_Post_Codes = 'mk40'
>

funny error - the parameter menu screen...

Here is a funny one:
When scrolling through the dropdown box using the up and down arrow
keys, the following error is received:
Steps to reproduce: select an item in the dropdownbox. Change the
selected item by scrolling through the dropdown box using the up and
down arrow keys.
error
There are too many people accessing the Web site at this timeHello Harry,
If you are on XP, then I suspect that what is happening is that you are
locked down by default to a connection limit of 10 to IIS, and you are
running out of connections.
In the Hitchhiker's Guide to SQL Server 2000 Reporting Services, Bill and I
show how you can up the connection limit to 40 using the MetaEdit tool. We
include the details in Appendix D - pages 703 - 705 and also on the DVD
Video content.
This Guide me! demonstration is an example taken from the book's DVD and
explains how to up that connection limit to 40.
http://www.sqlreportingservices.net/SampleGuideMe.htm
Peter Blackburn
Hitchhiker's Guide to SQL Server 2000 Reporting Services
www.sqlreportingservices.net
"Harry" <harshwardhan@.mailcity.com> wrote in message
news:e48fb32a.0410191647.36ed5dcc@.posting.google.com...
> Here is a funny one:
> When scrolling through the dropdown box using the up and down arrow
> keys, the following error is received:
> Steps to reproduce: select an item in the dropdownbox. Change the
> selected item by scrolling through the dropdown box using the up and
> down arrow keys.
> error
> There are too many people accessing the Web site at this time

Function to return week number

Does anyone now how I can create a SQL function to return a w
number for any date with the following guidlines?
-Ws begin on a Thursday and end on a Wednesday.
-1st January is always in w 1.
-W 1 for this year would go from 30/12/2004 to 05/01/2005
I have been going round in circles trying to crack this one. I would
be very grateful if anyone has any ideas.Mark
Use DateFirst and DatePart
an Example in T-SQL:
Set DateFirst 4
Declare @.D DateTime Set @.D = '20050101'
Select DatePart(wk, @.d)
To make a function:
-- **********************************
Create Functiondbo.WNumber
(@.D DateTime,
@.FDOW TinyInt) -- The day of w yo want to be first Mon = 1; Sunday= 7
Returns TinyInt
As
Begin
Declare @.WkNo TinyInt
Set @.WkNo = (DatePart(dy, @.d ) +
@.FDOW + 4) / 7
Return @.WkNo
End
-- ---
Use it like this:
Select dbo.WNumber('20050106',4)
"Mark Powell" wrote:

> Does anyone now how I can create a SQL function to return a w
> number for any date with the following guidlines?
> -Ws begin on a Thursday and end on a Wednesday.
> -1st January is always in w 1.
> -W 1 for this year would go from 30/12/2004 to 05/01/2005
> I have been going round in circles trying to crack this one. I would
> be very grateful if anyone has any ideas.
>|||The you tried the built-in DATEPART after setting appropriate SET DATEFIRST?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mark Powell" <mark@.muddyboots.com> wrote in message
news:f10f176.0503300059.5537cf67@.posting.google.com...
> Does anyone now how I can create a SQL function to return a w
> number for any date with the following guidlines?
> -Ws begin on a Thursday and end on a Wednesday.
> -1st January is always in w 1.
> -W 1 for this year would go from 30/12/2004 to 05/01/2005
> I have been going round in circles trying to crack this one. I would
> be very grateful if anyone has any ideas.|||Thanks - that's much better than anything I could come up with. The
only problem with this function is that 30/12/04 and 31/12/04 are
returning w 53 and I want them to return w 1.|||That IS counterintuitive, that the last days of 2004 should be considered as
being in the first w of 2005, But if you want it that way, modify
function so that if value calculates to 53, it returns 1 instead
Alter Functiondbo.WNumber
(@.D DateTime,
@.FDOW TinyInt) -- The day of w yo want to be first Mon = 1; Sunday= 7
Returns TinyInt
As
Begin
Declare @.WkNo TinyInt
Set @.WkNo = (DatePart(dy, @.d ) +
@.FDOW + 4) / 7
Return Case @.WkNo When 53
Then 1 Else @.WkNo End
End
"mark@.muddyboots.com" wrote:

> Thanks - that's much better than anything I could come up with. The
> only problem with this function is that 30/12/04 and 31/12/04 are
> returning w 53 and I want them to return w 1.
>|||It doesn't make sense to me either, exept that it keeps the same w
number across the year end. It is how our client wants it, so it's the
way it needs to be done.
The next problem I have found is that the w number does not return
the correct value if I use a date from 2004 or 2006 (i.e. not 2005). I
imagine the +4 in your procedure should be a variable based on the
year, but I am not sure what it does?
Thanks for your help.
Mark|||Mark,
This was much harder than I thought at first, but this is it... Give it a
shot...
ALTER FUNCTION dbo.WNumber
(@.D DateTime, @.FDOW TinyInt)
Returns TinyInt
As
Begin
Declare @.FDOY Smallint, @.Shft Smallint, @.Yr SmallInt
Set @.Yr = Year(@.D)
Set @.FDOY = DatePart(dw, Str(@.Yr,4,0) + '0101') +
(@.@.DateFirst%7) - 1
Set @.Shft = (@.FDOY - @.FDOW + 7) % 7
Declare @.WkNo TinyInt
Set @.WkNo = (DatePart(dy, @.d) + @.Shft + 6) / 7
-- Now adjust for last partial w
Return Case When @.WkNo < 53 Then @.WkNo
When @.WkNo > 53 Or @.Shft < 5 Then 1
When @.Shft = 6 Then 53
-- Leap Year Consideration
When DatePart(dy, Str(@.Yr,4,0) + '1231') = 365
Then 1
Else 53 End
End
-- ****************************************
***************
And here is the code to test it...
Declare @.Y SmallInt Set @.Y = 2000
Set NoCOunt On
Declare @.D DateTime
Declare @.FDOW TinyInt Set @.FDOW = 4
Declare @.DP TinyInt,@.DF TinyInt,
@.DY SmallInt, @.I TInyInt
Declare @.DTs Table(DT TinyInt)
Set @.I = 0
While @.I < 7 Begin
Set @.I = @.I + 1
Insert @.DTs(DT) Values(@.I)
End
Print 'Year Day Date WNo Day Date WNo '
While @.Y < 2010 Begin
--Set @.D = STR(@.Y, 4,0) + '0101'
Set @.DF = @.@.DateFirst
--Set @.DP = datepart(wday, @.D)
--Set @.DY = datepart(dy, @.D)
Select @.Y,
Left(DateName(dw, Str(@.Y, 4,0) + '01' + Replace(Str(DT, 2,0),' ', '0')),2)
+
' ' + Str(@.Y, 4,0) +'01' + Left(Replace(Str(DT, 2,0),' ', '0'),8) +
' ' +
Cast(dbo.WNumber(Str(@.Y, 4,0) +'01' + Left(Replace(Str(DT, 2,0),'
', '0'),2), 4) as Char(2)),
Left(DateName(dw, Str(@.Y, 4,0) + '12' + Replace(Str(DT+24, 2,0),' ',
'0')),2) +
' ' + Str(@.Y, 4,0) +'12' + Left(Replace(Str(DT+24, 2,0),' ', '0'),8)
+ ' ' +
Cast(dbo.WNumber(Str(@.Y, 4,0) +'12' + Left(Replace(Str(DT+24,
2,0),' ', '0'),2), 4)as Char(2))
From @.DTs
Set @.Y = @.Y + 1
End
"mark@.muddyboots.com" wrote:

> It doesn't make sense to me either, exept that it keeps the same w
> number across the year end. It is how our client wants it, so it's the
> way it needs to be done.
> The next problem I have found is that the w number does not return
> the correct value if I use a date from 2004 or 2006 (i.e. not 2005). I
> imagine the +4 in your procedure should be a variable based on the
> year, but I am not sure what it does?
> Thanks for your help.
> Mark
>|||Sorry , error in test script...
Use the following to test UDF In Prev Post
-- ****************************************
********
Set NoCount On
Declare @.D DateTime
Declare @.FDOW TinyInt Set @.FDOW = 2
Declare @.Y SmallInt Set @.Y = 2000
-- --
Declare @.I TInyInt Set @.I = 0
Declare @.DTs Table(DT TinyInt)
While @.I < 7 Begin
Set @.I = @.I + 1
Insert @.DTs(DT) Values(@.I)
End
-- ---
Print 'Year Day Date WNo Day Date WNo '
While @.Y < 2010 Begin
Select @.Y,
Left(DateName(dw, Str(@.Y, 4,0) + '01' +
Replace(Str(DT, 2,0),' ', '0')),2) +
' ' + Str(@.Y, 4,0) +'01' +
Left(Replace(Str(DT, 2,0),' ', '0'),8) + ' ' +
Cast(dbo.WNumber(Str(@.Y, 4,0) +'01' +
Left(Replace(Str(DT, 2,0),' ', '0'),2), @.FDOW) as Char(2)),
Left(DateName(dw, Str(@.Y, 4,0) + '12' +
Replace(Str(DT+24, 2,0),' ', '0')),2) +
' ' + Str(@.Y, 4,0) +'12' +
Left(Replace(Str(DT+24, 2,0),' ', '0'),8) + ' ' +
Cast(dbo.WNumber(Str(@.Y, 4,0) +'12' +
Left(Replace(Str(DT+24, 2,0),' ', '0'),2), @.FDOW)as Char(2))
From @.DTs
Set @.Y = @.Y + 1
End
-- ****************************************
********
"mark@.muddyboots.com" wrote:

> It doesn't make sense to me either, exept that it keeps the same w
> number across the year end. It is how our client wants it, so it's the
> way it needs to be done.
> The next problem I have found is that the w number does not return
> the correct value if I use a date from 2004 or 2006 (i.e. not 2005). I
> imagine the +4 in your procedure should be a variable based on the
> year, but I am not sure what it does?
> Thanks for your help.
> Mark
>

Function Suppressing Index

I have the following query that needs to be rewritten (if possible) so that
the clustered index on column "coldate" can be utilized. Any suggestions
would be appreciated. I realize that getting the functions off the column is
the goal, but I am not seeing how that might be done in this instance. Thank
s
in advance.
SELECT *
FROM
table t
WHERE
DateDiff(n, DateAdd(n, t.col1 - 1, t.coldate), @.enddate) <= 0
Message posted via http://www.droptable.comthis looks like homework.
you really can't because you are simultaneoulsy doing a calc on t.col1
for every row.
you could probably increase performance though by getting rid of
datediff, and just comparing the dates of hte dateadd results vs
@.enddate.|||Hi
If you don't need to have the date as a date then you may want to store
coldate as a offset for the number of minutes.
John
"cbrichards" wrote:

> I have the following query that needs to be rewritten (if possible) so tha
t
> the clustered index on column "coldate" can be utilized. Any suggestions
> would be appreciated. I realize that getting the functions off the column
is
> the goal, but I am not seeing how that might be done in this instance. Tha
nks
> in advance.
> SELECT *
> FROM
> table t
> WHERE
> DateDiff(n, DateAdd(n, t.col1 - 1, t.coldate), @.enddate) <= 0
> --
> Message posted via http://www.droptable.com
>

Function Suppressing Index

I have the following query that needs to be rewritten (if possible) so that
the clustered index on column "coldate" can be utilized. Any suggestions
would be appreciated. I realize that getting the functions off the column is
the goal, but I am not seeing how that might be done in this instance. Thanks
in advance.
SELECT *
FROM
table t
WHERE
DateDiff(n, DateAdd(n, t.col1 - 1, t.coldate), @.enddate) <= 0
--
Message posted via http://www.sqlmonster.comthis looks like homework.
you really can't because you are simultaneoulsy doing a calc on t.col1
for every row.
you could probably increase performance though by getting rid of
datediff, and just comparing the dates of hte dateadd results vs
@.enddate.|||Hi
If you don't need to have the date as a date then you may want to store
coldate as a offset for the number of minutes.
John
"cbrichards" wrote:
> I have the following query that needs to be rewritten (if possible) so that
> the clustered index on column "coldate" can be utilized. Any suggestions
> would be appreciated. I realize that getting the functions off the column is
> the goal, but I am not seeing how that might be done in this instance. Thanks
> in advance.
> SELECT *
> FROM
> table t
> WHERE
> DateDiff(n, DateAdd(n, t.col1 - 1, t.coldate), @.enddate) <= 0
> --
> Message posted via http://www.sqlmonster.com
>

Function (fn locate(@p1, P_fam_nm))

In the profiler, I saw the following constructions as part of a statement :
(fn locate(@.p1, P_fam_nm))= 1
This look to me as an ODBC function, but I cannot find the function
described in the BOL. The function is problably replaced by a SQL-server
function. (Could be patindex).
Where and how can I find which function is used in SQL-server instead.
Or can SQL-server run this type (ODBC ?) functions ?
ben brugmanI've never heard of that function. I googled it and didn't see any hits
associated with ODBC or MDAC. It doesn't exist on my server. So... I suspect
it's a user defined function.
You can run this statement in all your databases to see where the function
exists.
select * from sysobjects where name like 'fn_locate'
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"ben brugman" <ben@.niethier.nl> wrote in message
news:ebZVBx1sDHA.2508@.TK2MSFTNGP12.phx.gbl...
> In the profiler, I saw the following constructions as part of a statement
:
> (fn locate(@.p1, P_fam_nm))= 1
> This look to me as an ODBC function, but I cannot find the function
> described in the BOL. The function is problably replaced by a SQL-server
> function. (Could be patindex).
> Where and how can I find which function is used in SQL-server instead.
> Or can SQL-server run this type (ODBC ?) functions ?
> ben brugman
>|||I see in in the profiler, the coding using it, does work.
The syntax is <(FN locate(string1,string2))
The FN denotes the a function follows.
Behind the FN is a space.
If it is a user defined function the calling program
does define the function before it is called, because
it is not inserted by 'humans'.
And the function does not work from the QA so it
is not present as such.
I'll have a check if the calling program is defining the
function, but this is unlikely to me.
(The workings of the function is very similar (or equal to)
patindex).
ben brugman
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:ucz3LR2sDHA.3492@.TK2MSFTNGP11.phx.gbl...
> I've never heard of that function. I googled it and didn't see any hits
> associated with ODBC or MDAC. It doesn't exist on my server. So... I
suspect
> it's a user defined function.
> You can run this statement in all your databases to see where the function
> exists.
> select * from sysobjects where name like 'fn_locate'
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "ben brugman" <ben@.niethier.nl> wrote in message
> news:ebZVBx1sDHA.2508@.TK2MSFTNGP12.phx.gbl...
> > In the profiler, I saw the following constructions as part of a
statement
> :
> >
> > (fn locate(@.p1, P_fam_nm))= 1
> >
> > This look to me as an ODBC function, but I cannot find the function
> > described in the BOL. The function is problably replaced by a SQL-server
> > function. (Could be patindex).
> >
> > Where and how can I find which function is used in SQL-server instead.
> > Or can SQL-server run this type (ODBC ?) functions ?
> >
> > ben brugman
> >
> >
>

FullText Search Error 1075: The dependency service does not exist or

Hi Guys,
Can you please help me with the following problem:
My website keeps crashing and the FullText Search cannot start. I keep
getting errors 7003 in the Event Log with the following message:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7003
Date: 3/8/2008
Time: 3:18:24 PM
User: N/A
Computer: MASTER
Description:
The SQL Server FullText Search (MSSQLSERVER) service depends on the
following nonexistent service: NTLMSSP
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
When trying to start the service from Services window I get the
following error:
FullText Search Error 1075: The dependency service does not exist or
has been marked for deletion
Checked the Dependencies in Registry and sqlserver has the following
dependencies: RPCSS NTLMSSP
I have had to restart the server multiple times and cannot figure out
what the problem is.
Windows Server 2003 Standart Edition
SQL Server 2005 Workgroup Edition
Please help
AlbanoOn Mar 9, 2:56=A0am, alstef...@.gmail.com wrote:
> Hi Guys,
> Can you please help me with the following problem:
> My website keeps crashing and the FullText Search cannot start. I keep
> getting errors 7003 in the Event Log with the following message:
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7003
> Date: =A03/8/2008
> Time: =A03:18:24 PM
> User: =A0N/A
> Computer: MASTER
> Description:
> The SQL Server FullText Search (MSSQLSERVER) service depends on the
> following nonexistent service: NTLMSSP
> For more information, see Help and Support Center athttp://go.microsoft.co=
m/fwlink/events.asp.
> When trying to start the service from Services window I get the
> following error:
> FullText Search Error 1075: The dependency service does not exist or
> has been marked for deletion
> Checked the Dependencies in Registry and sqlserver has the following
> dependencies: RPCSS NTLMSSP
> I have had to restart the server multiple times and cannot figure out
> what the problem is.
> Windows Server 2003 Standart Edition
> SQL Server 2005 Workgroup Edition
> Please help
> Albano
Try this
1. Open the registry key HKEY_LOCAL_MACHINE\System\CurrentControlSet
\Services\msftesql
2. Rename the value DependOnService to anything
3. Restart the server
This have helped me.

Full-text Search

Hello, I have a full-text enabled field in my table has the following
content as an example:
"SQL Server is a comprehensive, integrated, end-to-end data solution
that empowers your people by providing a more secure, reliable, and
productive platform for enterprise data and BI applications. SQL Server
2005 delivers powerful, familiar tools to IT professionals as well as
to information workers, reducing the complexity of creating, deploying,
managing, and using enterprise data and analytical applications on
platforms ranging from mobile devices to enterprise data systems."
My question: Is there a way to return only the text that follows a
keyword specified as a parameter in the select statement? for example
the above content would be selected if i search for "reducing" but i
would like to return in that case:
"reducing the complexity of creating, deploying, managing, and using
enterprise data and analytical applications on platforms ranging from
mobile devices to enterprise data systems." as that piece of text
follows the word "reducing"
Any ideas would be appreciated.
Thanks,
Mayahttp://groups.google.com/group/microsoft.public.sqlserver.fulltext/msg/81eb71cac37c6cf3?dmode=source
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Maya" <kfoury@.gmail.com> wrote in message
news:1140309837.125404.94740@.g14g2000cwa.googlegroups.com...
> Hello, I have a full-text enabled field in my table has the following
> content as an example:
> "SQL Server is a comprehensive, integrated, end-to-end data solution
> that empowers your people by providing a more secure, reliable, and
> productive platform for enterprise data and BI applications. SQL Server
> 2005 delivers powerful, familiar tools to IT professionals as well as
> to information workers, reducing the complexity of creating, deploying,
> managing, and using enterprise data and analytical applications on
> platforms ranging from mobile devices to enterprise data systems."
>
> My question: Is there a way to return only the text that follows a
> keyword specified as a parameter in the select statement? for example
> the above content would be selected if i search for "reducing" but i
> would like to return in that case:
>
> "reducing the complexity of creating, deploying, managing, and using
> enterprise data and analytical applications on platforms ranging from
> mobile devices to enterprise data systems." as that piece of text
> follows the word "reducing"
>
> Any ideas would be appreciated.
>
> Thanks,
>
> Maya
>

Full-Text population problems

Hi

I'm getting the following error when I attempt to populate our Full Text Index on SQL
2000: The crawl seed in project SQL0000500005> cannot be accessed. Error: 800705b4 - This operation returned because
the timeout period expired. .

The crawl for project could not be started,
because no crawl seeds could be accessed. Fix the errors and try the crawl again.

I have seen in other threads and on the MS site how this is caused by the MSSQLService and the MS Search services not being syncronized and it can be fixed by changing the MSSQLService account to use the system account and back again.

The BUILTIN\Administrators group is present in SQL and has OWNER permissions. I even tried giving the SYSTEM group full access to the FTDATA folder.

This did NOT work for me. I am still getting the messages. One thing that is probably unique to my instalation is that it resides on the only server on this network so it is also the primary domain controler. Could this be why I cannot get the FT population to work?

I have another machine on a seperate network that is not a PDC and FT-Indexing works great on it but that doesn't help me for the network I need it to work on.

Does anyone have any other ideas I could try? I have been working on this for close to a week now.

The "Mav"How about the SQL Services account privileges and which accout is used?

Check what is the current state of process for indexing.

Refer to this
KBA (http://support.microsoft.com/default.aspx?scid=KB;en-us;q317746) to resovle the issue.|||I looked through that document and I have tried all that still no dice. The MS Search service is using the Local System account and the MSSQLServer service is using the local server administrator account. I tried changing this to the Local System acount using SQL Server Enterprise Manager(SSEM) this did not work so I changed it back to the local administrator account, once again using the SSEM.

Any other suggestions?

Thanks,
The Mav|||No one has any ideas? =(