Search results for query: *

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...

Your CREATE TABLE is still showing MaritialStatus as being CHAR(1). Make it CHAR(10). Also check your data in the spreadsheet for column 5. That should be Gender and it looks like you have something longer than one character there. Your choices are to make the columns in the table longer or...

It depends on what you are trying to do: If you are just trying to retrieve data a certain way, use DaveInIowa's suggestion. If you are trying to update data in a table, use gmmastros' suggestion as part of an update statement. -SQLBill The following is part of my signature block and is only...

Here's something to consider. Every time you code has GETDATE() in it, SQL Server has to figure out what that value is. It can change during your code run (maybe only by less than a second...but it still is changing). Try this instead: DECLARE @mydate DATETIME SET @mydate = GETDATE() <some...

One thing to remember when using +. It means two different things which depend on how it is used. Add: when used with numbers. SELECT 1 + 1 That will return: 2 Concatenate: when used with strings. SELECT 'Hello' + ' World' That will return: Hello World (notice the space between the ' and...

You could also run this in each database to find out which one has the view. SELECT * FROM sys.objects WHERE type = 'v' -SQLBill The following is part of my signature block and is only intended to be informational. Posting advice: FAQ481-4875