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 Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, 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 want to present a datetime value without hours, minutes or seconds in SQL Server 2008? Would this code work?Statement @SomeDate datetime = '2013-09-18 16:30:22' select trunc_date(@SomeDate) ----------------------- 2013-09-18 00:00:00.000
i really am looking for a site where i can get network design problems so i could practice them with my packet tracer.please will be so glad if any one can help me. thanks
I’m trying to set pagination within SQL Server 2012 so that you can follow the total number of pages while adding data. Anyone know how to do that?
I've been working on this for weeks now but I continue to get this error message when I'm trying to login in SQL Server 2008 R2. 80040ed4 Failed login for user 'myuser' Can anyone explain to me what this error message means and how I can solve it? Thanks!
I’m having issues in SQL Server 2008 R2 Management Studio where it does not recognize my throw as detailed below: incorrect syntax near Throw I am trying to set things up so that my website throws an error whenever someone enters the same value twice Begin Try insert into BusinessID (BusinessID)...
I just finished making some code changes to get around a problem. I changed my code from doing a dynamic insert to using a stored procedure. Originally it was 20 lines of code for the dynamic process. Doing it the stored procedure way, by the time you defined all the parms it was 107 lines of vb...
How to get rid of request to download/save unwanted file from unfamiliar website?
How do you remove the When and Where from the body of the Outlook invite email?
Is Siebel considered to be 508 Compliant?
In this user's CL program, he has 3 jobs and he wants to submit all jobs in qbatch. The catch is he wants to run the third job after the first and second job have already completed. How can he control this? -- Michelle Davidson, editor, Search400.com
Hi, I need to submit 2 jobs JOB 1 and JOB2 but before doing a sbmjob on JOB2 i should make sure that JOB 1 has ended. How can i do that during program execution. Thanks.
Hello, recently I have done VMware ESX 4.0 server from an Institute but that Institute is not authorized by VMware organization. So my question is am I eligible to set in VMware online certification exam or not?
My IT group bought me a 2900 series router to replace my 1841. How do I copy the program from the 1841 and paste it to the 2900? The reason for the change is due to needing more external ports.
I’m trying to change an existing stored procedure. I’m using the command: ALTER 'name_of_stored"procedure' When I do so, the name comes up with red highlighting, denoting that it is an invalid object. Although I am able to execute the command successfully, I want to know why SQL Server 2008 R2...
Now, I have created two different things: A local database and a Windows form. With the Windows form (In Server Explorer), I added the database's connection. How can I begin querying it using LING-to-SQL? Thanks!
what is this file and how do you open or delete it?
What is the use of keyword *REGFAC. When we create a new member and change the session defaults there is a option "user exit program" and in that option the above keyword is mentioned. What does it signify? What is the use of "user exit program?"
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...