Viewing 15 posts - 226 through 240 (of 245 total)
So whats the proble it must not show column1 when give COLUMN1.
I dont think there is an option for that.
March 26, 2009 at 2:54 am
1. Check OS Event Logs, SQL Server Logs, and Security Logs for unusual events.
2. Verify that all scheduled jobs have run successfully.
3. Confirm that backups have been made and successfully...
March 26, 2009 at 2:51 am
Using Maintenance Plane Wizard there is an option to give separate schedule for each task as subplans.
So What i suggest is that we schedule subplan1 A full backup plan on...
March 25, 2009 at 11:19 pm
What is the error shown in database mail log.
March 25, 2009 at 10:29 pm
Right click on SQL Server Agent -> Properties -> Alert System -> Mail Session
check enable mail profile
select Mail system as Database Mail in drop down
And Mail Profile the as...
March 25, 2009 at 10:15 pm
SQL Server Agent service which controls the jobs
March 25, 2009 at 9:43 pm
That is the connection between the two jobs in your maintenance plan .
On success/failure/completion of the first job the work flows to the next job.
March 25, 2009 at 9:41 pm
Shared locks (S)
Shared locks are held on data being read under the pessimistic concurrency model. While a shared lock is being held other transactions can read but can't modify locked...
March 25, 2009 at 4:52 am
Locking Hints
ROWLOCK
Use row-level locks when reading or modifying data.
PAGLOCK
Use page-level locks when reading or modifying data.
TABLOCK
Use a table lock when reading or modifying data.
DBLOCK
Use a database lock when reading...
March 25, 2009 at 4:43 am
http://msdn.microsoft.com/en-us/library/ms811006.aspx
go through the above link
March 25, 2009 at 4:26 am
Actually usin Maintenance plan Wizard you separately schedule multiple maintenance task.
While creating the maintenance cleanup task did you give the folder path and file extensions properly.
Did you set on success...
March 25, 2009 at 3:45 am
Did you check if the services are started
March 25, 2009 at 3:24 am
First get this software SQLServer2005_SSMS ie Sql Server Management studio
Make sure you have enabled tcp/ip for sql server and port 1433 also enable local and remote connection in surface area...
March 25, 2009 at 3:20 am
The 15-second threshold is currently not adjustable. While not recommended, stalled and stuck I/O detection can be completely disabled with trace flag 830. Set the startup parameter –T830 to disable...
March 25, 2009 at 2:48 am
Yes if are going to keep the compatibility level as 80 you don't have to change
March 25, 2009 at 2:41 am
Viewing 15 posts - 226 through 240 (of 245 total)