Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Database, DataCenter, Desktops, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP ...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
I am running almost 75 SSRS reports. IS there a way to assign a unique ID to each report? Is there a way to leverage system generated information somewhere in the SQL Server 2012 databases rather than manually assigning each report an ID, for example using spreadsheet?
Now, I'm a beginner using SQL Server and I'm looking to learn more about the advantages / disadvantages between "nvarchar(max)" and "NText" data types. Now, I don't need to know backward compatibility so I already know that "nvarchar(max)" isn't supported by previous SQL Server releases.
Hi all, I am reading data from a file PF1 using LF1 sequentially, and writing to other file PF2 using using LF2 using RPG Program R1. When I run it using CALL R1, it's working absolutely fine. But when use SBMJOB to submit it as batch job, it is going to MSGW. the error is: " CPF4326 occurred for...
I've just created a new table in SQL Server 2008 R2 and I'm trying to get the index on auto-increment. Is there a way to do this?
How can I make it so that I can store the top 2 results in 2 variables?create table t(id int); insert into t (id) values (1),(2),(3),(4); declare @id1 int declare @id2 int select top 2 @id1 = first id, @id2 = next id from tIs there a way to make this happen in one query without using a loop?
When I'm using SQL Server Management Studio 2012, I'm clicking on the "Databases" node in Object Explorer but it just keeps loading items until it finally hangs. This is only happening when I'm connected to a remote server, not when I'm accessing it through my PC. Does anyone know what the problem...
PHP codes in calculator?
Hi, I need email hosting for my company... I found that I can buy package in web hosting like GostPapa or Hotgator and get webhosting + unlimited emails account But on other hand I found Greatmail and Rackspace for hosting emails but I can't find the difference between, beside of the price... email...
I need an example of compiling an RPG PROGRAM specifying PGMINFO(*pcml) and INFOSTMF
My website is not approved by google adsense. tell me any idea? how to possible?
How do i find the IP range for 172.16.4.0/30?
Hi members, Can someone help me simply define this to a most simplest and aided examples or illustration in support to clearly understand this. " What is a Kernel?" I have heard the word over and over but I do not come to fully understand it. I search in the internet to try to fully understand it...
I’ve been working with SQL Server 2008 R2 in conjunction with Visual Studio 2008 and 2010. I just installed SQL Server 2012 and have SQL Server Data Tools running. Now I’m trying to create SSRS reports in SQL Server 2008 R2, but I can't find them in Programs. I realize that common advice is to...
The system internal job counter seems to have a range from 1 to 999999. What will happen, if 999999 is reached? Will the system automatically restart at job number 1? or what? Thanks for your answers.
Our company currently has over 50 SSRS reports. We're trying to assign an unique ID to each report and we're wondering if there's a way to leverage system generated information in SQL Server 2012 databases rather than manually assigning each report one-by-one.
I just went ahead and uninstalled an instance from SQL Server 2012. However, when I tried to uninstall a second instance but I keep receiving an error message saying I don't meet the requirements. What's the problem here?
What is a mouse and how it work?
I need access to the read transaction log file in SQL Server 2014 for auditing purposes. In the past, I’ve used a third party log reader, but we’re looking to cut costs. I’m familiar with CDC, but that only allows access to data changes and I also need access to schema. Is there an improved...
Can you provide me the steps for rollback plan when performing the firmware upgrade? We are planning on a firmware upgrade from SF240_320 to SF240_417 on our V6R1 system. And we need to submit the plan to management for approval. I need the steps for rollback in case of any problem.
So I just installed an instance with SSAS only. Now, I'm curious how security (login) will be maintained. I've created one instance with engine and SSAS (Dimensional) and another instance with just SSAS (Tabular).