Sql Servers

SQL Query across two sql servers
Need to run a SQL Query across two MSSQL servers. EXEC sp_addlinkedserver @server='GM', @srvproduct='', @provider='SQLOLEDB', @datasrc='Server Name', @catalog ='myDatabase' EXEC sp_addlinkedsrvlogin 'GM', 'false', NULL, 'username', ...

SQL Server - The Most Powerful Database Administration Tool
SQL servers have a large number of powerful tools that facilitate database maintenance, and administration. Among the most important ones are the Enterprise Manager, the Service Manager and the Query analyzer. ...

GFI EventsManager
Auditing allows the user to track and report on SQL server activity such as: Running of SQL statements, altering DB tables, attempts to access data without necessary privileges, etc. This can ensure data in SQL servers is authentic and ...

High Availability and MobiLink
What roles are played by the arbiter, primary and secondary software servers. It's not the role of Joshua's article to go into that detail, and the SQL Anywhere Help does an excellent job once you plow into it. ...

SQL SERVER - 2005 - List all the database
List all the database on SQL Servers. SQL SERVER 2005 System Procedures. EXEC sp_databases EXEC sp_helpdb. SQL 2000 Method still works in SQL Server 2005. SELECT name FROM sys.databases SELECT name FROM sys.sysdatabases.

Lock Pages in Memory, do you really need it?
Over the last few months, we have seen a number of cases where x64 SQL servers have been exhibiting performance issues - either within the Operating System or within SQL. It’s not always the Event ID 333 messages that we’ve been seeing ...

SQL Server - synchronizing database changes across servers
Summary: Can someone recommend a utility (preferably open-source) to ... synchronize changes across servers? ...

SQL 2005 Peer-To-Peer - How to configure failover (If possible)
I originally wanted to configure Peer-To-Peer replication for ... I currently implemented Mirroring in which, when dealing with Web Apps ... and to delegate the loads across multiple SQL servers vs. 1 but is there a ...

[LinkedinChicago] Digest Number 541
Servers were configured to provide maximum redundancy: NLB clustered web servers and clustered backend SQL servers, domain controller and warm standby exchange server • Migrated company website from hosted service to internal servers ...

SQL - ot associated with a trusted SQL Server connection
Expand Microsoft SQL Servers, and then expand SQL Server Group. 3. Right-click the server that you want to change to SQL Server and Windows authentication, and then click Properties. 4. In the SQL Server Properties dialog box, ...