Viewing 15 posts - 436 through 450 (of 860 total)
Joy Smith San (5/24/2011)
One of our client is having a server with the following,
Windows 2003 (32 bit).
SQL Server 2005 with SP3 (32 bit)
Memory is 8 GB.
Neither 3Gb nor AWE...
May 25, 2011 at 12:30 am
Check the Backupset and backupmediafamily tables in msdb.
You will get the recent backups.
May 24, 2011 at 7:18 am
river1 (5/24/2011)
I have imported data from excel to SQL Server. SQL created a table named sheet1$ and now i can't make the select from it.
It seems that i can not...
May 24, 2011 at 2:30 am
jimmy 97469 (5/24/2011)
Lately I've installed new server with downgraded to windows 2003 server, and I am using Sql Server 2005 Express with custom internal application. I noticed that the...
May 24, 2011 at 2:24 am
Joy Smith San (5/24/2011)
Windows Server 2003, 32 bit.
SQL Server 2005, Service Pack 3.
8 GB RAM.
Don't I need to enable AWE inorder for SQL Server to use more than 2...
May 24, 2011 at 1:44 am
M A Srinivas (5/24/2011)
Following gives the port
declare @tcpport varchar(1000),@value varchar(250);set @tcpport = 'SOFTWARE\Microsoft\Microsoft...
May 24, 2011 at 1:32 am
Sumanta Roy (5/23/2011)
May 23, 2011 at 7:05 am
kishorechowdary.erp (5/23/2011)
we are using sql server 2008 express edition.in that sql server agents are not installed how i install sql server agents?please give the suggetionsplease see the attachment
You can't use...
May 23, 2011 at 4:44 am
srinath.vanama (5/23/2011)
am facing a sort of problem in database mail, after sending a test mail from Management-->Databasemail-->send test mail.
Later i fired a query like select * from sysmail_log. am...
May 23, 2011 at 4:33 am
Glad to see this. Thanks for your respond.
May 23, 2011 at 3:57 am
beejug1983 (5/22/2011)
Muthukkumaran, thanks for your prompt reply, it really helped me. 🙂
Glad to help you.Your welcome.
May 22, 2011 at 3:13 am
beejug1983 (5/22/2011)
If someone has backed up the databases and placed the backup files to location other than predefined location, how can I know the location of backup files.
Thanks...
May 22, 2011 at 1:49 am
Did you checked the application log and sql server error log for the both servers?
What is error are you getting?
@SQLSoldier is will help you.He is specialist in database mirroring.
May 21, 2011 at 11:25 am
Tiya (5/21/2011)
I am trying to alter a column to make it identity but getting error message:
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'identity'.
Here is my...
May 21, 2011 at 11:08 am
Viewing 15 posts - 436 through 450 (of 860 total)