Search results for query: *

I created an Excel workbook that queries a SQL Server database that returns around 500,000 to 600,000 rows. He then refreshes a Pivot Table references query data. You can successfully refresh the Pivot Table immediately after the refresh. When he saves the workbook and reopens it, though...

I have a client running a database on SQL Server 2008 R2 Standard. They are very concerned about processing power on the server box, and want to set up long-term auditing of logins. What is the lightest impact method to do that? Can a trace or Profiler session be set up from another server? Does...

Can a Structured Table Reference (STR) be used in place of cell references in COUNTIFS formulas? I've got a coworker's workbook that takes several minutes to recalc and is taking up over a gb of disk. He's got hundreds of COUNTIFS in cells with multiple references that extend to row 1,048,576...

I'm looking for a tool to recommend to a client to help him visualize job schedules in SQL Server 2008 and 2012. He's got a LOT of overnight jobs that need to run in order to do closes, posting, ETL, backups, optimization, etc. He wants to be able to see what's scheduled when, and where he might...

I tried this over the Office list figuring that MS Query was more an Eccel thing, but was directed over here, so... RRinTetons (IS/IT--Management)(OP)20 Dec 19 01:59 This query works fine in SSMS: EXECUTE [dbo].[myProc] @BeginTransactionDate = '2019-12-01 22:52:00',@EndTransactionDate =...

This query works fine in SSMS: EXECUTE [dbo].[myProc] @BeginTransactionDate = '2019-12-01 22:52:00',@EndTransactionDate = '2019-12-5 22:52:00' When I change it to work as a stored procedure call in MS Query to move data into an Excel workbook I *thought it should look like: {CALL...

At least it seems like a failure to me. I have a backup job that includes three COPY TO commands to move most recent backups to other servers for archive and isolated processing needs. Two of the statements work perfectly wel, third one doesn't seem to work at all, but doesn't throw an error...

I have a client who, quite properly,has all SQL Server do’s set to Windows Authentication. I have a VPN connection, I can see the database server. I even have a Windiescaccountinntheirsystem. However being on a non-domain computer gives me no obvious (obvious to me, anyway) way to authenticate...

I have an existing database application that accesses HR data from ADP's hosted HR system and maintains employee data and access in our enterprise operations system. I get the data from a local SQL Server db that's updated from ADP by a middleware product called LinkSync. The new version of ADP...

SQL Server 2008 R2, Report Builder 3.0 I want to create a report that shows two columns of data in multiple sets of columns across the page. I don't see a way to make a nice neat table to illustrate, so I'll use dots to line things up, Jones, Tom.............HR Miller...

The Task: Update all accounting general ledger segments in a database. There are 4 account segments. Tables that contain gl accounts have columns named 'xxxxSegment1', 'xxxxSegment2', 'xxxxSegment3', 'xxxxSegment4'. I've got the table names and column names in a table. There are 496 of them...

I've got an Excel workbook with dates in two cells, D9 and D10. I want to pass those values to an sp called 'SetOTBDates' in SQL Server. The sp works fine when called from within SSMS. So, I wrote a little macro and assigned it to a button. SQL Profiler shows it working to the extent that the...

I have a report that displays 1 to n rows of data. I want to display blocks of test related to some of those rows in the report footer. I was thinking I'd just add several text boxes with conditional expressions controlling the Hidden property, but that's not working as I expected. It may be...

I've installed IIS 7.5 on Server 2008 R2. I have access to IIS Manager, but others who need to use it can't see it or start it. They are members of the Admin group on the server and can log on via RDP. Is there someplace I need to grant access to Management Services to these other users? -...

I have a stored procedure on one server and an sp that calls it on another one (separate physical servers, instancces, etc.) The sp that is called does a bunch of validation and on failure uses RAISEERROR to pass info to the calling environment. It works fine in the actual db where the called sp...

I've successfully written a query that selects the data I want. When I add FOR XML AUTO to it it returns a link (in SSMS) that displays the XML output when I click it. I want to send that output via email. Everything I've tried to date end up sending the link, not the XML text. How do I do...

I have two table variables, one called @ChangedID contains a selection of primary keys, and the other called @EmployeeMap that tells me how to get from one database to another to find the records in the second database that need to be changed. For each row in @ChangedID I need to find matching...

The description of SSIS Log Analyzer at http://ssisloganalyzer.codeplex.com/ says there's a separate build for 2008 R2, but I can't find one. The download seems to provide only the 2005 build. Is this tool still in support? (I sure hope so, it looks like EXACTLY what I need to solve some...

This might belong over in the Admin section, let me know and I'll move it... I found the following in MSDN re user permissions for SSRS: But then it doesn't say how to do that. I've got a reporting server instance and, indeed, only users in the Administrators group for the server can access...

MS SQL Server 2008 R2 64-bit I can find lots of info on migrating cubes to a new version or moving an entire SSAS instance to a new server, but all I need to do is move all the cubes from their default location in C:\Program Files\Microsoft SQL Server... to another location on a different...