Maybe you can use the WITH (NOLOCK) hint in your SELECT statement. This will read the data even if an exclusive lock is set on the record.

:exclamation:But beware: a query...

It's a bit hard to understand your question. Can you post the complete query?

You can try to use the computed phrase to fill your column:

For instance if your computed column...

Doesn't give the description of the error a clue what the source is?

Can you post more information so we can help you better...

This is not easy for a numeric value, because you have to code '00'+@number everywhere in your code (see post of Nary). Better to convert to a string.

declare @number char(10)

set...

All values in a DMV will be removed. After the restart of SQL all logging of index-usage etc. will start from scratch.

To select all SP's with a specific versionnumber:

select * from sys.objects where type = 'P' AND name LIKE '%_268000'

To see all used versions (including how many SP's are available in...

Did you allready fill your table with data?

If so, are the values in the varchar() column unique? --> required for PK!!

For performance it is better to NOT shrink the LOG-file. It takes lots of I/O for the log-file to expand each time. When a full- or logfile-backup is taken, completed...

Or, with the sample you are giving, you can just use a nested REPLACE function in your query...

REPLACE(

REPLACE(

Table2.CategoryCode

...

You have to split up the values in table 2. If you put this into a temp table, you can join this with table 3.

You can create a new query and use this as a sub-query within. You can GROUP BY this new query on 'TheMonth' and incluse a SUM on the 'Sales' column.

@Chirag: on the internet I've found "Min_active_rowversion() was introduced in SP2 for SQL Server 2005".

In my opinion you should let file handling be done by the OS and not SQL, because each is made for a different purpose.

Most likely you can find programs or...

Hi

Use this to change the value in field [VoxFilePath] for all records that are 31 days old.

UPDATE Recording

SET VoxFilePath = REPLACE(VoxFilePath,'\\10.2.1.20','\\serv02')

WHERE DATEDIFF(day, RECSTART, GetDate()) = 31

Put this code in an...

In addition to my first post in this topic:

Someone allready created a SP (SP_Generate_Inserts) to script the contents of a table to INSERT commands. Look at this url: http://vyaskn.tripod.com/code/generate_inserts_2005.txt