Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. niall5098

    Create plan guide with date time parameters

    HI There, i have a poorly performing query i want to create a plan guide for. the query includes the line: (((T8.TRANSDATE>={ts '2022-10-16 00:00:00.000'})) in my plan guide i changed the line to: (((T8.TRANSDATE>={ts ''@P1''}) @params = N'@P1 DATETIME2 however when i try to create the...
  2. niall5098

    Issue manipulating data

    HI There, as the heading suggests I am trying to query a text based audit column for specific values then compare them values. For example the column should contain values for new_ref_no and old_ref_no in the straing. I want to query for those and then compare them to see if they are in fact...
  3. niall5098

    disabling audit sends SQL into a spin

    HI All, I just had an issue and was wondering if anyone else encountered. I had sql server auditing enabled for updates to a specific table in a user table. the audit was writing the changes to a text file. when I issued the command (ALTER SERVER AUDIT [Audit-20161007-112337] WITH (STATE =...
  4. niall5098

    issue with deprecayted sql

    HI All, I am trying to run the following code: IF exists (SELECT TOP 1 tstrv.tstrv_refno tstrv_refno, tstrv.tstrd_refno tstrd_refno, tstrv.code tstrv_code, tstrv.name tstrv_name, tstrv.parnt_refno tstrv_parnt_refno, tstrv.proca_refno tstrv_proca_refno, tstrs.authorised_flag...
  5. niall5098

    linked server query causes sqlsrver to crash

    HI There, i have a sql server 2012 installation that i was running a simple select count from to a linked oracle server. this simple select causes the instance to crash. I was running sql server 2012 rtm and applied the latest patch as there was a known issue around linked servers and the RTM...
  6. niall5098

    rebuilding indexes with always on

    HI All, I have an always on setup for 1 database . recently i ran an index rebuild job and i specifically set the sort to occur in the database log file. my assumption was that when the indexes were rebuild on prod they would occur on the secondary server in the db log file also. however what...
  7. niall5098

    applying CU to express version

    HI Guys, can anyone tell me if you can apply a CU to an express version of SQL Server. i always thought you could only apply SP's and that was basically a full install again. Thanks, Niall
  8. niall5098

    Lockdown all databases except one

    HI Stanley, Connect to your SQL server instance using management studio Goto Security -> Logins -> (RIGHT CLICK) New Login fill in user details Under User Mapping, select the databases you want the user to be able to access and configure
  9. niall5098

    TDE and Tempdb

    HI There, i have a query regarding TDE and the Tempdb. I know that if you encrypt a database on the instance then the Tempdb is also encrypted. My question is if i do enable it what would happen to the other databases that don't have TDE enabled. would the functionality of those apps connected...
  10. niall5098

    High availability for SSRS on SQL Cluster 2012?

    HI There, is the storage shared on independent? I have encountered this type of issue in the past and what i have done is the following: configure reports on node1 but use the server cluster name as the connection server, then browse to the reports database etc. take a backup of the...
  11. niall5098

    SharePoint Integrated Mode vs Native mode

    HI There, i deployed a SSRS server a while back but now the developer want to use the same server for sharepoint repots. can i switch the mode from native to sharepoint integrated mode and still have the original reports working. the original reports were developed by an app vendor pointing at...
  12. niall5098

    SSIS amd always on config

    HI There, i have 2 new servers with always on configured for databases. I now have a requirement to install and configure SSIS. From what i can see the best approach is: install SSIS on both nodes initial catalog on both nodes. delete ssidb on node2 add ssidb from node1 to always on. the...
  13. niall5098

    SQL Azure auditing vs On premise instance autiting

    Hi There, i am curious to what the difference is between auditing in azure and auditing in an on premise version of sql server. from what i can see the only difference azure only offers db auditing whereby on premise offers server and db, is this the case or is there other differences to take...
  14. niall5098

    sql server always on backups

    HI ALL, I am trying to configure backups for an always on 2 node cluster. in my job setup i have a job for each backup that runs and checks to see if the database on that node is the primary or the secondary, code below: DECLARE @preferredReplica int SET @preferredReplica = (SELECT...
  15. niall5098

    running jobs against replica databases

    HI All, i have a job that runs a number of ssis packages. at the moment it runs against the primary database however i want to run it against the read only db. the setup is sql server 2012 with always on. the connection string for the package is the listener so i need to add a step to force the...
  16. niall5098

    SQL Server logshipping and TDE

    HI All, i have encrypted a database but i now want to setup logshipping to a separate server. restoring the database is fine however i have to use T-SQL to perform the restore as i need to open the master key in advance of the restore. when i setup logshipping , it is successful but the apply...
  17. niall5098

    always on failover cluster instances

    HI All, i am getting a bit bogged down in the documentation around always on failover cluster instances. previously a sql server cluster had shared storage between the nodes for data, logs, backups etc. always on is described as requiring 2 (or more) nodes with independent disks and the...
  18. niall5098

    apply sp4 to mssql 2005 sp1 cluster

    HI All, I would like to install sql server 2005 sp4 onto a clustered environment running sql server 2005 sp2. I had heard that some issues were encountered going from sp1 to sp4 on a clustered environment but i cannot find any notes related to the so called issues on the net so i thought i...
  19. niall5098

    Application or SQL Server

    HI SQLBill, Unfortunately the user is not very IT literate and has no idea of the app apart from doing their daily workload. the user works as normal but gets the error intermittently. when the error occurs she just closes the app, logs back in and resumes working.
  20. niall5098

    Application or SQL Server

    HI There, i am dealing with an app vendor that is adement that the errors being recieved by users is sql server related. some details: app user gets an error: "Object variable or with block variable not set" I immediately check the sql server error logs and server logs but no errors stand...

Part and Inventory Search

Back
Top