Questions & Answers

  • Creating a SQL script for determining if a sequence exists

    I'm looking to create a SQL script to see if a sequence exists in my SQL Server 2012 database. I understand the concept of stored procedures but not with sequence.

    ITKE342,450 pointsBadges:
  • Adding appointment to shared calendar opens an email form to calendar owner

    I have a business client uses Microsoft Hosted Exchange. One of the 15 users is having difficulty creating appointments in shared calendars. On one PC, she uses Office 2007 with Outlook 2013, and on another, Office 2013. In the shared calendars, when this user tries to add an appointment to any...

    Fritzman5 pointsBadges:
  • Query selected data convert into XML file in AS/400

    I have 5 PF. Now I want to select data from my PF and selected data need to convert into XML. Please give me guidelines, how do I do a step-by-step?

    madhuchowdary350 pointsBadges:
  • Meaning of loop in flowchart

    What do you understand by loop in flowchart?

    sam8310 pointsBadges:
  • Return a tuple of datetime objects in Python

    I want to write a function that returns a tuple of (start,end) where start is the Monday at 00:00:00:000000 and end is Sunday at 23:59:59:999999. start and end are datetime objects. No other information is given about day, month or year. i tried this functiondef week_start_end(date):start=...

    michaels325 pointsBadges:
  • Oracle And Microsoft Certified Solutions Expert

    HI ,I'm currently learning Oracle. Is it wise to Take up MCSE :Data platform as well to get a fill for both platforms ?

    biggy1234565 pointsBadges:
  • Should I use SQL Server 2008 R2 or Postgre 9?

    I'm rewriting an application for my company which requires a database. I will be updating the database using SQL Server 2008 R2. Now, here's my big question: Should I use PostgreSQL 9?Note: I won't be doing any conversions so that's not a problem.

    ITKE342,450 pointsBadges:
  • Counts by time and date with

    I am trying to count logins by hour, by month, etc., in SQL Server 2008. To do this, I believe I need to create two PIVOTs or an UNPIVOT and then PIVOT? However, I can't seem to make it work. SELECT loginid ,DATEPART(MONTH,logtime) Month , DATEPART(HOUR, logtime) Hour FROM somelog (nolock) ) temp...

    ITKE342,450 pointsBadges:
  • SQL Server 2012 Express has slowed down dramatically

    I just recently moved my .NET Development over from a Core2Duo to a new Core i7-3820 machine. No changes were made to the project code and both run on SQL Server 2012 Express.For the past week, I've seen a dramatic slowdown with INSERT INTO commands. Can someone tell me why this is happening?...

    ITKE342,450 pointsBadges:
  • which program opens *.enp files in win7?

    after a migration from winxp to win7, my encrypted *.enp files cannot be opened. i have sensible data there and cannot open them with any program. i really need some help.many thanksana

    anacleta5 pointsBadges:
  • Having problems with remote access: SQL Server 2008 R2

    I have configured my server with a static IP and installed SQL Server 2008 R2 with ITAPP. The following happens when I use the IP to access SQL Server: Client Machine: sqlcmd -S XXX.XXX.XXX.XXX -U sa -P mypass A successful connection! But when I use: sqlcmd -S XXX.XXX.XXX.XXX\ITAPP -U sa -P mypass...

    ITKE342,450 pointsBadges:
  • Using NOLOCK in SQL Statement (SQL Server 2008)

    This is more a general question but a friend of mine is in the business of making websites and applications that aren't mission critical. So with that, is it bad practice to use the NOLOCK hint in SQL Statements? He was told by an SQL administrator that he should use it if he's satisfied with a...

    ITKE342,450 pointsBadges:
  • Access to the sign off database

    How to give access to the sign off database for user?

    99496438835 pointsBadges:
  • iOS7

    How do I get the weather to show up in the notification center on my iPhone 5?

    Kruckallmighty5 pointsBadges:
  • Auto-trimming issue in SQL Server 2008

    I have a weird problem. Why in the the following SQL query does print 'equal' when run against SQL Server 2008. The database compatibility level is set to 100. if '' = ' ' print 'equal' else print 'not equal'And this returns 0: select (LEN(' '))I think its auto trimming in space. Anyone know if...

    ITKE342,450 pointsBadges:
  • Can’t open PDF files in Windows 7

    I have installed, uninstalled and installed Adobe Reader again, and get Acrobat failed to connect to a DDE Server message.  Could open PDF files when we had XP on other computer but not able to since we got Windows 7 on new computer. Have not been able to save and open in another window either....

    VickiF215 pointsBadges:
  • Receiving error message connecting to SQL Server 2008 R2

    I'm trying to connect to SQL Server 2008 R2 using Windows authentication. However, I can't because I keep getting this error:Login failed for user 'AVATOPIA\ian'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]Now, I can log in...

    ITKE342,450 pointsBadges:
  • How to check brbackup status

    How to check the status of offline backup in brtools

    PrashAB5 pointsBadges:
  • Connect AS/400 to web server

    Hi, I have a requirement where I need to send data/file to server using HTTP from my AS/400 server and then receive a response back from web server. Web server is using Java/PHP to accept data files. Please advise me an approach to do this. Thanks in advance.

    AS400xml5 pointsBadges:
  • Is it possible to use ASCMD in SQL Server 2012?

    While using SQL Server 2008 R2, I was able to execute ASCMD SSAS queries. We recently upgraded to SSAS 2012 servers and I hope to reinstall all my maintenance scripts. I can't find any ASCMD tools in SQL Server 2012, nor any documents on the internet. When I try to execute a query I get the...

    ITKE342,450 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following