Thanks for a chance to pad my posts some more.

I'm currently holding the 61st spot on the all time posts lists, so maybe this will put me over the top...

frankivey (3/12/2009)

---

I just had an interview for a DBA position in CT, the IT Director asked me how do I backup a filegroup. I started to answer "with a...

I made that last post to try to see why my prior post was not showing on my Recent Posts display.

Neither showed up, so I am not sure what was...

You should read about the restore command in SQL Server 2005 Books Online.

http://msdn.microsoft.com/en-us/library/ms178615(SQL.90).aspx

It would be much simpler if you just stored that actual start and end times as datetime datatypes as the actual start datetime and end datetime. Then is is...

Another variation from Lynn's version:

;with

a1 as (

select 1 as N union all select 1 union all select 1 union all select 1 union all

select 1 union all select 1 union...

When you do a backup with append, you are writing a new backup set to the end of the same file. When you restored you probably did not specify...

.

I think this illustrates the problem with the OP picking the best solution:

http://www.sqlservercentral.com/Forums/Topic673876-1291-1.aspx

The best solution is debateable in this situation, but I doubt the OP was really able to judge...

I just assumed you would be...

The account that xp_cmdshell is running under will have to have permission to delete the file.

xp_cmdshell runs under the SQL Server service account if it is executed by a sysadmin...

select

Random_String =

substring(x,(abs(checksum(newid()))%36)+1,1)+

substring(x,(abs(checksum(newid()))%36)+1,1)+

substring(x,(abs(checksum(newid()))%36)+1,1)+

substring(x,(abs(checksum(newid()))%36)+1,1)+

/* and so on for as many characters as needed */

substring(x,(abs(checksum(newid()))%36)+1,1)

from

(select x='0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ') a

Results: ...

Bruce W Cassidy (3/11/2009)

---

[font="Verdana"]Can I put my hand in the air and recommend a Calendar table? It's a specialised version of a Tally/Numbers table, and you can do all...

The last one (For rounding off to the nearest minute) does not work for the entire range of datetime. I have posted a more general method below.

print 'Limited start...

Luke L (3/11/2009)

---

Michael any reason why you like 17530101 as opposed to 0? I'd never really thought to use the 17530101 like you are doing, but I picked up...