Viewing 15 posts - 586 through 600 (of 1,335 total)
also could you run this query against the database andd post the result.
select
* from syscolumns where iscomputed...
July 13, 2007 at 4:54 am
If you have necessary scripts then you can use a tool from ww.SQLFARMS.com to get the details of all servers in one go. Try that.
July 13, 2007 at 4:31 am
Script below will list out table level details for all databases except tempdb.
execute master..sp_MSforeachdb
@command1 ='select ''?'' as "DatabaseName",d.name as "OwnerName",c.name as "TableName",a.name as "ColumnName",b.name as "DataType",a.prec as "Precision",
a.scale as...
July 13, 2007 at 4:28 am
This is usually referred to as Double HOP problem which can be sorted out only with running the sql services in domain account or using a sql id to connect...
July 13, 2007 at 4:27 am
You will not be able to get what you desire but you can get the processor usage stats using perfmon. You can't find which CPU is being used for which...
July 13, 2007 at 4:16 am
Your full database backup will not affect the log backups anyways that you do it as part of logshipping. You can do a full backup and then back that to...
July 13, 2007 at 3:40 am
Put them under filesystem and use the db to store the path of the file.
July 13, 2007 at 3:08 am
Check the sql server service accounts they have to run under domain account not localsystem account.
July 13, 2007 at 3:08 am
Can you post the error that you get when you use Transactional Replication.
July 13, 2007 at 3:05 am
Are you using Be made using current security context and are your services un under local system account then this errors change the services to run under a domain account...
July 13, 2007 at 2:36 am
Change the service account to doamin account for sure this wil get solved out.
July 13, 2007 at 2:25 am
The tuf is Transaction Undo File that will be used to remove uncommited data. if my suggestion does not help then go ahead and reconfigure logshipping.
July 13, 2007 at 2:18 am
Any firewall between the server and the client. Or does your server run firewall services.
July 13, 2007 at 2:13 am
How is your linked server security configured. Whats is the account under which sql server runs.
July 13, 2007 at 2:09 am
Viewing 15 posts - 586 through 600 (of 1,335 total)