also here http://www.mssqltips.com/sqlservertip/1715/scheduling-a-sql-server-profiler-trace/
Is it not working from day one ? then some thing wrong with configuration pls check here for steps to configure db mail...
Pls check these urls http://support.microsoft.com/default.aspx?kbid=246133 http://support.microsoft.com/d...x?scid=kb;en-us;240872...
check here some reasons for tempdb grow http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html
one way would be find out the account details under which the SQL Server is running, connect using that account and add userself as sysadmin account...
Create a linked server on second server instance points to first server database then create views on second server database pointing to first server...
Congratulations Hemant.
If I understand correctly this would help you ---Code below DECLARE @TBL table(AgentID int,DT datetime,AgentStatus int, TeamID varchar(8))...
Does Snapshot Agent has got read and write permission on the folders. here securing snapshot folders...
I would recommend to use full text-search. please check whats on msdn for full text http://msdn.microsoft.com/en-us/library/ms345119(v=sql.90).aspx
for profiler deadlock events please check here http://www.extremeexperts.com/sql/Yukon/DeadLockDetection.aspx
You can create ERD in SQL Server with Database diagram but if want to share ERD you can use third party tools one is Visio please check here...
In case if you are looking for total row counts. here is the script which work in SQL 2000 Declare c cursor for select '['+U.name+'.'+O.Name+']'...
Any index fragmentations ... do you have any maintenance plans to remove index fragmentation?
Hi Ashok, Pivot table might help you. here you can found couple of example that might help you...
Welcome to the Forum! Here is some more usefull information about Surrogate and composite keys http://www.agiledata.org/essays/keys.html Cheers
Nothing wrong writing scripts ourself - that would give you more control. if you have spare time.
If you want to delete them immediately use triggers but please take care when you impliment triggers on production servers they should be tested...
Hi Anita, Nice to hear that problem resolved... Did you see any errors in event logs during that time. Cheers
Hi there, Your database size 1GB I would suggest go for full recovery model. Schedule every day one fullback and couple(hourly) transactional...
Separate names with a comma.
