Viewing 15 posts - 196 through 210 (of 349 total)
I hope you are trying to configure mirroring from the mirror server!!! You need to configure mirroring from the principal server. Refer the below link which will be helpful to...
April 21, 2008 at 6:19 am
[font="Courier New"]Gopi,
I hope VS2005 setup accompanies SQL server 2005 Express edition, hence you can install the same from VS2005 setup. If you can't find it there, you can refer the...
April 21, 2008 at 6:16 am
[font="Courier New"]Try the below piece of code..
Create Trigger Add On Customers After Insert as
declare @number int
Select @number=count(*) from Customers
Print @number
In the above code you have used For trigger and hence...
April 21, 2008 at 6:07 am
[font="Courier New"]Can you check whether you are able to connect to the server using SSMS?? If yes check the process running on the particular database..[/font]
April 21, 2008 at 6:01 am
pbyrum (4/18/2008)
Can you restore a SQL Server Express 2005 database to SQL Server 2005 Enterprise edition? Seems like you can't. I tried it and errors are produced. Any thoughts?
Could you...
April 21, 2008 at 5:59 am
[font="Courier New"]Suji,
Can you check whether you have enabled mail forwarding in your personal mail or check whether the admin has blocked sending mail to third party mail provider other than...
April 8, 2008 at 4:26 am
[font="Courier New"]Hi Luiz,
You can go for SQL 2008 client tools where Microsoft have incorporated the above feature. 🙂
[/font]
April 8, 2008 at 4:23 am
[font="Courier New"]Hi Aboobucker,
Can you check the password for SA used in BCP is correct?? You can check the below link for 18456 error and description based on the severity.
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx[/font]
April 8, 2008 at 4:20 am
[font="Courier New"]Hi,
You can use the below query to check the rollback status.
Kill 139 with statusonly[/font]
April 8, 2008 at 4:16 am
[font="Courier New"]Hi,
You can use the below query to check it
select * from sys.dm_exec_connections
In the output search for num_reads & num_writes columns for the SPID . The output will be one...
April 8, 2008 at 4:13 am
David Bellach (4/4/2008)
How would I find out of 400 plus DTS packages which one references a particular table?Thank you.
[font="Tahoma"]You can use the below query to check.. enter the...
April 6, 2008 at 10:53 pm
Updating system tables in SQL 2005 is possible if you login as Dedicated adminstrator!! DAC has the privilege to update system table. Refer the below link for DAC.
April 6, 2008 at 10:39 pm
[font="Tahoma"]Hi,
What is the total RAM in the server and how much you are going to assign it SQL server??[/font]
April 6, 2008 at 10:32 pm
[font="Tahoma"]Can you execute the below query and check whether user defined messages are there in the server.
select * from sys.messages where message_id=90005
[/font]
April 6, 2008 at 10:29 pm
Viewing 15 posts - 196 through 210 (of 349 total)