Maintenance Plan - General beginner questions41072 (9/9/2010 3:41:03 PM) UtfMorning,
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??01076 (9/9/2010 6:15:58 PM) tom12010Does 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 Errors21526 (1/14/2010 5:03:01 PM) UtfI 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
SQL help1716 (9/9/2010 3:38:44 AM) Jami
following is DDL and sample data
CREATE TABLE #tmp
lname varchar (10),
INSERT INTO #tmp VALUES ('John','Terry',null)
Log Shipping and backups1806 (9/8/2010 8:59:19 PM) GiJeetHello, 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
Disk Setup for SQL Server2691 (9/7/2010 1:32:09 PM) MatthewI'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).
Unique Identification of a database server2892 (9/6/2010 11:38:32 AM) schafHi 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 Time01351 (9/7/2010 12:56:03 PM) UtfHi 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.
Linked server and sensitive to register name11004 (9/6/2010 10:47:03 AM) UtfI 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...
Database State OFFLINE4742 (9/3/2010 3:16:06 PM) UtfAll,
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 DB31774 (9/2/2010 8:01:03 AM) UtfI'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 EXPRESS2783 (9/3/2010 9:07:03 AM) UtfHI
I have inherited a server that has SQL Server 2005 installed on MS
Server2003 OS -
MS SQL server manager studio EXPRESS is installed.
Kindly assist ASAP -
I need to have Manager Stud...
non-brand name memory and cluster failure2800 (9/3/2010 3:06:30 PM) DanI 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 Key0680 (9/3/2010 6:48:48 PM) KevinIs 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 connection31915 (9/1/2010 8:24:06 PM) UtfWe 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 procedure31041 (9/3/2010 7:09:19 AM) schafHi 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
Find UnUsed Stored procedure2855 (9/2/2010 7:39:03 AM) UtfI 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 tool1568 (9/2/2010 7:32:07 AM) UtfI 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?