Skip to main content

Béla Rétes's Library tagged SQL   View Popular

28 Jul 09

Check If A Login Exists In SQL Server 2008 | One .Net Way

IF NOT EXISTS(SELECT name FROM sys.server_principals WHERE name = 'testuser'

www.onedotnetway.com/ogin-exists-in-sql-server-2008 - Preview

SQL script Programozás

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

www.dbforums.com/...-login-one-server-another.html - Preview

SQL script howto tippek admin config

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?

www.sqlservercentral.com/...1025.aspx - Preview

SQL howto tippek script

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

www.tek-tips.com/viewthread.cfm - Preview

SQL best_practices howto admin

31 Mar 09

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

connect.microsoft.com/...ViewFeedback.aspx - Preview

SQL howto config admin microsoft server

28 Mar 09

[2009.03.03.] SQL BI konferencia webcastok

Üzleti intelligencia SQL Server 2008-cal (Informatika Tisztán)

www.microsoft.com/...article - Preview

SQL tutorial webcast online tanfolyam tanulás admin video

1 - 20 of 215 Next › Last »
Showing 20 items per page

Diigo is about better ways to research, share and collaborate on information. Learn more »

Join Diigo