It has to do with the double quotes.  I just recently dealt with this also.  I'm sorry I can't remember the exact circumstances, but when I got rid of the...

SQLBill,

SQL doesn't include the allocated, but unused space in the backup.  As an example, I just backed up my "DBA" database on a test server.

From EM Taskpad -

data file  31MB ,...

EM,

Would you be willing to try something?  Would you manually delete your backup file (or move it, or rename it) before your next backup run?  Continual growth of a backup...

I've seen this when a job executes a "dos" command.  If the "dos" command fails, the job itself doesn't know it, and completes successfully (the job successfully executed the command). Scheduled...

SELECT ISNULL(streetsuffix, '')

The first argument is the column name that might be null, (streetsuffix in SQLBill's example).

The second argument is what you want to replace the null with, ('' in...

Does your S.No column correspond directly to the empno (1, 1001; 2, 1002...)?

If not, you probably want an identity column which will automatically increment.  Otherwise, you could use substring to pull the last digit...

Did you install Developer's edition or Standard or Enterprise???

If Standard or Enterprise, it will only install the client tools on 98.  You need to install Developer's edition.

Steve

SQLBill, you're one step ahead of me this morning!

Here's what I came up with, with the set based update statement. My logic or SQLBill's, either one, would work here...

create table #varchar_tbl...

This will happen if you try to concatenate a string which is all numeric (even if its defined as char or varchar) to character data.  You will need to CAST...

There are a few "gotchas" in manually moving the system folders.  If you're only moving the databases, some of the gotchas go away.  Here's a little "step by step" that...

Well, you should be able to move the databases from one instance to the other.  I think what I would do (if feasible) would be to uninstall my named instance,...

What about your system databases?  Are you backing those up to the same file? 

Does your database only have 2 files?  One data, and one log?

Beyond this, I'm fresh out...

Just add a step to your job with...

EXEC master.dbo.xp_cmdshell 'NET SEND MyUserID ''This is a test'''

Steve

What is the boss's reason for not allowing SQL Agent?  Perhaps if you could tell us, we might be able to offer arguments as to why its necessary for maintenance...

Based on what you've said, I wouldn't think that you would have problems running transaction log backups.  I have numerous servers where I am running tlog backups every 15 minutes,...