Search results for query: *

I have a server with the following specs and want to know if it is possible to do an in place upgrade from SQL Server 2005 32 bit to SQL Server 2005 64 bit... 2008 Enterprise but not R2 64 Bit OS with 32 GB of RAM SQL Server 2005 Standard 32 bit

Is it possible to sort in Report Manager while in List view? I have SQL Serve 2005 Reporting Services and am tryng to have all th folders show in the list view first and then the individual reports afterward.

Is there an easy way (or not so easy way) to get a list of all reports that use a shared data source and the name of the data source?

I am looking for a way to query all my stored procedures in a certain database to find out if the string "set transaction isolation level read uncommitted" has been put in them... does anyone have an easy way to do this?

I am attempting to modify someone else's code and I need to do the following... If employee id is 611481, then use the EmpName field in ReportMenu for the employee name, not the LAST_NAME, FIRST_NAME fields in the EMPLOYEE table. The code that already exists is: String sQuery = ""; try {...

How hard is it to configure Report Manager to access data inside a firewall from outside the firewall? We have Report Manager running on a webserver outside the firewall right now and need to access Lawson Test data inside our firewall.

I have a SQL Server 2005 x64 installed and when I run select @@version, my result is: Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) But if I right...

I am trying to make the following install work... is this possible? The goal here was to have RS running on the web (machine 10.10.10.xx) and accessible from the web: steffi1013.blahblah.com/Reports but using data from database server (10.10.10.YY) When I hit the target page it displays an...

I am using CLR assemblies on the active side of a cluster and I am wondering if I need to worry if I failover, will the CLR assemblies still work or do I need to failover to the passive side once installed on the active node and re-register them?

I need to compile a list of all of the calls from scheduled jobs (or other places) that select/insert into a specific table... is there a simple way of doing this without opening up every job and looking at it?

I have moved tempdb by running the following statement: ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev8, FILENAME = 'T:\MSSQL\DATA\tempdev8.mdf'); GO Then I restarted SQL Server and ran the following: SELECT name, physical_name AS CurrentLocation FROM sys.master_files WHERE database_id =...

When you upgrade to SQL Server 2008 Enterprise, must you run it as 64 bit? Or is 32 bit still a viable option? If 32 bit is still a viable option, is there anything that CANNOT be run if you don't use 64 bit? For instance, Do the databases need to stay in 2005 compatibility mode?

I am setting up an job that I want to email only if there is a result set. It works if I do not use HTML as the @body_format... but when I use the HTML formatting, it sends the email even if there is no results... How can I make this work using HTML formatting? see code below DECLARE...

I would like to set up a job that will email results from a query but if there are no results, it doesn't send the email. Any recommendations on how to do so??

Is there a way to make the "Move" button and the "Delete" Button in Report Manage not show?? I have people accidentally moving things that they should not and though they have "Browser" permissions only- they still can move stuff and I want to be able to remove that temptation from them.

I have a table that has the Replication property set to true and it is no longer a part of an article nor is it part of a publication. How do I change the property to false so that I can drop/rename that table?????

Is there a way to kill a SPID without it being logged i the SQL Server Logs??

I need to remove a table from an article in transactional replication. Do I need to re-initialize the snapshot? Or will it just ignore it if it isn't in the article?

I set up transactional replication with the snapshot agent doing a continuous read and I need to know where to go to change the schedule so that it only does a push once every 8 hours to the subscriber. Please help!

Is it possible to have an "Instead Of" trigger that will do and insert and update in the same trigger? For example if the record is new I want the "instead of insert" to work and if the record already exists, I want the "instead of update" to kick off