Viewing 15 posts - 106 through 120 (of 129 total)
Try this (Created as a view)
SELECT hostname, program_name, nt_username, net_address, net_library, loginame, nt_domain
FROM master.dbo.sysprocesses
You'd be most interested in hostname I fugure....
DB
July 6, 2004 at 12:07 am
5. The file you trying to read in is locked - being edited or held open by the OS ??
July 5, 2004 at 9:34 pm
You may find sp_linkedservers (list defined linked servers) and sp_tables_ex which gives you info about tables in a linked server.. Don't wheter they'll be much help in your situation though...
Anyone...
July 5, 2004 at 9:27 pm
As long as you get no errors, probably you need to explictly reference the named instance e.g.
OSQL -Uhewhoisgod -Ppassword -dLive -SCCSQLDOCS\INSTDOCS -iE:\SQLStuff\NEWPROF1.SQL -h-1 -w300 -n
Where select @@servername gives you the...
June 29, 2004 at 12:40 am
Just for a laugh see if there is a limit in the different syntax
SELECT * FROM MyOracle..SchemaOwner.VW_SOME WHERE DI in (blahblahbalh..
Stick to Upper Case too....
DB
June 28, 2004 at 6:06 pm
If you run the cliconfg.exe utility on the client with administrative or power user rights you can see what will be the protocol used to connect to the server. (And...
June 28, 2004 at 5:48 pm
I had no problems with it, mailing out or internal.
DB
June 28, 2004 at 5:31 pm
If you are after SQL Server items you can go into EM/management/SQL Server Agent/Alerts and select new SQL Server performance conditions (do screen shots work here ?)
hmm maybe not, we'll...
June 28, 2004 at 5:04 pm
One killer error that prompted me to look into this area in the first place is Blocking Locks. Try setting that up. I like to get notified immediately this occurs...
June 28, 2004 at 4:18 pm
I had a quick look via Internet and couldn't see any similar reference so I'm guessing you might have an Excel Add-In or an XLA file in your Excel 'startup"...
June 20, 2004 at 5:09 pm
Eventually success:
I had to go into design and open the two odbc connections, check clear transformations on cloing the properties windows, save and THEN change the owner to the account...
June 15, 2004 at 10:33 pm
I just copied the cd to a network share and placed this batch file above the x86 directory...
------------------
rem @echo off
rem Performs SQL Server Client Unattended Install operation
rem Before running this...
June 15, 2004 at 10:12 pm
Interesting, David - thanks.
I found this on the Web - it helps.
http://www.nerva.com/computing/CodeSamples/ADSI_SQL_Example.htm
DB
June 14, 2004 at 5:24 pm
Viewing 15 posts - 106 through 120 (of 129 total)