Viewing 15 posts - 2,731 through 2,745 (of 3,232 total)
Are you in a Domain? If you can login to SQL Server using your Domain Windows account, there is not a problem with your login. But if you've already deleted...
July 26, 2006 at 3:07 pm
I would first check and make sure you did not lose a disk. Then look in the folder where you would normally keep your TempDB and make sure it is...
July 26, 2006 at 2:52 pm
It would help if you could post the DDL for any table listed in your example as well as some sample data.
July 21, 2006 at 2:46 pm
Your challenge here is that you must aggregate the date since you are using a GROUP BY clause. Take a look at your first query,
Select Class, vDate 'Date of...
July 21, 2006 at 2:16 pm
DECLARE @market as varchar(30)
SET @market = 'Test'
IF @market = '-1'
SELECT * FROM VarianceReportTable
ELSE
SELECT * FROM VarianceReportTable
WHERE Market = @market
Or you could use a case statement,...
July 21, 2006 at 1:04 pm
I don't believe you can, in fact, odds are you don't need a cursor. If you post your cursor definition (which you apparently put in up_OMS_getBudgetResults) and a description of...
July 21, 2006 at 9:57 am
Add the Performance>>Execution Plan event. Then scan the trace file for table scans in the textual execution plan.
July 21, 2006 at 9:08 am
When you say MAX, are you looking to find out the maximum number of transactions your SQL Server handled per second over a given period of time, or are you looking for...
July 21, 2006 at 9:05 am
I’m not trying to sound redundant here, but I get the impression that there is still some confusion here. There is an important distinction between...
July 20, 2006 at 12:56 pm
By default, the Windows Administrators group has DBO access to SQL Server via the SQL Server System Administrators server role. This means that by adding a Windows user to the...
July 20, 2006 at 11:14 am
OK, now I'm with you. The Computer Management tool is a Windows component used for managing Windows level access and is completely separate from SQL Server access/security. The local users...
July 20, 2006 at 10:38 am
I'm not clear on what you mean by administrator folder in computer management? Are you referring to EM? Anyway, there is a difference between roles and logins no matter...
July 20, 2006 at 10:07 am
Once your users have access to a database, they will need object level permissions. This can be done by granting the permissions to the user or by creating a Role...
July 20, 2006 at 9:47 am
Adding a user to a SQL Server database is a two step process. First, you must create the login. This is an instance level login. All valid logins for a...
July 20, 2006 at 9:34 am
Your SELECT statement looks good to me. It should return the results that you've described. If it only returns 2 rows as you've said, you can always verify this to...
July 19, 2006 at 12:44 pm
Viewing 15 posts - 2,731 through 2,745 (of 3,232 total)