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, 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, 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....
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...
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, 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...
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"....
Hi, For security reasons i need to create an identical login id to "sa" or say "BuiltInAdministrators" with all the system & database rights that...
I have a database say "A" which has around 35 to 40 max. users connected, with around 5 to 7 users doing simulataneous updations or insertion or...
Hi, I have a windows 2000 operating system & sql server 7.0 installed on it. We have upgraded the RAM to 3.8 gb, but i wanted to know whether this...
Hi, I have a doubt regarding locking in sql server. I wanted to know how to determine whether a user is holding a lock row wise, page wise or table...
Iam using the partial concept of log shipping, the backups created during the maintenance plan on the production server is basically been reused for...
Hi, I have a scenario where a scheduled maintenance is made to run daily once, within the schedule maint. is the full & periodic transaction backup...
Hi, I have a new SQL Server 2k database server & i wanted to apply the sp2 patch, can any one plzz tell me any special suggestion to be taken care,...
Hi, I have a daily transaction log backup scheduled in my database maintenance plan. I have been making a very close monitoring on the log growth,...
Hi, We would be shortly going for a complete new setup of database & the OS for a new application, so i need to plan for it. It would be very...
Hi, (1) Can anyone tell me if 2 different sites involved for merge or transactional replication then is it possible to add new fields or edit an...
Hi, I have created a new table & made few transaction which included inserts & updates, my transaction log file size is 3.8 mb & the database...
Separate names with a comma.
