Viewing 15 posts - 376 through 390 (of 430 total)
GilaMonster (5/6/2011)
How many rows in the table variable?
In the table variable @T the row count is 4834
in the table variable @listofrecordkeys the row count is 123
May 6, 2011 at 2:37 am
Has anybody experienced this issue before?
May 2, 2011 at 4:32 am
Syed Jahanzaib Bin hassan (4/29/2011)
on which version you have created those SSIS packagesRegards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
The SSIS...
May 1, 2011 at 10:58 am
I am all alone and before someone replies with an elegant answer, I have used the following workaround.
When I had installed SSIS with 2008 version ,BIDS was included too during...
April 29, 2011 at 12:52 am
I had collected target server memory for oltp instance and page life expectancy for few days. Target server memory was pegged at around 18 GB on an average. Page life...
April 25, 2011 at 4:49 am
JohnnyDBA (4/4/2011)
Ok, so I rebuilt the system databases and it seems to have worked. Luckily this was a fresh install and there wasn't much configuration to redo.
You have taken...
April 20, 2011 at 1:50 am
THE-FHA (3/31/2011)
Anyone with the solution yet?Can one download Cumulative Updates for solving this?
Create an empty database and use export and import wizard to transfer all the tables and views....
April 20, 2011 at 1:46 am
Michael A. A. Schall-149848 (4/11/2011)
This server has very little activity.Does anyone know what would cause this error?
Thanks!
Michael
Use activity monitor or run sp_who2 to find out if there is a process...
April 20, 2011 at 1:14 am
sathishmangunuri (4/12/2011)
I have logged into server with particular user credentials and created some table.Now I need get the details of those tables which are created by this user.
Help me...
April 20, 2011 at 1:12 am
For imports, you can even use Import Export wizard which you can schedule to run as an SSIS package and their performance will be better than using linked servers.
April 19, 2011 at 2:24 am
sqldba_icon (4/18/2011)
April 19, 2011 at 2:21 am
pavansqldba (4/19/2011)
If MSDB or ModelDB Fails shall we start the services or not? if any one know this please give me a solution
First, you need to find why it failed...
April 19, 2011 at 2:20 am
Ratheesh.K.Nair (4/14/2011)
Hi,How to had more tahn 100 tables to an existing replication?
Now i am using sp_addarticle for each table. Is ther any other way?
TIA
So many articles! Can you explain for...
April 19, 2011 at 2:04 am
beejug1983 (4/16/2011)
I looked into log file and checked events log too. But could not get any information regarding slowness of db. What else I can do as I mentioned...
April 19, 2011 at 2:02 am
Viewing 15 posts - 376 through 390 (of 430 total)