View Complete Post
I am trying to create database to network
location using DBCC Tracon and tracoff comman in sql..
following querey for creating database at network location
TraceOn(1807)GOCREATE DATABASE aON(NAME = a,FILENAME
= '\\mauleen\Public\TEST\a.mdf')GODBCC TraceOff(1807)
commintin this sql command I am getting this error
completed. If DBCC printed error messages, contact your system
administrator.Msg 5133, Level 16, State 1, Line 1Directory
lookup for the file "\\mauleen\Public\TEST\a.mdf" failed with the
operating system error 1265(The system detected a possible attempt to
compromise security. Please ensure that you can contact the server that
authenticated you.).Msg 1802, Level 16, State 1, Line 1CREATE
DATABASE failed. Some file names listed could not be created. Check
related errors.DBCC execution completed. If DBCC printed error
messages, contact your system administrator.
the way to creating database at network location???/ what should I do??
I create table:
DataSet data=new DataSet();
DataTable myTable = new DataTable("NewTable");
DataColumn keys = new DataColumn; // create column keys = new DataColumn(); keys.DataType = System.Type.GetType("System.String"); keys.ColumnName = "PointID"; myTable.Columns.Add(keys); &nb
I want to make databas? that will send daily to all members that leave email?Please if you can help me
The next version of SQL Server, code-named "Yukon," includes quite a few enhancements and expanded language support. For example, Transact-SQL now conforms more closely to the ANSI-99 SQL specification and makes querying more flexible and expressive. Yukon can execute user-defined functions, stored procedures, and triggers written in CLR-targeted languages, including Visual Basic .NET and C#. It supports a subset of the W3C standard XQuery language, and has native XML support.In this article, the author outlines the most significant language features and builds an order-entry sample app.
MSDN Magazine February 2004
SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.
Alok Mehta and Ricardo Rodriguez
MSDN Magazine May 2003
I have database already on the server. However, when I created new table, the new created table Schema is not dbo. it is my user name. How to solve this?
It shows the new created table Schema is my username but not dbo.
Even though I rename it, it couldn't change. I can see this in table property.
Hi, I have installed Visual Studio 2010 Express in my local system.
Steps 1. File->New Website
2.Open datbase explorer, right click on dataconnection
3.Select Create new connection
4.use Microsoft SQL Server Database file
5. Type new databse filename
6. Now i want to use SQL authentication which is not working
7.If we use windows authentication its wokring without any problem
8.But i need sql authentication to be used.
9.I have not installed SQL studio.
I am only using the one which is packaged in VisualStudio 2010 SQLClient. Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication. I know that VS2010 setup also installs the SQL client which is requiredto create and manage sql databse files/quries etc
i dont know the default userID and password for SQLauthentication. As the express setup did not asked any credentials while installing SQL components
Thanks and regards
I had already setup roles for my pages and requirements call for ability to manage and create users.
So i was looking at code that allows you to do so using membership, even though i got the page to work, it was creating a database in my app_data folder.. i already have SQLExpress setup with the asp schema, but cant figure out how to get my application to use that instead of creating the db in the folder?
What am i missing or doing wrong?
I have the following setup in my web.config file..
<add name="SqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=188.8.131.52, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"