2010-03-09T22:56:19Z Administrator Copyright 2010, Administrator SPHPBLOG http://razvan.cosma.name/weblog/index.php?entry=entry100130-020013 2010-01-30T00:00:00Z 2010-01-30T00:00:00Z 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'



exec sp_configure 'show advanced options',1
reconfigure
go
exec sp_configure 'xp_cmdshell',1
reconfigure
go
EXEC sp_xp_cmdshell_proxy_account 'domain\user', 'password' --use a restricted user for this one
go
set nocount on
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[backupng]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[backupng]
go
create procedure [dbo].[backupng] ( @database sysname ) as
declare @rootdir varchar(128)
--allow writes only in a specific dir
select @rootdir='d:\sites\sqlbackups\'
declare @cmd varchar(128)
declare @result varchar(128)
SELECT @cmd = 'dir ' + @rootdir
EXEC @result = master.dbo.xp_cmdshell @cmd, no_output
IF @result <> 0
BEGIN
SELECT @cmd = 'mkdir ' + @rootdir
EXEC master.dbo.xp_cmdshell @cmd, NO_OUTPUT
END
declare @db varchar(128)
select @db = replace(replace(replace(@database,':',''),'''',''),'\','')
declare @now varchar(14)
declare @filename varchar(128)
select @now = replace(replace(replace(convert(varchar(50), getdate(), 120), '-', ''), ' ', ''), ':', '')
select @filename = @rootdir + @db + '_' + @now + '.bak'
BACKUP DATABASE @db TO DISK = @filename WITH INIT
go

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[restoreng]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[restoreng]
go
create procedure [dbo].[restoreng] ( @database sysname ) as
declare @rootdir varchar(128)
select @rootdir='d:\sites\sqlbackups\'
declare @cmd varchar(128)
declare @result varchar(128)
declare @db varchar(128)
select @db = replace(replace(replace(@database,':',''),'''',''),'\','')
declare @now varchar(14)
declare @filename varchar(128)
select @filename = @rootdir + @db + '.bak'
--EXEC sp_dboption @db, 'single user', 'true'
--drop database @db
--restore DATABASE @db from disk = @filename
go

]]> http://razvan.cosma.name/weblog/index.php?entry=entry100128-172050 2010-01-28T00:00:00Z 2010-01-28T00:00:00Z alter database angajare set recovery simple
backup log angajare with truncate_only
dbcc shrinkfile (angajare_log, 1)
dbcc shrinkfile (angajare, 1)
]]> http://razvan.cosma.name/weblog/index.php?entry=entry100126-194848 2010-01-26T00:00:00Z 2010-01-26T00:00:00Z Tools->Folder Options->View-> uncheck Use simple file sharing
or
Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\windows\CurrentVersion\Policies\Explorer
Name: Nosecuritytab
Type: REG_DWORD
Value: 0
or
convert c: /fs:ntfs]]> http://razvan.cosma.name/weblog/index.php?entry=entry100125-135454 2010-01-25T00:00:00Z 2010-01-25T00:00:00Z
USE master
GO
IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL
DROP PROCEDURE sp_hexadecimal
GO
CREATE PROCEDURE sp_hexadecimal
@binvalue varbinary(256),
@hexvalue varchar (514) OUTPUT
AS
DECLARE @charvalue varchar (514)
DECLARE @i int
DECLARE @length int
DECLARE @hexstring char(16)
SELECT @charvalue = '0x'
SELECT @i = 1
SELECT @length = DATALENGTH (@binvalue)
SELECT @hexstring = '0123456789ABCDEF'
WHILE (@i <= @length)
BEGIN
DECLARE @tempint int
DECLARE @firstint int
DECLARE @secondint int
SELECT @tempint = CONVERT(int, SUBSTRING(@binvalue,@i,1))
SELECT @firstint = FLOOR(@tempint/16)
SELECT @secondint = @tempint - (@firstint*16)
SELECT @charvalue = @charvalue +
SUBSTRING(@hexstring, @firstint+1, 1) +
SUBSTRING(@hexstring, @secondint+1, 1)
SELECT @i = @i + 1
END

SELECT @hexvalue = @charvalue
GO

IF OBJECT_ID ('sp_help_revlogin') IS NOT NULL
DROP PROCEDURE sp_help_revlogin
GO
CREATE PROCEDURE sp_help_revlogin @login_name sysname = NULL AS
DECLARE @name sysname
DECLARE @type varchar (1)
DECLARE @hasaccess int
DECLARE @denylogin int
DECLARE @is_disabled int
DECLARE @PWD_varbinary varbinary (256)
DECLARE @PWD_string varchar (514)
DECLARE @SID_varbinary varbinary (85)
DECLARE @SID_string varchar (514)
DECLARE @tmpstr varchar (1024)
DECLARE @is_policy_checked varchar (3)
DECLARE @is_expiration_checked varchar (3)

