-
2010
-
January
-
restart microsoft download manager
30/01/10
%windir%\Downloaded Program Files\TransferMgr.exe -
Grant restricted backup and restore privileges
28/01/10
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.< -
sql 2005 reduce file sizes
26/01/10
use angajare
alter database angajare set recovery simple
backup log angajare with truncate_only
dbcc shrinkfile (angajare_log, 1)
dbcc shrinkfile (angajare, 1)
-
where's the security tab?
25/01/10
Either
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 -
How to copy SQL users to another server
04/01/10
EXEC sp_help_revlogin
[more]
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 @char
-
restart microsoft download manager
-
January
- 2009
- 2008
Calendar