Viewing 15 posts - 676 through 690 (of 1,079 total)
me.nitin.sethi (11/8/2010)
Can u help me how to fix that
erm...You obviously need access to the remote objects you try to access through SSIS....
don't really know how else to explain it?
Do you...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 8, 2010 at 3:23 am
vijay82 (11/8/2010)
how to identify log backup chain is broken and where it is broken
check under SQL Agent, Jobs (right click), view history/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 8, 2010 at 3:19 am
me.nitin.sethi (11/8/2010)
I ma getting this errorplease see the Attachment below..
error screen clearly indicated that Login Failed for your account.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 8, 2010 at 3:18 am
kommagoni (11/8/2010)
How to reducing the size of Maximo SQL 2005 database to create other DB instances of much smaller size.The current DB size is around 100 GB.
please provide...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 8, 2010 at 2:04 am
andy.l (11/8/2010)
SELECT transaction_id
FROM sys.dm_tran_active_snapshot_database_transactions
ORDER BY elapsed_time_seconds DESC;
I get the ID for a transaction that is currently running. But, how can I manage to find...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 8, 2010 at 2:04 am
post your query?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 8, 2010 at 12:19 am
Brian McGee-355525 (11/7/2010)
The databases are 540GB each. They are on two...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 7, 2010 at 11:58 pm
Harshana-680014 (11/7/2010)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 7, 2010 at 11:36 pm
use the syntax as:
alter table tablename
ALTER COLUMN columnname INT NOT NULL
or if you really want to modify in the UI, do the following:
Tools ->Options-> Designers -> Table and Database...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 7, 2010 at 11:09 pm
harita (11/3/2010)
How to check the Health of a database in sql server 2005 and what is 'Health' concept,
and how to know if the transactions are committed are not, can...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 4, 2010 at 1:50 am
You need an OS with Cluster support, Server 2003 or 2008 would be best to test.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 31, 2010 at 11:18 pm
You'll need to target WMI on the remote/local server to monitor CPU
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 22, 2010 at 5:26 am
Under your SQL Agent, you can make use of the Alerts, configure it custom to CPU Util....with a threshold.
Configure the Response to notify an operator.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 22, 2010 at 4:02 am
GilaMonster (10/20/2010)
Henrico Bekker (10/20/2010)
Typing "Sel" or "Ins" etc...and pressing Tab, waiting for auto complete...like cmd.....:pinch:
Get SQLPrompt
Type 'SE' *Ctrl-Space* *Enter* -> Select
Or type 'ssf' *Tab* -> SELECT * FROM
got it on...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 20, 2010 at 4:29 am
you sqlserver services are running on the Local account, used for the installation
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 20, 2010 at 4:21 am
Viewing 15 posts - 676 through 690 (of 1,079 total)