Viewing 15 posts - 106 through 120 (of 130 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
The systems fine with no users loggged in. Can we keep it that way ?br>
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 ??
The systems fine with no users loggged in. Can we keep it that way ?br>
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...
The systems fine with no users loggged in. Can we keep it that way ?br>
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...
The systems fine with no users loggged in. Can we keep it that way ?br>
June 29, 2004 at 12:40 am
I'm up for it.....
DB
The systems fine with no users loggged in. Can we keep it that way ?br>
June 29, 2004 at 12:21 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
The systems fine with no users loggged in. Can we keep it that way ?br>
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...
The systems fine with no users loggged in. Can we keep it that way ?br>
June 28, 2004 at 5:48 pm
I had no problems with it, mailing out or internal.
DB
The systems fine with no users loggged in. Can we keep it that way ?br>
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...
The systems fine with no users loggged in. Can we keep it that way ?br>
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...
The systems fine with no users loggged in. Can we keep it that way ?br>
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"...
The systems fine with no users loggged in. Can we keep it that way ?br>
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...
The systems fine with no users loggged in. Can we keep it that way ?br>
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...
The systems fine with no users loggged in. Can we keep it that way ?br>
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
The systems fine with no users loggged in. Can we keep it that way ?br>
June 14, 2004 at 5:24 pm
And the other way would be......?
The systems fine with no users loggged in. Can we keep it that way ?br>
June 9, 2004 at 9:44 pm
Viewing 15 posts - 106 through 120 (of 130 total)