Viewing 15 posts - 526 through 540 (of 707 total)
Could you pls post the function you have written.?
Am not clear on the exact requirement.
August 25, 2009 at 11:42 pm
Are you a DBA..?
Transation log should not be deleted.
Backup the LOG and Shrink it. Think that's what you need.
Go through the link which Gail has mentioned.
August 25, 2009 at 3:11 am
You executed sp_helpdb ('DBname') and got LOG file size as "160832 KB (Size) growth (10%)" i.e 157.0625 MB
Ankur, I dint understand this point. Can you pls clarify.
Thanks for your...
August 25, 2009 at 3:02 am
sp_dropserver 'USDC-ICCMDBDEV'
go
sp_addserver 'SOM-DB-ICCM', local
go
Might work.
August 24, 2009 at 3:44 am
fminns (8/24/2009)[/b]
I'm trying to configure log shipping for a database and am not able to because the srvname entry in the sys.sysservers table is not the same as the...
August 24, 2009 at 3:37 am
You can add more tasks such as Execute Transact SQL Script, which I guess is what you are tryign to achieve.
He wanted "Execute Process task or Script task" right.?
August 21, 2009 at 8:12 am
Done... I asked network administrator to open port 1433 in firewall client. It's working now.
Thanks.
August 21, 2009 at 7:40 am
Done... I asked network administrator to open port 1433 in firewall client. It's working now.
Thanks.
August 21, 2009 at 7:40 am
suleman_3014 (8/21/2009)
could paste me the screen shot of the error you see ?
A network-related or instance-specific error occured while establishing a connection to SQL server.
The server was not found or...
August 21, 2009 at 7:17 am
Is your desktop on the same network as the other developers desk ?
Yes. It is in same network.
As I had mentioned, I am able to connect to TEST server...
August 21, 2009 at 6:11 am
No luck. Even instance name not working...
August 21, 2009 at 6:07 am
OK I will try that n revert.
But why only my SQL is not appearing in list. Here we have installed SQL server in more than 50 desktops (for developers testing...
August 21, 2009 at 5:57 am
Viewing 15 posts - 526 through 540 (of 707 total)