(0.01 seconds) Articles (1327) |<First /67 Next>> Last >| Maintenance Plan - General beginner questions 4 1105 (9/9/2010 3:41:03 PM) Utf Morning, I am creating my first maintenance job today and I have some general questions about the order of steps regarding the db and t-logs. I am looking to create 3 jobs that run nightly on a productio... SQL 2008 linked server to VFP 7.x tables?? 0 1090 (9/9/2010 6:15:58 PM) tom12010 Does a good reference or tutorial exist for this topic?? We only need READ access from SQL 2008 to the VFP tables -- various select queries for reporting etc. Should this be done by first installing the ... SQL 2000 to SQL 2005 Upgrade. Upgrade advisor Errors 2 1553 (1/14/2010 5:03:01 PM) Utf I am running the SQL 2005 Upgrade advisor on a SQL 2000 box and I keep getting the following messages on the following objects. Timeout expired. The timeout period elapsed prior to completion of the ope... SQL help 1 736 (9/9/2010 3:38:44 AM) Jami Dear All Sql 2000 following is DDL and sample data CREATE TABLE #tmp ( Fname VARCHAR(20), lname varchar (10), Status char(1) ) go INSERT INTO #tmp VALUES ('John','Terry',null) INSER... Log Shipping and backups 1 820 (9/8/2010 8:59:19 PM) GiJeet Hello, I've read where once you setup log shipping in SQL2008 you can't take any additional backups from your primary server. What's with this? We have a dev environment and need to restore production db o... Disk Setup for SQL Server 2 700 (9/7/2010 1:32:09 PM) Matthew I'm looking to install a SQL Server into my virtual infrastructure. My hardware is setup like this... virtual host with 10Gb ethernet, SAN with 12 drives setup in a raid 5 (I believe 64k clusters). I've... Unique Identification of a database server 2 918 (9/6/2010 11:38:32 AM) schaf Hi All, I'm looking for a unique identification of my MS SSQLServer 2008 R2. The DB_ID() is not enough, because I would like to have a unique number/Id/GUID/MACAddress or similar of my SQLServer. This Id mus... Performance :Lock Wait Time 0 1372 (9/7/2010 12:56:03 PM) Utf Hi at all Do you know when the Lock Wait Time increases? What are the possible situations that allow it to increment ? Tk u very much. PIT ... Linked server and sensitive to register name 1 1020 (9/6/2010 10:47:03 AM) Utf I try to work with table with "sensitive to register" name through Linked Server (MSSQL 2005/2008) and get the problem with UPDATE statement. Reason: MSSQL generates UPDATE statement with "un-quoted" table... Variuous ways of deleting Job history and deleting the job history log files from the folder 3 1307 (9/5/2010 2:32:43 PM) Gopinath All, when we create a job via the maintenance plan, we have the option of including "Clean up History" and "Maintenance Cleanup Task". Via the "Clean up History" task, we normally specify how far back we... Database State OFFLINE 4 753 (9/3/2010 3:16:06 PM) Utf All, I want to understand the OFFLINE database state better. Suppose, if I want to move a database to another drive after the executing "ALTER DATABASE A SET OFFLINE" and copying the files to another loc... Maintenance Plan and Read Only DB 3 1794 (9/2/2010 8:01:03 AM) Utf I'd like to use a Maintenace plan to run DBCC + Update Statistics on my DBs, but since i have one DB which is Read Only it stacs on that DB. What can I do? ... SQL Server Manager 2005 vs Server Manager EXPRESS 2 801 (9/3/2010 9:07:03 AM) Utf HI I have inherited a server that has SQL Server 2005 installed on MS Server2003 OS - Problem - MS SQL server manager studio EXPRESS is installed. Kindly assist ASAP - I need to have Manager Stud... non-brand name memory and cluster failure 2 812 (9/3/2010 3:06:30 PM) Dan I have a Sql Cluster that failed with the following message in the event log. 'SQL Server' in Resource Group 'Disk Group 1' failed. The customer is suggesting this might be related to additional memory in... Product Key 0 704 (9/3/2010 6:48:48 PM) Kevin Is there anyway to retrieve the product key from a SS2005 Standard Edition installation? Can I use Developer Edition media and convert to Standard Edition using the installed product key after testing? I on... Losing SQL connection 3 1927 (9/1/2010 8:24:06 PM) Utf We have SQL 2008 server on our network and I am periodically losing connection to SQL Server on my Win 7 PC. I will be working in and out of SSMS all day and then all of a sudden I get "A network-related o... RE-Raiserror in error handler procedure 3 1056 (9/3/2010 7:09:19 AM) schaf Hi NG, I have a store procedure which is my error handler. In each catch- block of a try/catch a call this function for error analization. Now in some cases I would like to re-raise the same error from this ... Cant use Import-Module in Powershell in SQL Server 2008 SQL Agent 0 1224 (9/3/2010 10:07:03 AM) Utf Yo Geeks, SQL 2008 SP1 CU 5 Enterprise x64 Windows Server 2008 R2 Datacenter Wrote a basic Powershell script to get Membership of Certains Groups from AD using the ActiveDirectory Module new in 2008 ... Find UnUsed Stored procedure 2 870 (9/2/2010 7:39:03 AM) Utf I have lots of unused SP in my DB and i'd like to delete them. I need to find them. How can I know that a Stored procedure is not used. (with the tables i look at the DMV). I thought to trace it by a DDL... A good database modelling tool 1 583 (9/2/2010 7:32:07 AM) Utf I am looking for a good database modelling tool in order to design an sql server database. What is about VISIO and which version is the best? ...