Is it possible to group or arrange “Calculations†in the analysis services cubes in to different folders?
Hello I have an alert which gets triggered on a Deadlock. This triggers a job which has the below code INSERT INTO DeadlockEvents(AlertTime,...
Can some one write a query for the below requirement. here is the code that you can use to create and populate the tables Create table XYZ (id int,...
Hi, Can someone give me a detailled explanation of what is the difference between the below two in SQL Server 2005 1. Setting the Full Text index/...
We have a merge replicaiton with 5 subscriptions. 4 of those are 2 way and 1 subscriber is a 1 way replicaiton. All of a suddent one of those (1way)...
I have a column on my report which has an hyperlink. In the properties within navigation tab I have selected "Jump to URL" and the URL comes from the...
Hello, I would appreciate if some one could answer the following questions 1. Report Parameter: I have a report which has an input parameter....
I am using SQL Server Reporting Services 2005. RS is installed on a box which also has SQL Server 2005 on it. I have a windows account YYY with which...
Is there an easier way of converting/rounding a date to the nearest hour. For example 1. 2006-04-06 14:20:40.530 should be rounded off to 2006-04-06...
Error: 17883, Severity: 1, State: 0 The Scheduler 0 appears to be hung. SPID 7, ECID 0, UMS Context 0x045530B8. I have encountered this error on...
Hi: I would want to discuss in detail different options that are available in Importing & Exporting data between Oracle and SQL Server. Here is my...
SQL Mail does not send the mail until the Outlook client is not open, Meaning the DTS job to send mail task completes successfully but the mail is...
Can this be achieved. 1. I want to create a DTS which will execute a bat file on remote server. Meaning I will execute the DTS on Server A which...
Hi Everyone: There is an application whose database is on SQL Server. Each user will be provided a login to access the information in the database....
I want to know if there is any way we can redirect all the outputs from WMI script/ VB Script into SQL Server database. Can any one please comment...
Please let me know a couple of good magazines for SQL Server. I am looking for one that will help me improve my development and administrations...
I have the following info in a table Consumer ID Units 1 20 2 30 2 10 3 120 .. .....
Hi : I maintaina a SQL Server of 8GB size which has around 900 tables. Size of the log file is restricted to 2GB. I reIndex all the tables daily for...
Separate names with a comma.
