Viewing 15 posts - 61 through 75 (of 155 total)
you can write an insert trigger on the table that records the CURRENT_USER to the same table or another table.
June 2, 2008 at 1:56 am
you can query from the syslogins table
May 29, 2008 at 7:26 am
if you want to see how/who deleted the database, there is a related conversation here -
http://www.sqlservercentral.com/Forums/Topic474543-146-1.aspx
May 29, 2008 at 7:24 am
you can use the dateadd() function
May 29, 2008 at 6:15 am
you can contact your email server administrator to see why the email is not getting delicvered to the recipient address. If you have an internal email address try that; there...
May 29, 2008 at 5:42 am
This link might be useful - http://msdn.microsoft.com/en-us/library/ms190387.aspx
May 28, 2008 at 2:26 am
looks like some disk tuning required as there is high queue length. all other values seem ok
May 21, 2008 at 2:14 am
Work with your application developers to find out the exact reason for frequent logins. Check for things such as connection pool etc.
May 21, 2008 at 2:09 am
For individual logins, strictly use windows authentication; never give shared logins. For code tracking, make use of some version control system. Also, see of schemas can be helpful for your...
May 20, 2008 at 7:39 am
run sp_who2 and see the activities
May 19, 2008 at 6:56 am
Please specify your table structure.
May 9, 2008 at 4:50 am
SQL Server does dynamic memory allocation and deallocation. It will allocate free memory from OS and release when other apps need memory. Are you facing any bottleneck on the application/server,...
May 9, 2008 at 4:48 am
for changing on a single database, you can use the ALTER DATABASE command. For changing the entire instance, you may need to rebuild the master database.
May 8, 2008 at 2:49 am
I would say that taking the identity is the better one. Finding out max() will cause a scan on the column which will slow down the insertion process.
May 7, 2008 at 5:50 am
Viewing 15 posts - 61 through 75 (of 155 total)