Search results for query: *

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...

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...

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 =...

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...

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...

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...

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

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...