• SQL How to split out the Time from a DateTime col then use that in a WHERE Clause

    Hi, I have an SQL Server database that has a table containing 3 fields that I need to query. 1 field holds the date, and the other 2 hold the start and end times. What I was hoping to do was to split out the time only from the Start and End time fields and then use these times in the WHERE clause...

    Darraca290 pointsBadges:
  • session error

    Just upgraded a vendor app from sql 2005 to sql 2008 r2 sp1 and are consistently getting Error: 18056, Severity: 20, State: 29. The client was unable to reuse a session with SPID 72, which had been reset for connection pooling. I have applied all patches and stil lcan't get rid of error. User's...

    tcstl95 pointsBadges:
  • TSQ

    i have an output MAP like.. Roll no :01 Name   :XXXXXXXX Post     :qwe               (DEV,TSE)-This are option for post.   message: Invalid post --------------------------------------------- showing the error message i have moved low-value to the map all the entered data...

    Nizarudeen5 pointsBadges:
  • SQL Server Data file Shrinking

    We have the database in SQL server 2008 and size is nearly 160 GB.We have configured Transactional Replication on this database(Only few tables).There are 50% of free space available on Datafile. To reduce the disk usage We try to shrink the datafile, but unfortunately the file does't shrunken.The...

    asenthil175 pointsBadges:
  • Trigger over table that uses transaction inserts

    I have a table that is being updated via JDBC. The program that is writing records (sql insert) is using transactions. This table has an after insert trigger on it. When the trigger is disabled the table is updates correctly. When the trigger is on we get the first record and the tigger locks the...

    KSC90 pointsBadges:
  • Filtering a select based on the value of one column and the max value of another column

    I've created a temp table and need to further select some data from it. Seems simple. The temp table contains thousands of orders, an action code (C or D)and a seq_ID for each order. Each order has multiple instances of the C and D action codes, but I only want a list of those where the value for...

    CO Bill120 pointsBadges:
  • client server app on local desktop in ncomputing environment

    I am using a locally desktop hosted sql server/ .net app on ncomputing. It allows to open and work only in one of the ncomputing nodes at a time and that too with Admin login. How do I work on it on all nodes. How do I login with local users logins instead of Admin login to work in the app.

    Jaideep Khanduja9,160 pointsBadges:
  • Direct queries to mysql 5.0 on Windows Server 2003 from Oracle 10g on Solaris 8

    I have Oracle 10g running on Solaris 8. I would like to do direct queries from this server to a table on a MySql 5.0 database residing on a Microsoft Server 2003. Are there step-by-step instructions around? ie. Drivers for both ends; admin/config on both ends, etc. Thanks.

    Jlowe5 pointsBadges:
  • How do I resolve this SQL error

    [-1] SQL Error: '[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_cat_validation'. Cannot insert duplicate key in object 'dbo.cat_validation'.' SQLState='23000' SQLNativeError=2627.

    ITdisciple55 pointsBadges:
  • Connecting visual basic with SQL server

    i want to connect visual basic with mysql server

    Visualbasicmysqlserver5 pointsBadges:
  • Accessing Report Permission Using An Stored procedure in SSRS

    I have created an Report and I want to give Access  to only few to View Report. Is there a way to use a  Procedure to grant access to Users. 

    Akashmay5 pointsBadges:
  • Calling stored procedure in a database to query data in another database

    Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData...

    Ssss12315 pointsBadges:
  • RUNSQLSTM ALTER TABLE

    i'm trying to run SQl statment in batch job to alter Table CCSID to 420 but i have error Reason code 10  Hani 

    Hanisadeq120 pointsBadges:
  • Free IT Book: Why New Systems Fail

    This week's free IT book is Phil Simon's insider's guide to successful IT projects, Why New Systems Fail. From the back of the book, "Organizations often lack the necessary framework to minimize the chance of system failure before, during, and after beginning IT projects." Get the know-how you need...

    MelanieYarbrough6,345 pointsBadges:
  • Free IT Book: Securing SQL Server by Mrdenny!

    This week's free IT book is especially exciting because it was written by Denny Cherry, who you may know better as mrdenny. He's always providing quality and thoughtful answers, and we're excited to share a whole compilation of his knowledge in Securing SQL Server: Protecting Your Database from...

    MelanieYarbrough6,345 pointsBadges:
  • Calling stored procedure in a database to query data in another database

    Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData...

    Ncs5 pointsBadges:
  • How to work with Visual Basics 6.0 and SQL Server 2000

    I am designing a system with Visual Basics 6.0 as the user interface and SQL Server 2000 as the backend. How can I add data to the database through Visual Basics? How about deleting data in the tables?

    SQL Server Ask the Experts2,585 pointsBadges:
  • load balancing in sql server

    Is there any Load Balancing in SQL Server 2005 to distribute CPU load between more than one server?

    Rabinarayan5 pointsBadges:
  • Can I install SQL Server 2005 32-bit on Vista 64-bit?

    I have a processor of 64-bit and windows vista SP1 64-bit. But i want to install sql server 2005 32-bit does it support or can i install it on 64-bit. shekhar.parate@wipro.com

    Shekhar085 pointsBadges:
  • Merge two companies into one network

    The company I work for has decided to merge with its Sister Company on the lower floor. While we share the same room to house our independent servers, both companies have separate physical networks. Each with their own separate File Servers & SQL servers. Allowing Company "A" employees to log into...

    PatM5 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