For the backup process it should not matter what you are doing.

This is part of your backup strategy.

I do the first method, until media 1 is full, delete...

Hi,

do you want to store this in your db? Or calculate it at runtime?

Is there a primary key in your table?

Cheers,

Frank

This solution will show you the whole text field in the grid. If you just want to read what's in the text field, try,

DECLARE @text varchar(8000)

SELECT @variable =<field_name>FROM <table_name WHERE...

no, not yet

Cheers,

Frank

Well, it's not only about porn or stuff like that. If I were not to sit behind a good viruswall and firewall I would be really concerned about spam that...

Hi,

is it possible to spider a dynamically created webpage like this one? If yes, are there any defending mechanisms? The trick with the company name in the mail address should...

Microsoft Knowledge Base

Cheers,

Frank

HI,

from my understanding if a developer belongs to the local or domain admin group he is by default member of the SQL dbo group. So revoking any rights from his...

No, filegroups use ndf extension.

are you having a backup up system

Read the article http://www.acs.unimelb.edu.au/backups/veritas/IDR2000.pdf

Can this apply?

Cheers,

Frank

aha 🙂

Cheers,

Frank

I'd go for a bigger hard drive for that seems very risky

Cheers,

Frank

Strange, have you just for fun tried to put the field into a variable and then perform the rtrim operation on the variable?

Cheers,

Frank

Could you provide more information on what you are doing?

Cheers,

Frank

Hi,

if you are a subscriber to SQL Server Magazin you can follow this link

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=37890, that's what I have just read, but I'm sure there are plenty of other sources out...

hi,

sorry to answer your question so late. I was busy.

I have set up a maintenance plan using the SQL wizard The following happens

- backup up all user db's

- no optimizations

-...