Hi there

try this - it might not be exactly what you're looking for, but the concepts could probably be amended to suit your needs. I made a test table and...

you can also use the 'ren' command to rename the backup file, providing xp_cmdshell is enabled (SQL 2005)

xp_cmdshell 'ren \\servername\sharename\Backups\databasename\xyz_db_*.bak new_name.bak'

Then add a job step to restore from 'new_name.bak' etc

just...

hey v

thanks for that script - i'm going to expand it a bit and use it as the basis for writing a reporting services report that will indicate the last...

rbarryyoung (4/7/2008)

Jeff Moden (4/7/2008)

rbarryyoung (4/6/2008)

Good one. 🙂

I was serious about my Uncle though, he really did do all of that...

FWIW

I use 'sequel' when I refer to 'sequel server 2005'

but lapse into the less efficient ess-kue-ell when referring to T-SQL

typical Libran...a bob each way! :w00t:

did you set up a SQL user specifically for the linked server (on the server to be linked) - with permissions on the tables, views etc that need to be...

If you have access to the database via SS Management Studio you can generate the T-SQL needed to drop the table by

right_clicking on the table and selecting:

Script Table as |...

both of these work for me, and return .75

SELECT cast((3.0/4.0) as float)

SELECT cast(3 as float)/cast(4 as float)

...or right-click on "Server objects | Linked Servers" and select "New Linked Server..." then complete the fields in the dialog box.

First of all, I usually set up a dedicated user...

have you checked to ensure that the owner of the maintenance job (the identity that it runs under) has delete permission on the server folder where the backups are stored?

call me ignorant :w00t: - but given that all years start on 1 Jan and end on 31 Dec couldn't these just be explicitly concatenated to the year that was...

Hi Jim

I tested the use of both COUNT and AVG and in both cases the statement returned an INT

COUNT returned the number of records where the bit was set to...

i haven't tried this out...but could you use something like the following to sum a bit field:

SELECT COUNT(CASE WHEN bitfield = 1 THEN 1 ELSE NULL END) as totalBits

FROM myTable

alternatively, nest the four IIF statements inside each other, so that the "false" part of the first IIF, contains the next IIF statement

for example:

IIF (Fields!new_Region.Value=1, "West", IIF (Fields!new_Region.Value=2, "Central", ""))

but...

Open SS Management Studio, then click on Help | about...

a popup window will appear with details of .NET framework etc -

I'm not sure whether this is reporting the version on...