Maintenance Plan - General beginner questions41400 (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??01304 (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 Errors21797 (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
ope...
SQL help1899 (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 backups1950 (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
db o...
Disk Setup for SQL Server2860 (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).
I've...
Unique Identification of a database server21123 (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 Time01556 (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.
PIT
...
Linked server and sensitive to register name11223 (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 OFFLINE4910 (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 DB32062 (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 EXPRESS21031 (9/3/2010 9:07:03 AM) UtfHI
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 failure21054 (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 Key0898 (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 connection32068 (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 procedure31251 (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
...
Cant use Import-Module in Powershell in SQL Server 2008 SQL Agent01561 (9/3/2010 10:07:03 AM) UtfYo 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 procedure21108 (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 tool1736 (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?
...