DECLARE @defaultdb sysname

IF (@login_name IS NULL)
DECLARE login_curs CURSOR FOR

SELECT p.sid, p.name, p.type, p.is_disabled, p.default_database_name, l.hasaccess, l.denylogin FROM
sys.server_principals p LEFT JOIN sys.syslogins l
ON ( l.name = p.name ) WHERE p.type IN ( 'S', 'G', 'U' ) AND p.name <> 'sa' and p.name not like '%\%'
ELSE
DECLARE login_curs CURSOR FOR


SELECT p.sid, p.name, p.type, p.is_disabled, p.default_database_name, l.hasaccess, l.denylogin FROM
sys.server_principals p LEFT JOIN sys.syslogins l
ON ( l.name = p.name ) WHERE p.type IN ( 'S', 'G', 'U' ) AND p.name = @login_name
OPEN login_curs

FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @type, @is_disabled, @defaultdb, @hasaccess, @denylogin
IF (@@fetch_status = -1)
BEGIN
PRINT 'No login(s) found.'
CLOSE login_curs
DEALLOCATE login_curs
RETURN -1
END
SET @tmpstr = '/* sp_help_revlogin script '
PRINT @tmpstr
SET @tmpstr = '** Generated ' + CONVERT (varchar, GETDATE()) + ' on ' + @@SERVERNAME + ' */'
PRINT @tmpstr
PRINT ''
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
PRINT ''
SET @tmpstr = '-- Login: ' + @name
PRINT @tmpstr
IF (@type IN ( 'G', 'U'))
BEGIN -- NT authenticated account/group

SET @tmpstr = 'CREATE LOGIN ' + QUOTENAME( @name ) + ' FROM WINDOWS WITH DEFAULT_DATABASE = [' + @defaultdb + ']'
END
ELSE BEGIN -- SQL Server authentication
-- obtain password and sid
SET @PWD_varbinary = CAST( LOGINPROPERTY( @name, 'PasswordHash' ) AS varbinary (256) )
EXEC sp_hexadecimal @PWD_varbinary, @PWD_string OUT
EXEC sp_hexadecimal @SID_varbinary,@SID_string OUT

-- obtain password policy state
SELECT @is_policy_checked = CASE is_policy_checked WHEN 1 THEN 'ON' WHEN 0 THEN 'OFF' ELSE NULL END FROM sys.sql_logins WHERE name = @name
SELECT @is_expiration_checked = CASE is_expiration_checked WHEN 1 THEN 'ON' WHEN 0 THEN 'OFF' ELSE NULL END FROM sys.sql_logins WHERE name = @name

SET @tmpstr = 'CREATE LOGIN ' + QUOTENAME( @name ) + ' WITH PASSWORD = ' + @PWD_string + ' HASHED, SID = ' + @SID_string + ', DEFAULT_DATABASE = [' + @defaultdb + ']'

IF ( @is_policy_checked IS NOT NULL )
BEGIN
SET @tmpstr = @tmpstr + ', CHECK_POLICY = ' + @is_policy_checked
END
IF ( @is_expiration_checked IS NOT NULL )
BEGIN
SET @tmpstr = @tmpstr + ', CHECK_EXPIRATION = ' + @is_expiration_checked
END
END
IF (@denylogin = 1)
BEGIN -- login is denied access
SET @tmpstr = @tmpstr + '; DENY CONNECT SQL TO ' + QUOTENAME( @name )
END
ELSE IF (@hasaccess = 0)
BEGIN -- login exists but does not have access
SET @tmpstr = @tmpstr + '; REVOKE CONNECT SQL TO ' + QUOTENAME( @name )
END
IF (@is_disabled = 1)
BEGIN -- login is disabled
SET @tmpstr = @tmpstr + '; ALTER LOGIN ' + QUOTENAME( @name ) + ' DISABLE'
END
PRINT @tmpstr
END

FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @type, @is_disabled, @defaultdb, @hasaccess, @denylogin
END
CLOSE login_curs
DEALLOCATE login_curs
RETURN 0
GO
]]> http://razvan.cosma.name/weblog/index.php?entry=entry100104-152912 2010-01-04T00:00:00Z 2010-01-04T00:00:00Z [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")));
?>
]]> http://razvan.cosma.name/weblog/index.php?entry=entry091219-224424 2009-12-19T00:00:00Z 2009-12-19T00:00:00Z http://razvan.cosma.name/weblog/index.php?entry=entry091212-003432 2009-12-11T00:00:00Z 2009-12-11T00:00:00Z DECLARE @db nvarchar(50)
set @db='my.datab.name'
--close all connections
DECLARE @SPId int
DECLARE @CMD varchar(100)
DECLARE my_cursor CURSOR FAST_FORWARD FOR
SELECT SPId FROM MASTER..SysProcesses
WHERE DBId = DB_ID(@db) AND SPId <> @@SPId
OPEN my_cursor
FETCH NEXT FROM my_cursor INTO @SPId
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @CMD = 'KILL ' + CAST(@SPId AS varchar(10))
EXEC (@CMD)
FETCH NEXT FROM my_cursor INTO @SPId
END
CLOSE my_cursor
DEALLOCATE my_cursor

exec('ALTER DATABASE ['+ @db +'] SET SINGLE_USER WITH NO_WAIT')
dbcc checkdb(@db, REPAIR_ALLOW_DATA_LOSS)
exec('ALTER DATABASE ['+ @db +'] SET MULTI_USER WITH NO_WAIT')
--try another dbcc checkdb afterwards to be sure it's fixed]]> http://razvan.cosma.name/weblog/index.php?entry=entry091209-105858 2009-12-09T00:00:00Z 2009-12-09T00:00:00Z 2. %windir%\system32\cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
3. %windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -i
4. Enable the 32-bit ASP.net extension from IIS Manager]]> http://razvan.cosma.name/weblog/index.php?entry=entry091203-164219 2009-12-03T00:00:00Z 2009-12-03T00:00:00Z

[DllImport("KERNEL32.DLL", EntryPoint = "GetPrivateProfileStringW",
SetLastError = true,
CharSet = CharSet.Unicode, ExactSpelling = true,
CallingConvention = CallingConvention.StdCall)]
private static extern int GetPrivateProfileString(
string lpAppName,
string lpKeyName,
string lpDefault,
string lpReturnString,
int nSize,
string lpFilename);
[DllImport("KERNEL32.DLL", EntryPoint = "WritePrivateProfileStringW",
SetLastError = true,
CharSet = CharSet.Unicode, ExactSpelling = true,
CallingConvention = CallingConvention.StdCall)]
private static extern int WritePrivateProfileString(
string lpAppName,
string lpKeyName,
string lpString,
string lpFilename);

private static List<string> GetCategories(string iniFile)
{
string returnString = new string(' ', 65536);
GetPrivateProfileString(null, null, null, returnString, 65536, iniFile);
List<string> result = new List<string>(returnString.Split('\0'));
result.RemoveRange(result.Count - 2, 2);
return result;
}
private static List<string> GetKeys(string iniFile, string category)
{
string returnString = new string(' ', 32768);
GetPrivateProfileString(category, null, null, returnString, 32768, iniFile);
List<string> result = new List<string>(returnString.Split('\0'));
result.RemoveRange(result.Count-2,2);
return result;
}

private static string GetIniFileString(string iniFile, string category, string key, string defaultValue)
{
string returnString = new string(' ', 1024);
GetPrivateProfileString(category, key, defaultValue, returnString, 1024, iniFile);
return returnString.Split('\0')[0];
}


and use like this:

string inifile = System.AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini"; string defaultValue = "???";
List<string> categories = GetCategories(inifile);
foreach (string c in categories)
{
List<string> keys = GetKeys(inifile, c);
foreach .. val = GetIniFileString(inifile, c, k, defaultValue);
}

WritePrivateProfileString("GLOBAL", "Stuff", "The content of that stuff", "MyIniFile.ini");

Picked from here
]]> http://razvan.cosma.name/weblog/index.php?entry=entry091125-165314 2009-11-25T00:00:00Z 2009-11-25T00:00:00Z ]]> http://razvan.cosma.name/weblog/index.php?entry=entry091125-134614 2009-11-25T00:00:00Z 2009-11-25T00:00:00Z Windows Resource Kit
Option 2: Start->Run->MMC->Add snap-in->Group policy->Local computer->Computer configuration->Windows settings->Scripts
The applications will run as Local System
]]> http://razvan.cosma.name/weblog/index.php?entry=entry091113-161135 2009-11-13T00:00:00Z 2009-11-13T00:00:00Z