Viewing 15 posts - 31 through 45 (of 156 total)
I just acccessed url and it worked.. Please try again...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 23, 2010 at 11:50 pm
Yes, You can.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 23, 2010 at 9:24 am
Mahesh
I misunderstood your question. Hence option that I suggested is not something that you were looking for. If I understand your question now correctly then you are looking for an...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 23, 2010 at 9:21 am
Use MCALL in Update delivery format option. It will pass binary value that is last parameter of procedure used
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 21, 2010 at 2:14 pm
Proxy accounts corresponds to a security credential that has admin rights. You can refer http://msdn.microsoft.com/en-us/library/ms190698.aspx for creating Proxy
Proxy will resolve issue. In fact you have two choice either create proxy...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 21, 2010 at 2:07 pm
It appears that Domain/uname is not sysadmin. If that is the case then you need to create proxy account
Or Grant Domain/uname an Admin access and ensure same is there...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 20, 2010 at 2:22 am
it appears that you are trying to view property using an account that does not have dbo or above level permission.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
November 2, 2009 at 10:44 pm
1. Which Version of SQL Server you are using?
2. Are you sure you do not have any slow running query in your system?
3. If 2 is correct then...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
November 2, 2009 at 10:41 pm
Do you have other drive available on server with free space? If yes then you can follow following steps to resolve issue without restarting sql server:
1. Alter tempdb and add...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
November 2, 2009 at 12:01 am
Another way is to use following query
select * from sys.sysconstraints
where status = 4
[font="Verdana"]--www.sqlvillage.com[/size][/font]
October 30, 2009 at 4:21 pm
not sure if you are using... but if using 2008 then you can implement CDC and get only changed data transfer.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
October 30, 2009 at 10:27 am
You can try using "SQL Server performance Dashboard" tool from microsoft.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
October 30, 2009 at 10:21 am
If you need to do this frequently then best way to do this with SSIS using its fast load option.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
October 30, 2009 at 10:17 am
I have done couple of projects for SQL Server 2008 including Clustering and VM. There are some firewall rule policy that your System Admin needs to take care of after...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
October 21, 2009 at 1:02 am
You can't use same name.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
October 9, 2009 at 10:18 am
Viewing 15 posts - 31 through 45 (of 156 total)