• Replication and run backups

    I am running SQL 2008 with replication between 2 locations. Will the running of backups impact the replication process. Can I run both on the same database?

    mf125 pointsBadges:
  • Connecting SQL server 2005 with IAN connection

    how we can connect sql server2005 with lan area? what are all the settings and options want to change?

    Shajidjame5 pointsBadges:
  • get the value from XML in a sql table

    i created a table which contains many columns. out of that one column is having xml codings which are saved as xml info.  We are having number of parameters in one row data of that xml info. Like this we are having multiple rows. I want to select the value from the xml column of that table using...

    Rithunsi5 pointsBadges:
  • 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:
  • 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:
  • Automated Query iSQL

    I am very new to SQL and only have experience running my queries though iSQL Version 10 Build 3960 where I manually type (copy & paste) my queries. I would like to schedule a specific query to run at certain hours each day and then save the results to an excel or text file. Is this possible? How?

    Loveisalluneed325 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 Khanduja8,960 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:

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