Béla Rétes's Library tagged → View Popular
Managing, backup, restore Encryption Keys (Reporting Services)
"rskeymgmt -e -fa:\rsdbkey.txt -p<password>"
Check If A Login Exists In SQL Server 2008 | One .Net Way
IF NOT EXISTS(SELECT name FROM sys.server_principals WHERE name = 'testuser'
Script to copy login from one server to another - I.
Szükséges al-sp-k:
http://support.microsoft.com/kb/246133
További módok (DTS, SSIS package)
http://weblogs.sqlteam.com/tarad/archive/2008/06/24/How-to-transfer-SQL-logins-between-SQL-Server-2005-instances.aspx
Service broker and database mail
Script: ALTER DATABASE msdb SET ENABLE_BROKER
Hibaüzenet új profile létrehozásakor:
Database Mail depends on Service Broker. Service Broker is not active in msdb.
Do you want to activate Service Broker in msdb?
SQL Server Urban Legends Discussed
(CSS SQL Server Engineers)
Split Large .MDF File into Separate Files/Locations (move table to another filegroup)
Corran007 hozzászólásában benne van, hogy kell egy táblát másik filegroup-ba tenni, valamint CSAK a text ill bináris adatokat.
mdf ldf
SQL Server 2005 / 2008 - multiple filegroups?
filegroup
data file files mdf ldf
SQL SSIS failed to start (as network service)
Error: The service did not respond to the start or control request in a timely fashion.
----
Could you please check if there are SSIS service reports in event log?
Also, we've seen a case where the service startup timeouts due to network time-outs. The problem occurs while validating file certificates and checking certificate revocation list. If the connection to CRL timeouts (instead of failing the request quickly or succeeding), you may experience this problem. A workaround is to turn off certificate revocation list checking. If you are running SSIS Service as domain user, run IE, open advances internet properties, uncheck 'check certificate revocation list'. If the service is running as Network Service account, you may use this registry file to disable checking certificate revocation list.
Windows Registry Editor Version 5.00
[HKEY_USERS\S-1-5-20\Software\Microsoft\Windows\CurrentVersion\WinTrust\Trust Providers\Software Publishing]
"State"=dword:00023e00
[2009.03.03.] SQL BI konferencia webcastok
Üzleti intelligencia SQL Server 2008-cal (Informatika Tisztán)
Selected Tags
Related Tags
Sponsored Links
Top Contributors
Groups interested in SQL
Diigo is about better ways to research, share and collaborate on information. Learn more »
Join Diigo
