Why are you formatting the numbers in the database? The numbers should be formatted in the presentation layer.

Adi

Yes you can. Here is an example:

declare @vb varbinary(12)

set @vb = 0x5375726520796F752063616E

select convert(varchar(12),@vb)

Adi

You can try using the default trace to check if someone issued a backup log statement.

Adi

Do you mean that it returned no records at all? Didn’t stop running? Returned 0 as number of transactions count? Or anything else? Also did you change...

Are you sure that those are the only statements that were running. Is there a chance that those are the LAST statements that the sessions ran? My guess...

On my laptop it took 273 MS.

Adi

I just tried to reproduce your problem, but couldn't. I used your code and then I ran the select statement but got the results very fast. I tried...

I don’t have a link, but I can try and explain. First of all you are correct when you say that there is a difference between setting deny permission...

Here is one way:

with MyCTE as (

select lfisno, sum(quantity) as QuantityPerlfisno

from TEST

group by lfisno)

select T.lfisno, Stockcode, quantity, convert(real,quantity)/M.QuantityPerlfisno as rate

from TEST T inner join MyCTE M on T.lfisno =...

In case that there is a conflict between permissions, the DENY permission will be the one that will be imposed by the server. In your case there is a...

Can you show the code that doesn't work and add the error that you are getting?

Adi

No default size. When a table is created it has no pages that are allocated to it. When you start inserting data, it will have pages allocate to...

I have to admit that it is a long time since I’ve changed the default port, bus as far as I remember, you’ll have to select a fixed port number,...

This is a very problematic script to write. I think that at best you can write a SQL statement that will bring you closer. For example:

Select object_name(object_id)

From sys.sql_modules

Where...

The expiration date is not checked when you base the encryption and decryption on a certificate, so your application will continue working after the certificate’s expiration date.

Adi