[ add comment ] ( 54 views ) |
( 5 / 1 )Purpose: allow a specific user to backup and restore database, without giving her full access to the filesystem.
As dbo, create the proc below, create the login, grant public access to master, grant dbo access on the needed databases, grant execute on dbo.backupng and dbo.restoreng to sqluser.
As user,
exec backupng @database='somename'Read More...
[ add comment ] ( 4 views ) |
( 2.9 / 8 )use angajare
alter database angajare set recovery simple
backup log angajare with truncate_only
dbcc shrinkfile (angajare_log, 1)
dbcc shrinkfile (angajare, 1)
[ add comment ] ( 4 views ) |
( 0 / 0 )Either
Tools->Folder Options->View-> uncheck Use simple file sharingor
Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\windows\CurrentVersion\Policies\Explorer
Name: Nosecuritytab
Type: REG_DWORD
Value: 0or
convert c: /fs:ntfs[ add comment ] ( 2 views ) |
( 1.5 / 2 )EXEC sp_help_revlogin
Read More...
[ add comment ] ( 26 views ) |
( 2 / 1 )[WebService(Namespace = "http://server")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class myservice : WebService {
[WebMethod]
public string someq(string var1, string var2)
{
return var1+var2;
}
<?php
$wsdl = "http://server/service.asmx?wsdl";
$client = new SoapClient($wsdl);
var_dump($client->someq(array('var1'=>"val1", 'var2'=>"val2")));
?>
[ add comment ] ( 19 views ) |
( 1.5 / 2 )
Calendar