admin or other role

Getting started with SQL Server

Index ‹ SQL Server

- Previous
  - 1
    - hidden views hi , i have created views in database Test, in sqlServer.when i had to export Test to another database Test1, the views become hiddden. i can't see the views and when i try to create them again, i get this msg: There is already an object named 'view1' in the database. so how can i resolve this problem thanks, Tag: admin or other role
  - 2
    - Login Failed for <domain name>\<Machine Name> For some reason , the report server is trying to login as <domainname>\<machine name> - its supposed to be <domain>\<user name> or ASPNET or Network Service Authority - I have no clue why it is pickin gup machine name. Any ideas and how to fix Tag: admin or other role
  - 3
    - adding client server aliases How can I import a client alias list in SQL Server 2005 Configuration Manager The tool provides a way to export a list, but not to import a list. Adding 100 SQL Server instances via the GUI is time consuming and agonizing. Thanks, Justin Randall Tag: admin or other role
  - 4
    - Profiler trace bind variables Hi, Could anyne help me on which options in Profiler could be used to trace the bind variables in DML Given a table, X (col1 number, col2 varchar(10)), where col1 is primary key. Example DML statements: 1) insert into X values (@parameter1, @parameter2) 2) update X set col2 = @parameter2 where col1 = @parameter1 3) delete X where col1 = @parameter1 where @parameter1 and @parameter2 are bind variables. Can Profiler be configured to log the actual values of @parameter1 and @parameter2 in the example statements in trace log Thanks a lot. Tag: admin or other role
  - 5
    - aspnet_wp.exe crashing intermittently I have an application which is providing printing facility using a custom hardware interface device. Whenever a print is required user punches in his ID number into the hardware device, and hence an underlying application gets the event and it calls a managed DLL, which inturn calls the Reporting services webservice on the same server. Problem starts after some days (typically after 2 -3 days), when the server response becomes slow and the aspnet_wp.exe restarts every now and then and after this sequence of happening, finally it crashes with some event in application in event log which reads: The server was unable to allocate from the system nonpaged pool because the pool was empty. Also many times the applications log file reads : There is an error in XML document (1, 948). I think this error starts when the aspnet_wp.exe is restarting, but I am not sure. The server operating system is Windows 2000 SP-4, MS SQL Server 2000 Standard Edition SP-4, MS Reporting Services 2000 Standard SP-2 with .Net Framework v1.1 The Server is running many applications apart from the ones listed above and there is a moderate usage of TCP/IP sockets for communicating with certain hardware devices. Please help me out! Tag: admin or other role
  - 6
    - Problem for Calling A Stored Procedure, Please help. ok,the important checkpoint on sys.procedure -> "exec sp_executesql" check with my sample. you'll get what you want. Hint: as you set output varity with value,you shouldn't return any value. it's useless. Reference with Books Online "sp_executesql" Cheers, Hunt alter proc [sp_test1] (@number varchar(30), @numbera varchar(30), @numberb varchar(30), @Total float output, @balance float output) as declare @table varchar(20) declare @freetotal varchar(20) declare @A float declare @SQL nvarchar(4000); declare @SQLparm nvarchar(500); set @table ='car' set @balance = 3.0 set @freetotal = 2.0 --the section below will be the most important. set @SQLparm = N'@A float output' select @sql = ' select @A = 2.0 FROM ' + @table exec sp_executesql @sql,@SQLparm ,@A output set @Total = @balance / @A + @freetotal go declare @tot float declare @free float exec [sp_test1] '1','2','3',@tot output,@free output print '---' print @tot print @free go Tag: admin or other role
  - 7
    - Data Type Range Hi, When I set a tinyint field as identity, it automatically sets the identity seed as 1. I wonder whether the increment is set to go around in loop. Say, I have the range of 256 numbers for a tinybit. So, an identifier should go from 1 to 255 and then to 0 and then back to 1. Is that right Tag: admin or other role
  - 8
    - A CLR SVF works on my DB instance but not on the other one Hello, I checked the window settings and I found out that the PC where the SQL server instance that gives me problem, use as Date Time zone: (GMT) Casablanca,Monrovia while my Date time zome is Amsterdam, Rome... The DBA told met that all the server in test and production has this setting and it cannot be changed. Could be this the reason of the difference If yes hor an I make my .net code run as it should Thank you Marina B. Tag: admin or other role
  - 9
    - Scheduled Profiler I need to get performance stats off a number of live servers. The stats need to cover the time from 07:00 to 19:00 every day. I'm after things like CPU, Memory and IO, but also I want things like transactions and stored procedures. Can profiler provide this kind of information, and can I schedule the jobs The systems are all running on Windows server 2003 and SQL Server 2005. Thanks Gary Tag: admin or other role
  - 10
    - I can't get SQL Server 2005 Enterprise Edition working I think folks are missing the point here...SQL Server Enterprise Edition can not be installed on Vista, period. Vista is a client operating system and we don't support installing Enterprise Edition on client operating systems. I'm pretty sure this is actually blocked in the installer. You will need to install a different edition if you want to install on Vista. Mike Tag: admin or other role
  - 11
    - Default Constraint on columns Pros and Cons? No disagreement with anyone here. I will add two more cents worth I think that you have to be careful in either way. Since NULL generally means unknown, so where at all possible, I try to use it in that way. If the value is unknown, then use NULL. If the value means I don't have a value, then using 0 or '' makes sense. But, note that those values too often have meaning. '' might mean I don't have a value. 0 is an even worse case. 0 is too often a value that has a specific meaning (I got this for free = 0 dollars, where as NULL would mean you didn't know the price) NULL does have the nasty problem that it also means to people a missing value. Foreign keys are where this is the worst. I do feel it best to have allow NULL when the value is unknown, but have a key value that means "No related value". I understand why you want to avoid nulls, and that is a good thing. Normalization can reduce nulls by breaking down tables to they have only a single meaning, and not a lot of not required values. But the problems with NULL values are generally well enough known and everyone has them, so once you understand the problems of them in one context, they are always the same. Tag: admin or other role
  - 12
    - Exporting reports to PDF i think i have the exact same problem i think. lets say i make a reporting thats A3 size, when i export to PDF the stupid thing renders it as A4 and mashes it over to another page. Tag: admin or other role
  - 13
    - PIVOT sql_variant into underlying dataypes You could probably do this with dynamic SQL, but why do you need this anyhow The data in the sql_variant will be of the proper type, so really wouldn't only the data user be the only one that needs to be concerned with the type of the data Tag: admin or other role
  - 14
    - SSIS - Best way to copy files from one directory to another Linda Cornerstone wrote: ...and press F5 to make the properties window visible... It should be F4 by the way!! -Jamie Tag: admin or other role
  - 15
    - Help exporting data from .csv file to Sql server I tried and it is storing as True in the column value but not as 1 in sql server , i am not aware of how exactly bit datatype works Tag: admin or other role
  - 16
    - ReportServer DB and ReportServerTempDB databases Hi all, Is it possible to cleanup ReportServer DB and ReportServerTempDB by setting the time interval For example, I want data in these two dbs to be deleted automatically after 5 or 10 minutes. How can I do that because as new reports are added and executed data goes on increasing in very short time and hurts performance. Thanks, Prashant Tag: admin or other role
- Next
  - 1
    - Problem with WHERE on ROW_NUMBER when using nested query Just an addition, you can use CTE too. Code Snippet ;with mycte as ( SELECT *, ROW_NUMBER() OVER (ORDER BY Results.AddedDate DESC) AS RowNum FROM ( SELECT DISTINCT p.PollID, p.AddedDate FROM vw_vs_PollsWithVoteCount p JOIN vs_PollOptions o ON p.PollID = o.PollID ) Results ) select * from mycte WHERE RowNum BETWEEN 1 AND 10 Tag: admin or other role
  - 2
    - Help With Join I need to joing two tables together so that all the records are returned from table 1, but only the highest Number record is returned from Table two. Table 1 ID Description Table 2 ID Number Date Data can look something like the following: Table 1 1,Dogs 2,Cats Table 2 1, 1, 11/12/2007 1, 2, 11/13/2007 2, 1, 11/12/2007 2, 2, 11/13/2007 2, 3, 11/13/2007 I would like the following output. 1, Dogs, 1, 2, 11/13/2007 2, Cats, 2, 3, 11/13/2007 Thanks Tag: admin or other role
  - 3
    - Integrate more than one SSIS packages into one package Thanks a lot. You are really a very nice person. The above points solved my problem.Now I can run all the packages at a time.That was my requirement. But it is fine if I'll run this in my machine. If I want to send the package to the client , who require to run the package to update the database at his end( He wants to run only one package. I can give him all the child packages and the mother package after running them at my end ).But how he will be able to set the path for source flat file connection and destination sql server database connection. In the Execute Package Task , is there any option where I can change the source and destination of each package, or is there any other way Thanks a lot again... priyanka Tag: admin or other role
  - 4
    - Side by side installations of SQL2005 Express and Developer editions I have downloaded and installed VS C# Express Orcas beta 1. It appears that Express editons ov VS can only connect to SQL2005 Express and not to a high end edition which I have on my computer. In one of the Orcas forums, it was suggested that I can install SQL2005 Express side by side my high end SQL 2005. To play it safe, I wanted to get a confirmation from this forum before I do that. Is a side-by-side installation ok thanks. Tag: admin or other role
  - 5
    - SSIS - OLE DB - IBM DB2 - SQLDUMP - more dumps than works.... MS DB2 OLE DB Provider - believe it is version 7.0.2413.0 Tag: admin or other role
  - 6
    - Web Data Mining - XMLA Thin Miner Does anyone know where can i get the source code for XMLA Thin Miner It would be useful to my project. Tag: admin or other role
  - 7
    - Verfiying stored procedures The idea is basically that i have written this stored procedure 'procA' which will check if some data (license information) is still valid. 'procA' will be called from within other stored procedures in the database and will determine if the user is allowed to continue or not depending on the return value. I want to ensure that the client is using my version of 'procA' to check the data and have not replaced it with their own stored procedure they have called 'procA' which doesn't check this information and just returns a positive answer. Tag: admin or other role
  - 8
    - SSIS - Dealing with Missing Source Files I want to skip running the SSIS data flow task when the source file is missing. We have a scheduler that copies the source file to the staging area. This SSIS package runs as SQL server job. So when a SSIS package fails due to missing file the remaining steps in the SQL scheduler won't execute. I want to handle the missing source file condition grace fully. Please advise. Thanks in advance. Tag: admin or other role
  - 9
    - Question on attribute relationships and hierarchies on SQL Server 2005 AS Cubes Hi, all experts here, Thank you very much for your kind attention. I am having a question on the attribute relationships and hierarchies in the cubes. It is a must to create the attribute relationships for each levels in any hierarchies in order to let the UDM to get the correct aggregates over different hierarchies (e.g. within hierarchy H, levels are a-b-c-d. Do we have to create the attribute relationships for all the levels , e.g. we have to create the attribute relationship between a and b, b and c, c and d ). Hope my question is clear for your help and I am looking forward to hearing from you shortly. Thanks a lot. With best regards, Yours sincerely, Tag: admin or other role
  - 10
    - License for SSIS When I create SSIS package in 2005 version and I have Server based License, and I use BI services, do i need seperate license for BI services. (SSIS). Thanks, Tag: admin or other role
  - 11
    - Restore all data (system must not exit during restore) using SQL DMO I am taking back up of database ABC (ABC.bak )from Server A. My application need is such that i should be able to restore ABC.bak on server A as well as Server B. My ASP Application is connected to server A. so while restoring back up, db already exists ,I am overwriting the current but different application users are connected to server A. therefore restore fails. What could be the possible solution for this situation Tag: admin or other role
  - 12
    - if sql task is failed what value carry the faliture link Hi, I used sql task and other task, i have only one sql task to capture all the error and send to mail how to find which setp error occured and what failture constraint carry Ezhil Tag: admin or other role
  - 13
    - Does Security Admin have access to create logins using sp_addlogin i have an asp.net web application that uses SQL2000 backend. any users login to the application using a proper SQL login. so each user has unique logins One of the roles within the application is to allow the user to create new logins for the application which inturn creates a SQL login. for this i have been using the following special sp's within an application specific sp:- EXEC sp_addlogin @strUsername, null, 'WEA_MIS', @loginlang EXEC sp_grantdbaccess @strUsername, @strUsername EXEC sp_addrolemember @strRole, @strUsername EXEC sp_password NULL, @strPassword, @strUsername the only way ican get this to run is if the user executing the sp is a member of sys admin, ideally i dont want to be giving anyone access to sys admin. i thought security admin would allow me to do the above but it doesnt. Is there any other ways or ideas to get around this problem Cheers, Craig Tag: admin or other role
  - 14
    - Auto Update Statistics Asynch and sporadic blocking of throughput Over the past week and a half we started experiencing a sporadic slowdown in our production x64 SQL 2005 Ent. Edition server. Users started complaining of slowness then they started getting timeouts. In looking at sp_who2 and perfmon we saw the following during the slow/frozen periods: * Dramatic increase in Perfmon Active Transactions * CPU higher than norm, but not dramatically so * sp_who2 shows a number of spids in SUSPENDED state (and not running waits) * no blocking indicated from sp_who2 * active connections slowly increasing * no disk queuing (or at most some spikes to 1) After a couple of minutes of this we would then see the following: * no more spids in SUSPENDED state * Logins per second spikes dramatically * Active transactions spikes down to "normal levels" * CPU goes high then levels out at moderately higher than normal * active connections slowly decreases back towards normal levels * large spike in lock wait time We turned on the Async Auto Update Statistics option (after testing in our staging environment) on the primary database about a week before we saw this problem. By turning it off we can visually see the problem go away by watching the above metrics. So my question is, What metrics can I use to see the "blocking" or resouce locking that is causing these problems Anyone Thx Ron Tag: admin or other role
  - 15
    - Importing DATE with Timestamp(In a Flat file) Column using SSIS And for future reference, if you have a date like this: 12/31/2007 10:12:14.123 i.e. MM/DD/YYYY HH:MM S.ttt The code is:- (DT_DBTIMESTAMP)(SUBSTRING(DateTime,7,4) + "-" + SUBSTRING(DateTime,1,2) + "-" + SUBSTRING(DateTime,4,2) + " " + SUBSTRING(DateTime,12,12)) Tag: admin or other role
  - 16
    - [rsInvalidExpressionDataType] The Value expression used in field returned a data type that is not valid. I appreciate your help! What I have been trying to do was getting historical data from an OPCHDA-compliant server for plotting on a chart in SSRS report. The return types of the values and timestamps are arrays of double and datetime. For for testing purpose, I put an array with hard-coded numbers and return an object array (using Cobj) from a function in a custom VB.Net assembly using your workaround #2. I was able to return an object array and display the joined default values of the MV parameter in a textbox from the above custom assembly. However, I still couldn't use those values for a field, which would serve as a data source of a line chart in the report. Apparently, an object array is not a valid type for a field. How should I use the object array (default values of the MV parameter) or is there any other way to define the data source of a chart besides fields from a dataset Any related help is welcomed. Thanks! Tag: admin or other role

--Janis

I have one other question. How do you define roles What role(s) are required to fully administer SQL Server What role(s) are required to fully administer a single database in SQL Server

thanks,

Top

Re: admin or other role

Arnie Rowland

In Books Online, look up [fixed server roles] and [fixed database roles].

Those roles are predefined. You can also create your own roles (which only has permissions that you grant to them.)

Full server administration = sysadmin.

Single database administration = db_owner.

Top