Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, CRM, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Exchange 2003, Microsoft Exchange 2007, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Windows, Microsoft Windows 7, Microsoft Windows Server 2003, Microsoft Windows XP, Mobile, Networking, Oracle, OS, Routers, RPG, RPGLE, SAP, Security, Servers, SQL Server, SQL Server 2005, Storage, Virtualization, Visual Basic, VoIP, VPN, Windows Server, Windows Server 2008 ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
Our company is using SQL Server 2008 with several databases. We just want one database to be case sensitive to names of variable but we don't want the others this way. We want to change the settings so we can run the following script without errors:DECLARE @A int DECLARE @a intHow can you change...
Performance-wise is there a big difference between storing a file in a database (e.g., mssql) versus the system? It sees to me that outside of application portability I would want to store my files as varbinaries in SQL Server?
Have 2 separate plants drawing material components from common warehouse. Having trouble with the LT22 report reflecting needs from the secondary plant. Currently only reflecting the plant where the warehouse resides.Solution?
I'm looking to import roughly 10,000 rows (this is from a CVS file) into an existing SQL Server 2012 table. I only have 1 column to import but there's another table in my column titled "TypeID". For this column, I need to set a static value like this: 99E05902-1F68-4B1A-BC66-A143BFF19E37INSERT INTO...
I have ISA Server 2004, only selected users are allowed to access internet. Here my requirement is to allow selected LAN users to access internet only from their machine. I have tried allowing them through IP based. IP based: a user can ask or guess someone IP and put in his machine and get access...
Dear all, Can someone tell me how to calculate the maximum theoretical downlink/uplink WCDMA Capacity? I have a network full of Node Bs and BTSs and I would like to calculate the theoretical Max Uplink/Downlink Capacity for network planning purposes. I know there are some equations involved in the...
Employee: EmpID Name Company MGR_ID Date_of_Joining 1 Bhaskar A3 3 1-Jan-13 2 Ujin A1 3 1-Jan-13 3 Rex A6 NULL 1-Jan-13 Model: ID Model_Name Company Model_Type Harddisk OS RAM 1 750 Dell PC 600 GB WIN 7 4 GB 2 650 HP LAPTOP 400 GB WIN 7 6 GB 3 350 DELL LAPTOP 300 GB WIN 7 4 GB System: ASSET_ID...
Design the dimension table for the following scenario ABC Company had planned to maintain complete customer information with following guidelines 1. Changes In the customer address to be maintained historically. 2. Only last two changes on customer telephone number – to be tracked. Example: If...
This is my first experience with SQL Server 2012 and I'm not familiar with the limits of the FileTable from within SQL Server. Is there a way to create directories in a FileTable without using File I/O APIs? Is it just as simple as creating a SQL INSERT statement?
Now, I've recently installed SQL Server 2012 Express Advanced Services, which is supposed to have Full-text indexing. I've already confirmed that it's running in SQL but when I try to create a full-text catalog, for some reason it fails. I continue to get this message: "Full-text is not supported...
Is there a way to find the last executed queries for a specific database in SQL Server 2012? I am able to find them using SSMS, but I don’t want to use SQL Profiler if I don’t have too. This is the query I’ve used to get the complete list of last executed queries. SELECT...
While I was restoring a backup from SQL Server 2000 to SQL Server 2012. This is the error I'm receiving currently:Msg 3169, Level 16, State 1, Server FF101, Line 1 The database was backed up on a server running version 8.00.0760. That version is incompatible with this server, which is running...
One of my family members needs some help! He has a table in SQL Server 2008 with the attributes name and ID. The ID is a generated value like this: INSERT INTO table (name) VALUES('bob');Now, he's looking to get back the ID in the same step. How can he do this?
I am trying to connect a .net application to SQL Server 2008 using windows authentication. However, I can’t get it to work right because there are a lot of Active Directory users. I Know I could create separate login account for each of the Active Directory users in SQL Server instead of having...
I am creating an XML document using RPG and I need to output a timestamp in GMT format : YYYYMMDDThhmmssZ The date will need to end up looking like this: 20131003T210212.001Z. Can anyone tell me how to do that in an RPG program on the iSeries? Thank you.
How do you open a Gif file?
I'm unable to open an EXLS file through attached in Lotus Notes. After saving we are able to open the file.
What is STMF in AS/400?
Hello, I’m hoping someone out here can assist me. Currently the users in my domain have a link in their IE favorites that is populated using Group Policy. Senior management would like this particular link to be placed on all users desktops as a shortcut along with a specific icon. I’ve copied...
Many definitions available but nothing on the origin of the phrase "cap and trade". What is the linguistic basis for the phrase? Thanks, Hugh