I would like to retreive the last string from this pattern
,B110,A104,AUSL,
,L101,A101,01,
which means i want to retrieve AUSL and 01

What are the many pitfalls and issues of moving a production server running
sql server 2000 enterprise edition to a virtual machine? Is it even possible?
Is it compatible? I've talked to a few dba's in my neck of the woods and all
of them say do not do it. It's the way sql 2000 is ...

I developed some VB code (visual Studio 2008) that uses the sql server in
visual studio to do some record keeping for the web service. I placed a .MDF
file in the App_Data directory and developed the code.
When I copied the Site to another server it will not run. The server does

About two months ago, there was a popup from the Task Manager saying 'Updates
are ready for your computer.' I pretty much ignored it, until one day I was
not busy so I chose to update. One file, Security Update for SQL Server 2005
Service Pack 2 (KB948109), could not be installed ...

I have a view which includes a couple of udfs.  The view works fine in 2000,
but we've migrated to 2005 now, and one of the udf's doesn't work anymore.  
It returns all null values.  
The udf that works has all char parameters:

sys.database_files returns a column indicating database size.
how to convert the size value to MB or GB?

I am accessing the current backup strategy on our financial database.  
Backup maintenance was set by a different person in IT.  The database and
logs were backed up to the same folder daily at 4am.  What has me confused is
the log, .trn file is as big as the data file everyday, ...

In our SQL 2000 DB, we have a stored proc. The last line of the proc
is like :
SELECT .... from #temptable
I am monitoring the duration the proc takes using SQL profiler.

I am running Windows 2003 SP2 x64 with SQL Server 2005 X64. Does the
counter SQLServer:Memory Manager/Total Server Memory (KB) show the
amount of physical memory is use by SQL? Why isn't this value reported
by the sqlservr.exe working set?

can someone please let me know how can I find "ini file"/interface file which
contains servers connectivity information in sql server directory?
I'm using sql server 2005.
Thanks,

We have a database with collation 'Hungarian_CI_AI' where we have problems
executing a function when you write it in different cases.
The function is called 'funDameIdDocSesion' which executes fine when you
write it exactly as it's created, but when we change the 's' of Sesion to

I'm assigned a task to find out how many transactions processed on our sql
database during the period of time.
I have no clue how to get this information. We are using sql 2000.
Please help,

I have a component which runs as an NT service in loclasystem account.
Through this service using ODBC I run the Query
<DBName>.sys.database_files but in results it do not list the file
information for FILESTREAM.

We are getting this error when .net 2.0 windows application is
accessing the database using a datareader.
Could not find much info about how to fix this issues.
Can anyone help please?

I am developing a ASP.NET 1.1 application for one of our customers in
Stockholm. Today we are using Microsoft Access for our database. The
application runs on XP, Vista and Win 2003 Server. Our customer want to
support SQL Server and we have been looking at the Express Edition. ...