When you say you "changed it" if you just changed the extension from xls or xlsx to csv then you didn;t change much of anything except the file name. The...

MDS is just a tool within SQL Server that helps implement the concept of Master Data Management. Read up on MDM and you'll have a better understanding of what MDS...

Duplicate post. Direct replies here:

http://www.sqlservercentral.com/Forums/Topic1411923-147-1.aspx

The error message seems pretty clear and even tells you where in the file the problem resides. Your XML file is malformed due to it containing an invalid character.

You could but having...

lakh

I doubt anyone would argue against setting it but it's probably of limited value if you have multiple GBs of available RAM. It might be useful if your Express instances...

In its simplest form:

CREATE PROC dbo.createnewdb (@dbname SYSNAME)

AS

BEGIN

DECLARE @sql NVARCHAR(MAX) = N'CREATE DATABASE ' + QUOTENAME(@dbname);

EXEC(@sql);

END

GO

EXEC dbo.createnewdb N'newdb';

There are too many...

After installing the command line tools you linked to, a simple batch file or PowerShell script that accepts two parameters and calls bcp.exe to execute a stored procedure should suffice.

Are you asking whether you should design your database to only allow accessing data via stored procedures? Or something to do with having a stored procedure that someone could execute...

I have another database 'emp' in which i have used empdbo as login name.

So when i login with 'empdbo', i'm able to access 'emptest' db. This should not be allowed.

How...

If you're concerned or are already bumping into issues getting consistency checks to complete on a 3TB database you can consider splitting the workload:

CHECKDB From Every Angle: Consistency Checking Options...

Angelindiego (1/24/2013)

---

You are on the money!! We have lowside and highside servers. We have database code and app code. We have modules for db/app. He wants...

I am pretty sure I have previously applied Developer Edition on top of Express and been successful. I know I have applied Enterprise on top of Standard with no issues....

Hasitha Amarasena (1/24/2013)

---

I already created the package and it is invokable through the code. Also the code for the option 1 is in place. During the testing I learnt that...