Hi, I have 2 different servers (dedicated solely for sql server database) with server1 having a total physical memory of 1280 mb & server2 having a...
Wanted to know if we can configure SQL Mail or SQLAgentmail for automating job alerts thru emails using Lotus SMTP server, if yes then any urls or...
Hi, Yaa Thomas i had to change the service account from local system account to a common domain account for both the servers & now the files are...
Below shown is the command iam using exec xp_cmdshell 'copy D:mssqlMSSQLBACKUPfinancialfinancial_backup_device.bak...
Hi, Iam using xp_cmdshell through query analyzer to copy (Using copy utility)a file from one server to another but iam getting "Access denied...
Hi, sp_helprolemember will actually display which user has been granted which role, what actually iam looking for is list of object level...
Hi, How can i view the permissions granted to a role on certain objects thru query analyzer, i mean is there any stored procedure or a query....
Nothing it was just a normal, routine bootup of the server
My one of the SQL Server2000 services is not starting since yesterday after rebooting the server when ever i try to restart the sql server services...
Satya, iam very clear about the truncation of virtual log files, therefore in order to reduce the physical log size i had already executed dbcc...
Hi, I too have a problem with a very large transaction log file size. I have executed a big delete query which took around an hour to execute &...
Hi, Just wanted to know like Oracle, if MSSQL Server too under security does has any provision for :- (1) User password expiry or resetting after...
Hi, There has been a very drastic increase in the size of the tempdb database, it has increased from 190 mb to 7 gb in just 2 hrs, can any one plzz...
Hi Twan, Even i had the same opinion, just wanted to be doubly sure. As far as Client network Utility aliases is concerned, if the server is added...
Hi, Just wanted to know that if a server with OS Windows 2000 & a dedicated MSSQL Server 2000 installed has a change in its ip address after running...
The processor is a very high powered processor(as mentioned above) compared to the number of users using the database, also as i said it happens...
Not possible to run the profiler due to overhead, also this kind of problem occurs once or twice in a month. Average total number of users working...
(1) remote login timeout (s) 0(MIN) 2147483647(MAX) 5(CONFIG_VALUE)5(RUN_VALUE) (2) remote query timeout (s) 0(MIN) 2147483647(MAX)...
Mnay of the application users are getting the error "A time out occured while waiting for memory resources to execute the query. Rerun the query"....
In addition to above mentioned points i would like to add a few more. Since u r not very sure about the reasons of poor performance of your server u...
Separate names with a comma.
