During the migration of SQL databases to a new SQL Server we find that we must rename the SQL Server to the original server name. Renaming a machine on the network is easy eough but we must also run a T-SQL script to rename the server in MS-SQL
To correct @@SERVERNAME for a default instance use [...]
Ever wonder how long your windows system has been online? Found that in Windows you can get to this information by running
net stats srv
From time to time, customers will call in to report “performance problems” that they are having when copying large files from one location to another. By “performance problems”, they mean that the file isn’t copying as fast as they expect. The most common scenario is copying large SQL databases from server to [...]
http://vsteamsystemcentral.com/cs21/blogs/applied_business_intelligence/archive/2007/05/21/ssis-design-pattern-incremental-loads.aspx
Follow the attached instructions to configure Outlook for your email account.
outlook-configuration-settings
http://pathtosharepoint.wordpress.com/2009/01/18/item-id-in-display-and-edit-forms/
WSS 2.0 and SPS 2003: HKLM\Software\Microsoft\Shared Tools\Web Server Extensions\Secure\ConfigDb
WSS 3.0 and MOSS 2007: HKLM\Software\Microsoft\Shared Tools\Web Server Extensions\12.0\Secure\ConfigDb
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
