I need to setup OCS and am looking for hardware/software requirements. The MS web page gives specs for supporting 100,000 endpoints, but I am not that big.
My environment:
< 100 users (maybe < 25) using only IM and Presence
Cisco Unified Comm
Unity
Exchange 2003
Win 2003 servers
Win XP users
It...
My Netmeeting directory has a user name list as "waiting for call", but this user left the company years ago. The "location" was closed at the same time. I suspect that someone fired up an old PC that has netmeeting started and was orig configured with his name (he was an IT support person). My...
My Netmeeting directory has a user name list as "waiting for call", but this user left the company years ago. The "location" was closed at the same time. I suspect that someone fired up an old PC that has netmeeting started and was orig configured with his name (he was an IT support person). My...
Moving from SQL 2000 to SQL 2005. I am looking to control the SQL Server Agent from a remote desktop. I am used to doing this with Enterprise Mgr.
I downloaded the new Mgmt Studio Express, but can't find the server agent. I have the non-express studio version on the server (which shows the...
I have a Windows 2000 server at MDAC 2.6 I need 2.8 SP1 to use SQL Express. I have tried installing 2.8, but it ends with an generic error message. I have looked at the dasetup log, but I can't identify the problem. The component checker still reports 2.6. Can someone see the error in this...
Here's what I am trying to do. We have a job that runs a DTS (this is working). What I want to do is prevent a user group from accessing this db while the job is running.
This is setup under SQL server agent / jobs as a timed job.
Here's what I have so far.
Step 1
DENY SELECT ON...
Here's what I am trying to do. We have a job that runs a DTS (this is working). What I want to do is prevent a user group from accessing this db while the job is running.
This is setup under SQL server agent / jobs as a timed job.
Here's what I have so far.
Step 1
DENY SELECT ON...
I want to delete records from file SLALLO, but not MBADREP. Fields ADxxxx are in the MBADREP file. The "select" works. What do I need to make it delete?
delete from SLALLO, MBADREP where ADAKDT > 1040731 and ADUUQ1
> 0 and ADZ93N < ADUUQ1 and ADA3CD like '4%' and ADAENB=CONO and...
I'm still new to SQL. I found the following statement. I understand the WHERE clause, but what table is getting deleted? Only frl_per_bal, or both tables?
Delete frl_per_bal
FROM frl_per_bal B, frl_trx_delta_temp T
WHERE B.entity_Num = T.entity_num
Thanks!
I recently got a new SQL Server. I got everthing setup ok, I think, but when I run this complicated DTS task I'm getting and error "SQL Server does not exist or access denied".
This DTS has multiple steps and reads a number files from our iSeries server and writes to the SQL server. The DTS...
Trying to setup a system DSN to connect to SQL database on the same machine. Getting "Connection failed. SQL State 'HYT00' Server Error 0. [OBDC SQL Server Driver] Timeout expired.
Can connect with Enterprise manager, but attempts to open database give "data source" errors. There is an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.