Recent content by SQLBill

Yet another option if this has to be done for several users...create views of just the tables/data the users need to see and only give them access to the views. But Frederico's suggestion may be the best. Create a role in the database like LimitedUser. Grant it the appropriate rights to the...

I'm a little late on this but the issue was most likely due to the double quotes ("). Those should have been single quotes (') or square brackets, which is why Frederico's suggestion worked. -SQLBill The following is part of my signature block and is only intended to be informational. Posting...

When the database was created what was the size used for the log file? Maybe you can't shrink it because that is the size someone decided the log file should be? -SQLBill The following is part of my signature block and is only intended to be informational. Posting advice: FAQ481-4875

You can make the job owned by them (or an app login they have access to); anyone can run jobs they own. You can make them members of the appropriate SQL Server Agent role(s). -SQLBill The following is part of my signature block and is only intended to be informational. Posting advice...

Not that I'm aware of, but one solution is to create a "staging" table with the column set to what the true length is, then use TSQL to copy the data from the staging table to the actual table while converting the stock price to the length you really want. -SQLBill The following is part of my...

Since this is for Oracle, you should post it in one of the Oracle forums then and not in this Microsoft SQL Server forum. -SQLBill The following is part of my signature block and is only intended to be informational. Posting advice: FAQ481-4875

Are you running this in Oracle or Microsoft SQL Server (which is what this forum is for)? It seems to be Oracle from the error message: ORA-00933. The semi-colon is a valid end of script for Microsoft SQL Server 2005 and above, but it might not be acceptable for Oracle. -SQLBill The...

Is this a script that is always run the same way? If so, you could put it into a job and have the job output the results where you want. -SQLBill The following is part of my signature block and is only intended to be informational. Posting advice: FAQ481-4875

Okay, let's get back to the main issue....SQL Server Agent not running. Right click on SQL Server Agent. Select Properties. Is "Auto restart SQL Server Agent if it stops unexpectedly" checked or unchecked? If it is unchecked, try checking it. Also, that screen will give you the path to the...

try this....change the default database to MSDB, then grant it db_datareader. See if that helps. -SQLBill The following is part of my signature block and is only intended to be informational. Posting advice: FAQ481-4875

In the Login Properties window, click on User Mappings. Scroll down to MSDB. What permissions does that user have for MSDB? -SQLBill The following is part of my signature block and is only intended to be informational. Posting advice: FAQ481-4875

No. You don't have enough information to figure out growth by temperature based on one month of data. You would need to gather enough data (temperature and size) to first come up with a growth table showing temperature and growth. Then you would join to that table to determine the size of a...

I'm not big on Linked Servers, but the way think about it is by the name...you are linking servers not databases or tables. Once you link the servers, you control access on the linked server by only granting the login permission to what they need to see. -SQLBill The following is part of my...

I think you are trying to backup part of a database, not the query itself. You can't do that. You can: 1. Backup the entire database or 2. Copy a full table or part of a table. If this is what you want to do...and it does look like this is what you are asking....then danlout144's suggestion...

Using Tamar's code, here' how you would add the WHERE clause: UPDATE ACCOUNTS SET AccountID = ARCustomerNumber, ARCustomerNumber = ' ' WHERE ACCOUNTTYPE = 'CSA Customer' Now for: Copy the data from the ACCOUNTNAME to the ARCustomerNumber field? You don't give us...