You could do this, but the problem is that when you take a backup you're backing up the log as well. To do a restore from logs you'd have...

If you just want strings with one or more spaces you could use something akin to:

...

WHERE CHARINDEX(' ', column_name) > 0

If you want an exact count of the number of...

SELECT REPLACE([Market_Name], ' ', '')

That'll work.

Using EXISTS here is your mistake... EXISTS does not evalute individual rows, it just finds out if the following query in parenthesis returns true or not.

Use a self-join...

UPDATE t

SET...

I'd agree, this question is in error.

You might want to see if the user can log on from a different workstation.

I've found SSPI errors tend to be due to something screwed up in AD, either the...

Another option you might not like (and should use only after careful consideration) is to backup the log using the TRUNCATE_ONLY option. It will remove the inactive part of...

Your users are running under low-priviledge accounts which cannot install the print control. If you have centralized software deployment you can deploy the control stored in Program Files\Microsoft SQL...

In the table EmailTransmission, is the emailContents column also nvarchar(max)? I'd test the length of that column. I'd also make everything consistently nvarchar(max) instead of alternating between varchar(max)...

I'm assuming you're saying that you're using @body as the nvarchar(max) value. It would probably help to give an example of the data/code you're working with.

DTS is now SQL Server Integration Services. It's not nearly as easy to use as DTS was, however it's much more powerful (IMHO). It's available in Standard edition...

You might try experimenting with something like:

CONVERT(DATETIME, RAND() * XXXX)

Though that's probably not a very good way to get random sampling. For some reason this seems to work okay:

SELECT...

Look into sp_msforeachdb. It would work something like this:

sp_msforeachdb 'if ''?'' not in (''master'', ''model'', ''msdb'', ''tempdb'')

update ?.dbo.table1 set column = ''yes'' '

In Enterprise Manager you can view it in Management -> Current Activity -> Process Info. Or use the sp_who procedure.

You'd probably need to use a check constraint on something like that. But because you can't use queries inside check constraints it wouldn't work. I'd think you'll need...