Suresh B.

Forum Replies Created

Viewing 15 posts - 751 through 765 (of 1,069 total)

RE: system procedure to get the details of the user defined stored procedure

k.solai 53753 (1/20/2010)
HI All,
Is there any stored procedure to find parameters and detials that has been used in the user defined stored procedures.
sp_help <ProcedureName>
gives the list of parameters...

January 20, 2010 at 3:24 am

#1105923
RE: indexing online vs offline, and setting a database offline

klineandking (1/19/2010)
Thank you for the reply i appreciate it i would like to know what does the online option on/off do, and what are the possible reasons for taking a...

January 20, 2010 at 3:19 am

#1105919
RE: Why the differential backup of the master db is not allowed?

The size of master database is less than 15 MB.
So, taking full backup should not be an issue.

January 12, 2010 at 11:13 pm

#1102882
RE: 'tempdb' is full

Krasavita (1/5/2010)
I got this error message:
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space..
How can I fix...

January 6, 2010 at 2:44 am

#1099417
RE: Query

geervani (1/5/2010)
U can use Between clause or datediff will be best i feel because between will not include the startdate and enddate.
But i am not understanding you question. Each record...

January 5, 2010 at 6:11 am

#1098884
RE: Mirroring : When I try the Failover Option.

Have you tried "ALTER DATABASE database_name SET PARTNER FAILOVER"?

December 31, 2009 at 6:48 am

#1097857
RE: Transaction deadlock error

Use CREATE TYPE instead of SP_ADDTYPE
What is the purpose using a transaction here?

December 24, 2009 at 6:57 am

#1096305
RE: add article to replication without snapshotting entire DB.

Apollo74x (12/21/2009)
Suresh B. (12/17/2009)
Why is a complete snapshot being generated when a new article is added (SQL 2005)?
--------------------------------------------------------------------------------
This is expected behaviour if you have a merge or snapshot publication....

December 21, 2009 at 5:50 am

#1094688
RE: add article to replication without snapshotting entire DB.

Why is a complete snapshot being generated when a new article is added (SQL 2005)?
--------------------------------------------------------------------------------
This is expected behaviour if you have a merge or snapshot publication. If you have...

December 17, 2009 at 10:23 pm

#1093871
RE: Some database missing from maintenance plan

Also, databases in restoring state (log shipping/mirroring?) are displayed...

December 16, 2009 at 11:36 pm

#1093414
RE: Some database missing from maintenance plan

Are you trying to create maintenance plan to backup transaction log and are these databases in simple recovery model?

December 16, 2009 at 10:48 pm

#1093411
RE: error in logshipping job

Grant permission to the SQL Server service account to access the folder.

November 30, 2009 at 3:07 am

#1085306
RE: Distribution database is too big;

Roy Ernest (11/26/2009)
The only thing that could keep it big then is that there are some commands that are that has not been replicated yet. What is your retention period?
Hi...

November 27, 2009 at 2:58 am

#1084819
RE: Distribution database is too big;

Roy Ernest (11/25/2009)
Is it failing? The distribution agent clean up Job?
Try running the the clean up job from the SSMS under your Account and see if it is giving any...

November 26, 2009 at 3:40 am

#1084514
RE: Distribution database is too big;

glugingboulder (11/24/2009)
Just a thought, its possible that the distribution clean up agent is running under a account which doesn’t have permissions or doesn’t exist anymore worth checking.
Therefore isn’t cleaning up...

November 25, 2009 at 6:35 am

#1083951

Viewing 15 posts - 751 through 765 (of 1,069 total)