Creating a format file to import XML data

Hello gurus and geniuses Please forgive me starting yet another thread on this subject. I have sear…

Service Broker Issues - SQL 2005 Enterprise Edition 64 SP3

Hello, Before to start I just resume actions I made to reduce msdb size (earn space on c: volume). …

How do you hide the SQLAgent90.exe command window?

After some recent maintenance, our SQL Server machine began to create/display a blank command windo…

can not view through a Cube the new attribute addition

Dear All, I can not view through a Cube the new attribute addition I made to a dimension. Although …

Difference in Database Sizes

I have two databases, database A and database B, locating on the difference servers. Both SQL Serve…

Script to generate All SQL jobs from SQL2000

Hi, Please provide the script or link to generate all SQL jobs . The generated scripts will be goin…

SSAS Cube(olap's)

hi, Wish You A Happy New Year... i have one doubt about Olap's which is better one among ROLAP, MO…

Optimised query for inner table join

Hi, I have two tables as below CREATE TABLE [dbo].[Papers]( [PaperID] [int] NULL, [RollNoID] [int…

Faulting application sqlagent90.exe and sqlwb.exe

I have 2 separate SQL server instance that has the following errors Faulting application sqlagent9…

Sql 2000 memory error

We found one of our old version sql server 2000 databases disappear in the database dropdown in man…

Quest Litespeed restoring forever

Hi guys, I've seen other people post questions about litespeed so maybe you guys can help me. I tri…

Data Type Help

I need help I am getting error and try to fix for last couple of days, Please me out, My source fie…

Table Partitioning

Hi, Can we have two different range on particular date in Table Partitioning. For e.g. Installment…

Do You Manage SQL Server from a Phone App?

Hi experts, I'm trying to find a useful tool to help me look in on my databases during the upcoming…

Installation of SQL SERVER 2005