this is a script I use to generate a script of the security for restores... basically I use this when I am asked to "restore the database, but leave all...

for one example, if ALLOW_PAGE_LOCKS=OFF, you are likely to encounter errors performing index maintenance like rebuilds or reorgs.

sorry- didnt refresh in time.. glad you have your answer

interesting... when I attempted to use convert from text, like:

create table test(

datefield text null)

on [primary]

insert test values ('7/11/2011')

select Max (convert...

this seems to work:

create table test(

datefield text null)

on [primary]

insert test values ('7/11/2011')

insert test values ('7/10/2011')

insert test values ('7/9/2011')

select MIN (cast(cast (datefield as varchar)as date) )from test

gotcha- that makes sense... essentially I was trying to explain (enthusiastically) that even in simple mode, the transaction log is used during the full backup to track changes made since...

For the record, I thought it was deprecated and gave him that answer on purpose!... didnt realize though that it is not technically a "self join".

agree this sounds like homework... appreciate your resourcefulness. Hope your professor doesnt check sql server central.

select a.country,a.zone,a.branch,a.user1 as 'user', b.user1 as user2

from test a, test b

where a.user1='farooq'

and b.user1='jawwad'

ah, so you tried to trick us! not very nice... how about sharing the whole query and having a look a the execution plans for both?

so when you...

Well, this might be silly to ask, but is the >=1 returning only a few records while the other options return many more records? i.e, is your first query...

as often happens, I figure it out shortly after posting:

select distinct (LEFT(physical_name, (LEN(physical_name)-(CHARINDEX('\', REVERSE(physical_name)) - 1)))) as path

FROM master.sys.master_files

in case anyone cares, this is how I did it. Save the following script and call it from sqlcmd with output to a file. this script genereates the netbackup...

No- it was never local system. It was first a domain account with the correct rights to dynamically create SPNs, then another domain account which did not have those...

This application is a little different that our normal support model. The application group is a bit more knowledgeable and works closely with the database. They accept some...

I figured it out. Here is what happened:

The app folks changed the SQL Service account, but did so using "services.msc" not SQL configuration manager. I believe that caused...

Just rebooted all three servers to clear the cache... same result. That article is good- I've seen it before- but it deals mostly with Kerberos problems. In this...