Viewing 15 posts - 211 through 225 (of 228 total)
Bill,
I took a second look at your original posting, and noticed that you are already connecting with SQL Plus. Shame on me for posting hastily!
There can be a...
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
November 1, 2007 at 8:40 am
CSDunn,
These sites may be of use:
DTS Resources
SSIS Resources
SQLIS Wiki
wiki.sqlis.com
Best of Luck.
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
November 1, 2007 at 8:16 am
I don't have access to any 64-bit systems, but I recommend the following:
The Oracle Networking errors can be a real pain to troubleshoot.
1) Compare the SID_NAME value in the LISTENER.ORA...
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
October 31, 2007 at 3:29 pm
Vivien,
Since I can never have enough information ...
Checking again for "official" MS KB articles yields:
How to identify your SQL Server version and edition
http://support.microsoft.com/kb/321185
Syntax is given for determining SQL Server version...
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
October 29, 2007 at 2:20 pm
I use this handy guide from the good folks at SQLSecurity.com to keep myself up to date on SQL Server patches.
SQL Server Version Database
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
Description from the page:
"This is a database...
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
October 29, 2007 at 7:16 am
Tmp,
This is a long post, but as the old saying goes, I am teaching people to fish ...
Errors such as "Error 7399 :OLE DB provider 'MSDAORA' reported an error." can...
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
October 26, 2007 at 11:32 am
Gresford Thomas,
You are dealing with several phases for your project. I have given a rough outline of how I see your project unfolding, as well as where to get...
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
October 19, 2007 at 11:12 am
Cath,
The script is great.
Note to others, make sure that OLE Automation is enabled within SQL Server.
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
October 5, 2007 at 8:35 am
Howard,
I will send you a Private Message with my contact information so that we can continue to troubleshoot your issue.
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
October 3, 2007 at 6:57 am
hmbtx,
In my environment, we have vendor applications that authenticate with a Windows/Active Directory user, and then the application "spawns" a generic user for SQL activity behind the scenes. Perhaps...
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
October 2, 2007 at 11:38 am
Brandie,
My apologies. My last round of certification exams was for Oracle, and had Case Study questions lumped in with all the others. I guess I have to read...
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
September 28, 2007 at 7:31 am
Brandie,
Like GilaMonster mentioned, you may get 2 Case Study questions in your pool of 25 (or however many) exam questions. You have the entire 90 or 60 minutes of...
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
September 28, 2007 at 7:22 am
Curiosity got the better of me ...
-- Current user login information.
-- SQL Server 2000.
select
spid
,nt_domain
,loginame
,nt_username
,hostname
,login_time
from master..sysprocesses
-- Current user login information.
-- SQL Server 2005.
select
spid
,nt_domain
,loginame
,nt_username
,hostname
,login_time
from master.sys.sysprocesses
Regards,
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
September 28, 2007 at 6:59 am
Patrick,
We are using:
Name: iSeries Access ODBC Driver
Version: 10.00.06.00
Company: IBM Corporation
File: CWBODBC.DLl
Date: 6/6/2005
Using that iSeries Access ODBC Driver to configure a System DSN, on our SQL Server machine.
We then have a...
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
September 25, 2007 at 6:33 am
Using SQL Server Management Studio (SSMS)
Tools >> Options >> Query Results >> SQL Server >> Results to Text >> Output format
Drop down: Comma delimited
UNCHECK "Include Column headers in the result...
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
September 14, 2007 at 6:47 am
Viewing 15 posts - 211 through 225 (of 228 total)