Viewing 15 posts - 16 through 30 (of 67 total)
Many thanks Anthony.
June 8, 2012 at 6:25 am
Ok.
Many thanks for you help Anthony.
May 31, 2012 at 5:02 am
Hi Anthony,
Thanks for you reply but this is not valid solution for me. The user have to have permission for open sql server logs from SSMS. For that, as i...
May 31, 2012 at 4:41 am
Many thanks for your answers.
May 25, 2012 at 6:09 am
Yes, i try it.
I need link databases from SSMS with a Visual Studio Database Proyect existing in TFS. For that, exist any alternative to Redgate Source Control? I...
May 21, 2012 at 10:38 am
Hi Haining,
As i said in the previous post i know that i can use Visual Studio 2010 for your SQL Server development projects source control "but the main problem that...
May 21, 2012 at 2:34 am
Ok, thanks John.
March 27, 2012 at 10:10 am
Hi John,
Sorry if I have not explained well.
What I really need is to monitor the FILEGROUP that are FULL in a remote database. To do it i sum the space...
March 27, 2012 at 3:23 am
First thank all,
MyDoggieJessie, your solution is a good aproximation for my needs, but is valid only if database have a FILEGROUP.
In my case i have remote databases with multiple FILEGROUPS...
March 26, 2012 at 10:31 am
Yes, it have.
But it is not the problem. I think that my problem is relationed with FILEPROPERTY function not with db link.
This function sintax is: FILEPROPERTY ( file_name , property...
March 26, 2012 at 8:22 am
Yes i have defined as linked server, but the query:
select
[SPACE_USED_MB] =
convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2))
from REMOTE_SERVER.remote_database.dbo.sysfiles a
always return 'null' value for [SPACE_USED_MB].
The integration services solution you mentioned is not valid solution for me. I...
March 26, 2012 at 7:50 am
Hi all,
I find the problem. The replication was running correctly. The problem was that the source table was been deleted completly and reload completly for a external application. So, the...
February 3, 2012 at 5:12 am
Thanks both for sharing your workaround.
I find other workaround. After the initial suscription creation i changed the property 'schema_option',
"0x01 --> Generates the object creation (CREATE TABLE, CREATE PROCEDURE, and...
December 15, 2011 at 9:26 am
Hi Jo Pattyn,
I receive the same error that 'tajinder42-663112' user: 'ORA-00955: name is already used by an existing object'.
I can create the Oracle suscription correctly, but when i want to...
December 12, 2011 at 7:37 am
Hi Jo Pattyn,
I have the same problem/error (955). The only difference is that in my case i have SQL Server 2008 (not R2) and the suscriber is Oracle 9i database.
Do...
December 12, 2011 at 5:40 am
Viewing 15 posts - 16 through 30 (of 67 total)