sgraj (11/7/2009)

---

Hi,

The sql server 2005 performance is very slow between 2 to 4 PM even there are very limited users. The client screens loading...

Do you have rights to create a new database?

Tara-1044200 (11/6/2009)

---

SSIS package "Export EmpplyeeData.dtsx" starting.

Error: 0xC002F325 at Export Data to OBbeaver, Transfer SQL Server Objects Task: Execution failed with the following error: "Property DefaultSchema is not available for Database...

Good advice, mentioned in previous post. might be easier if you can get into the local user group in your area, will be cheaper and you will learn faster.

why do I get the feeling, these are interview/homework questions

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/8cfea566-8f89-4581-b30d-c53f1f2c79eb.htm

This is from BOL

otherwise look in Books Online and look for recovery models

or this link

http://dbarecovery.com/sqlserver-2005-recovery-models.html

you say that you re importing into sql from db2, if you view the data task, and look at the mappings, does everything look ok, can you preview the data?,...

clive-421796 (11/5/2009)

---

Hi Silverfox, you mentioned - application development can be picked up easily.

WOW, you must be a natural at learning C#, VB, delphi, C++. From my experience software development has...

already replied to your other post, you need to post what you are trying to do in detail, as in what table export is failing and the datatypes and how...

It sounds like you have a conversion issue, can you either break down the package so that you know which task is failing, or post the datatypes for the table...

Dr.D (11/6/2009)

---

The problem is how to take the file name that I'm importing and fill the table with it. The situation is like that: The table that i'm filling it...

Dr.D (11/6/2009)

---

It is not about a job interview nor university final exam nor homework. This is my task at work and i have 3 days to finish it. Yesterday was...

Seem to be getting a lot of question like this recently...

read my previous replies.

dbcreator allows the dropping of any databases

Whatever rights are needed, can be granted without giving the server level role.

Tara, one thing I will point out, are you aware that you can grant create database to a login, you dont have to give them the server role dbcreator