Last week we reset the Model datable to autogrow. Now I get an error when I try to go into it. (I discovered this since I can no longer go into the interface of the program). I wasn't here when the changes were made to the Database Model, but the change was made because the transaction log was filled up.
Help.. I'm such a newbie.
anke
Hi everybody,
There are times when the database (SQL 7.0) cannot be accessed ( backup, routine maintenance, etc....) from asp page.
In those cases i am getting an ugly asp error message.
Is there a way ( code ) which will trap that error and return a nicer custom message for user or something like that.
Thanks a lot,
I was using windows authentication and later changed to SQL server authentication so that i can connect to java netbeans.i went to the security and login under the object explorer to set a username and password for the sql server authentication.it successfully login but cant open any of the my database created earlier.it gives database not accessible error.
View 2 Replies View RelatedHi,
i use sql server express 2005. There are several databases which all works fine.
My problem is: when i try to expand one database in Management Studio express, i get for that database (not for others):
"the database 'mydb' is not accessible (microsoft.sqlserver.objectexplorer)" and that's it. I can't see tables nor any objects of that db, while the application still can insert records into tables of that db.
When i run this query: select * from master..sysdatabases
i see all the databases (also 'mydb') with the same mode, status ...
Thanks
Tartuffe
I am setting up a web application, where the application needs to access a database. I have created the user (for the application) and it can log in to the SQL 2005 Sp2 server, but when I try to open the required database using Server Management Studio, it says "The database [name] is not accessible. (ObjectExplorer)"How do I make a database accessible to a login, using Server Management Studio?
View 2 Replies View RelatedHi,
I've a very basic doubt about database mirroring. I did setup a database mirroring session with the help of SQL Server Management Studio between the server A (db1) and B(db1). When is stop database mirroring by using the command button "Stop Mirroring" available in the mirroring page of SQL Server Management Studio , the mirror database{ B(db1) } goes to state "Restoring...". After stopping the mirroring i'm not able to access the mirror database.
Can you please tell me how to bring mirror database B(db1) to operation mode so that we can start working with that database?
Regards,
Gopi
In MS Visual Studio, when creating a new Report Model Project, after defining a datasource to an Oracle database (and successfully testing it), and a simple datasource view (1 table), when I click "Run" in Report Model Wizard, I receive the following error:
"ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }"
It does not appear that one can create Report Models from an Oracle database (since the SQL being used to query the Oracle database cannot be edited and contains syntax errors?). Is this the case?
Thank you.
Hello,
I have a table (in Access) with about 30 fields and 1,700,000 records.
I had created a mining model in AS2005 with only one key (the autonum column called ID)
and other attributes marked as Input and/or predict.
When processing the model, it finish (after 15 min.) with an error: 3183
"Not enough space in temporal disk"
After some search , I encountered that is close related to the memory asigned to the tempdb.
I tried to increase the size of tempdb but it is imposible, moreover, it starts
with 8MB but it is autosized when needed.
I don't know how to solve this issue. Or, if it is a question of memory/disk space management (I have 100GB of free space in disk).
I tried the same model changing the KEY (I assign StudyID as key) then with the same data but 60,000 StudyIDs it is ok, so the mining model is ok (no nested tables, no case, too easy for getting a memory error)...
Please, can anyone recommend a possible solution for this issue?.
Many Thanks.
Hello, I want to get data from datatable as below. I am getting error:
BC30516: Overload resolution failed because no accessible 'New' accepts this number of arguments. I did not understand what is wrong. Because everything is same as msdn library.
my codebehind is:
Imports System.Data
Imports System.Data.Sql
Imports System.Data.SqlClientPartial Class Default2 Inherits System.Web.UI.Page
Private Shared Function GetConnectionString() As String
' To avoid storing the connection string in your code,
' you can retrieve it from a configuration file.
Return "Data Source=Database;Initial Catalog=otel;Integrated Security=True;Pooling=False"
End FunctionProtected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.LoadDim connectionString As String = _
GetConnectionString()
' Create a SqlConnection to the database.Using connection As SqlConnection = New SqlConnection(connectionString)
' Create a SqlDataAdapter for the Suppliers table.Dim mailsAdapter As SqlDataAdapter = _ New SqlDataAdapter()
' A table mapping names the DataTable.mailsAdapter.TableMappings.Add("Table", "Pages")
connection.Open()Dim PagesCommand As SqlCommand = New SqlCommand( _"SELECT * FROM Pages", _
connection)
PagesCommand.CommandType = CommandType.Text
' Set the SqlDataAdapter's SelectCommand.
mailsAdapter.SelectCommand = PagesCommand
' Fill the DataSet.
Dim dataSet1 As Dataset = New Dataset("Pages") 'ERROR MESSAGE HERE...........................................mailsAdapter.Fill(dataSet1)
connection.Close()LblPageName.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(1))
TxtPageTitle.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(2))TxtPageSummary.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(3))
Rte1.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(4))TxtPageimgUrl.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(5))
End Using
End Sub
End Class
Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:
View 9 Replies View RelatedI get the following error when I try to load the mining model in the mining model viewer
Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[NeuralNet].[GetAttributeValues]' function does not exist.
I get a similar error when I try to load the Load Mining Accuracy Chart
Failed to execute the query due to the following error:
Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[AllOther].[GenerateLiftTableUsingDatasource]' function does not exist.
I have OWC 11 installed. What am I missing here?
Thanks
We some how is not able to entre to sql executive with the sa name and password and so not able to see the context of the database. we are not able to access the databeses either. We want a solution whereby I can change the SA login or give him the administrator right to do everything with the database.
Anindya Mukherjee
Hi All
I have the following questions regrading T-SQL
1. How to assign database role "db_owner" to model database using T-SQL?
2. How to grant a window login public access to master database
Thanks.
I changed the Administrator Password on our Server. I also changed the sa password for the SQL Server to match. Ever since then, if one of my web pages attempts to retrieve data, the user get the error:
SQL Server does not exist or access denied.
This is strange because my pages do not use the sa account in order to retrieve data. I have a copy of MS Access installed locally on the server. Using it I can access the SQL Server data with linked tables. So the SQL Server is obviously servicing internal requests.
I tried changing the passwords back again, but the problem still persists.
Anybody any ideas?
Hi all,
I am using SQL Server BI development studio to create a model. I get the error message when I run the report model wizard:
"Arithmetic overflow error converting expression to data type smalldatetime."
Please help.
Best regards,
New to Reporting Services. Installation seemed to go well. All green checks on the Reporting Services Configuration page.
In Reporting Services when I click New Datasource... My connection type is Microsoft SQL Server. This is my connect string... data source=PeninsulaPoint;initial catalog=UHSSelfService. I have checked the Windows integrated security radio button. Then I save the Datasource. I then edit the datasource to Generate the Model to be used in Report Builder. When I click Generate Model, give the Model a name and click ok I get the following error.
Cannot create a connection to data source ''. (rsErrorOpeningConnection)
Invalid Authorization
Help!!!!!
In the previous thread I said when I want to create a model and structure, in process time one error appeared that I said.
Now I think this error is because of my structure now I€˜ve one request i send my project and please see that and say what is this error?
Thanks a lot.
For creating mining structure and mining model I use the code of chapter14 file that one person had put for me
Please run this project and then say whay when I process my model ,the process do incorrectly.
in this code button 1 is for showing the anme of data bsase and table and column of that in currenyt server and then with button 2 i want ot creat model and struture and data source data source view
now please run this code and then say whay i have error for process model .
please run and answer me
thanks a lot
string last;
int ts;
string[] items;
string ky;
string t;
string dbnam;
string tblnam;
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True");
con.Open();
SqlCommand cmd1 = new SqlCommand(" EXEC sp_databases;", con);
DataSet ds = new DataSet();
SqlDataAdapter da1 = new SqlDataAdapter();
da1.SelectCommand = cmd1;
da1.Fill(ds, "1");
this.comboBox1.DisplayMember = "database_name";
this.comboBox1.ValueMember = "database_name";
this.comboBox1.DataSource = ds.Tables["1"];
SqlCommand cmd2 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_tables @table_owner ='dbo';", con);
SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = cmd2;
da2.Fill(ds, "2");
this.comboBox2.DisplayMember = "table_name";
this.comboBox2.ValueMember = "table_name";
this.comboBox2.DataSource = ds.Tables["2"];
SqlCommand cmd3 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_columns @table_name = N'" + comboBox2.Text.ToString() + "', @table_owner = N'DBO';", con);
SqlDataAdapter da3 = new SqlDataAdapter();
da3.SelectCommand = cmd3;
da3.Fill(ds, "3");
DataTable dt = new DataTable();
dt.Columns.Add("column_name");
dt.Columns.Add("data_type");
for (int i = 0; i < ds.Tables["3"].Rows.Count; i++)
{
DataRow dr = ds.Tables["3"].Rows;
dt.Rows.Add(dr[3], dr[5]);
}
con.Close();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = dt;
DataGridViewCheckBoxColumn DVCC = new DataGridViewCheckBoxColumn();
DVCC.Name = "key";
dataGridView1.Columns.Add(DVCC);
DataGridViewCheckBoxColumn DVCC2 = new DataGridViewCheckBoxColumn();
DVCC2.Name = "input";
dataGridView1.Columns.Add(DVCC2);
DataGridViewCheckBoxColumn DVCC3 = new DataGridViewCheckBoxColumn();
DVCC3.Name = "predict";
dataGridView1.Columns.Add(DVCC3);
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
dbnam = comboBox1.Text;
tblnam = comboBox2.Text;
Microsoft.AnalysisServices.Server srv = new Server();
srv.Connect("data source=localhost");
string dbname;
dbname = comboBox1.Text;
Database dbNew = new Database(dbname,
Utils.GetSyntacticallyValidID(dbname, typeof(Database)));
srv.Databases.Add(dbNew);
dbNew.Update();
//***************************//
string DataSourcename;
DataSourcename = comboBox1.Text;
RelationalDataSource dsNew = new RelationalDataSource(
DataSourcename,
Utils.GetSyntacticallyValidID(
DataSourcename,
typeof(RelationalDataSource)));
dsNew.ConnectionString = "Provider=SQLNCLI;Data Source=localhost;" +
"Initial Catalog="+comboBox1.Text+";Integrated Security=SSPI"; ;
dbNew.DataSources.Add(dsNew);
dsNew.Update();
//**************************//
DataSet dset = new DataSet();
SqlConnection cn = new SqlConnection("Data Source=localhost;" +
"Initial Catalog="+comboBox1.Text+";Integrated Security=true");
SqlDataAdapter da = new SqlDataAdapter("select * from "+comboBox2.Text,cn);
da.FillSchema(dset, SchemaType.Mapped, comboBox2.Text);
DataSourceView dsv = new DataSourceView(comboBox1.Text, comboBox1.Text);
dsv.DataSourceID = comboBox1.Text ;
dsv.Schema = dset.Clone();
dbNew.DataSourceViews.Add(dsv);
dbNew.Update(UpdateOptions.ExpandFull);
MiningStructure ms = dbNew.MiningStructures.Add(comboBox2.Text, Utils.GetSyntacticallyValidID(comboBox2.Text,
typeof(MiningStructure)));
ms.Source = new DataSourceViewBinding(comboBox1.Text);
ms.CaseTableName = comboBox2.Text;
int count = dataGridView1.Rows.Count;
for (int i = 0; i < count - 1; i++)
{
if (Convert.ToBoolean(dataGridView1.Rows.Cells["key"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["input"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["predict"].Value))
{
string X;
X = Convert.ToString(dataGridView1[0, i].Value);
ScalarMiningStructureColumn I;
I = new ScalarMiningStructureColumn(X,
Utils.GetSyntacticallyValidID(X, typeof(ScalarMiningStructureColumn)));
if (!Convert.ToBoolean(dataGridView1[2, i].Value))
{
I.IsKey = false;
I.Type = conv(Convert.ToString(dataGridView1[1, i].Value));
I.Content = "Continuous";
}
else
{
ky = X;
I.IsKey = true;
I.Content = "Key";
I.KeyColumns.Add(comboBox2.Text, X, OleDbType.Integer);
}
ms.Columns.Add(I);
}
// //****************************************************************************************************************************************//
}
ms.Update();
MiningModel mm = ms.MiningModels.Add(comboBox2.Text,
Utils.GetSyntacticallyValidID(comboBox2.Text, typeof(MiningModel)));
mm.Algorithm = "Microsoft_Time_Series";
for (int i = 0; i < count - 1; i++)
{
if (Convert.ToBoolean(dataGridView1.Rows.Cells["key"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["input"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["predict"].Value))
{
string X;
X = Convert.ToString(dataGridView1[0, i].Value);
MiningModelColumn mc = new MiningModelColumn(X,
Utils.GetSyntacticallyValidID(X, typeof(MiningModelColumn)));
mc.SourceColumnID = ms.Columns[X].ID;
if (Convert.ToBoolean(dataGridView1[2, i].Value))
mc.Usage = "Key";
else
if ((Convert.ToBoolean(dataGridView1[3, i].Value)) && (Convert.ToBoolean(dataGridView1[4, i].Value)))
mc.Usage = "Predict";
else
mc.Usage = "PredictOnly";
mm.Columns.Add(mc);
}
}
mm.Update();
ms.Process(ProcessType.ProcessStructure);
mm.Process(ProcessType.ProcessDefault);
srv.Disconnect();
SqlDataAdapter da2 = new SqlDataAdapter("select " + ky + " from " + comboBox2.Text, cn);
DataTable dt=new DataTable();
da2.Fill(dt);
ts = dt.Rows.Count;
items = new string[ts+10];
for (int i = 0; i < ts; i++)
{DataRow dr = dt.Rows;
items=dr[0].ToString();
}
last = items[ts-1];
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True");
SqlCommand cmd2 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_tables @table_owner ='dbo';", con);
con.Open();
SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = cmd2;
DataSet ds = new DataSet();
da2.Fill(ds, "2");
con.Close();
this.comboBox2.DisplayMember = "table_name";
this.comboBox2.ValueMember = "table_name";
this.comboBox2.DataSource = ds.Tables["2"];
if (comboBox2.Items.Count > 0)
{
comboBox2.SelectedIndex = 0;
}
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True");
SqlCommand cmd3 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_columns @table_name = N'" + comboBox2.Text.ToString() + "', @table_owner = N'DBO';", con);
con.Open();
SqlDataAdapter da3 = new SqlDataAdapter();
da3.SelectCommand = cmd3;
DataSet ds = new DataSet();
da3.Fill(ds,"3");
con.Close();
dataGridView1.DataSource = "empty";
con.Close();
DataTable dt = new DataTable();
dt.Columns.Add("column_name");
dt.Columns.Add("data_type");
for (int i = 0; i < ds.Tables["3"].Rows.Count; i++)
{
DataRow dr = ds.Tables["3"].Rows;
dt.Rows.Add(dr[3], dr[5]);
}
dataGridView1.Columns.Clear();
dataGridView1.DataSource = dt;
DataGridViewCheckBoxColumn DVCC = new DataGridViewCheckBoxColumn();
DVCC.Name = "key";
dataGridView1.Columns.Add(DVCC);
DataGridViewCheckBoxColumn DVCC2 = new DataGridViewCheckBoxColumn();
DVCC2.Name = "input";
dataGridView1.Columns.Add(DVCC2);
DataGridViewCheckBoxColumn DVCC3 = new DataGridViewCheckBoxColumn();
DVCC3.Name = "predict";
dataGridView1.Columns.Add(DVCC3);
}
public string conv(string data_type)
{
if (data_type == "int" | data_type == "tinyint" | data_type == "smallint" | data_type == "bigint")
t = "Long";
else
if (data_type == "char" | data_type == "nchar" | data_type == "varchar" | data_type == "nvarchar" | data_type == "binary" | data_type == "varbinary" | data_type == "image" | data_type == "text" | data_type == "ntext" | data_type == "timestamp" | data_type == "uniqueidentifier")
t = "text";
else
if (data_type == "decimal" | data_type == "float" | data_type == "money" | data_type == "smallmoney" | data_type == "numeric" | data_type == "real")
t = "Double";
else
if (data_type == "datetime" | data_type == "smalldatetime")
t = "Date";
else
if(data_type=="bit")
t="Boolean";
return t;
}
}
}
Hi, everyone here.
I am trying to get the training error of the model processed which can reveal how much the model fits the cases. The training error can reveal how many cases (from training set) are classified correctly. The lower traing error is, the more the model fits the training set. (Maybe overfitted) But I found it hard to get. I saw the life chart in AS 2005 which I am not quite understand and don't know how to code it in my program.
Is there some way to getting traing error or predicting error?
I am now using this awful way to get the training error:
select t.*,CollegeTree.CollegePlans as pred
from collegetree
prediction join
openquery(DSource,'select * from CollegePlans') as t
on CollegeTree.StudentID = t.StudentID and
...
where t.CollegePlans = CollegeTree.CollegePlans;
and then use datareader.ItemCount to get the count of cases which classified correctly.
Keyword: train error,predict error, data mining, analysis service
The model specified must be a generated model. (rsModelNotGenerated)
This error comes up after clicking on the new report model. The report model and datasource deployed to the sharepoint server with no issues.
Hi, I am trying to create an app that will work exactly like the inbox section in face book.
Do you have any database model I can use as a reference?
it works based on threads.
I am having issues with data redundancy any help will be appreciated.
Thanks
Hi,
trying to input
create table T (c1 nvarchar(max));
in MS SQL Server Manangement Studio Express results in an error :
Fehler beim Analysieren der Abfrage. [ Token line number = 1,Token line offset = 30,Token in error = max ]
create table T (c1 nvarchar(4000));
is processed w/o errors.
I´ve installed SQL Server 2005 Express Ed. SP2
Microsoft SQL Server Management Studio Express 9.00.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft .NET Framework 2.0.50727.42
Betriebssystem 5.1.2600
Any ideas?
Thanks in advance
Werner
I am trying to expose a stored procedure on SQL Server 2005 as a web service. So I just have an end point created with the procedure as my web method. Now when I try to reference this web service in my C# windows application, I am only able to see the procedure definition by requesting for the WSDL http://servername/path?wsdl. But when I try to reference it, I get the error 501/505 - Not Implemented or not supported. Any ideas what the issue here could be? Would really appreciate the help here as I am kinda stuck! - Thanks, Manmeet
View 2 Replies View RelatedHi all,
We installed RS on a non default website on our IIS server. When targeting the Reports page from the server itself (http://site:8015/Reports) we can see the welcome page. However if we try to access that same page from another machine we get a generic IE message: IE cannot open the specified page check your internet connection etc. Because the error is so generic I have no idea as to what can be the cause: IIS or RS config ? I suspect IIS because no RS error is raised but then I don't see what I could've missed on that level...
Any ideas of what could be the cause of this ?
thanks a lot
Notes:
- the DB and the RS instance are on the same server
- other sites hosted on the same server are accessible from the client machine
- Anonymous access is enabled on the site level, and on the Reports / ReportServer level. I tried unsetting it but it didn't change anything for the remote client.
- I tried changing the account RS is running under: it used to be LocalSystem, I now set it to NT AuthorityNetworkService but no difference.
Environment: SQL Express Advanced & Windows Server 2003
I've searched forums and found responses from 2006 forward, but none that I'd find satisfactory, so if anyone can help, I'd appreciate it.
I'm using SQL have SQL Server Reporting Services 2005 SP2. I've successfully used SQL Server Business Intelligence Development Studio to create reports and charts from data stored in an Oracle 10g database.
I have a distributed team and while I'm creating the official reports, I need them to be able to utilize the Report Builder to create their own reports for day to day management of their own activities.
I created a Data Source and a Data Source View successfully. When I tried to utilize the Report Model Wizard to create a report model the builder can use, I get an error.
ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }
I've read that this was ''fixed" with SP2. I've also read that there are work-arounds (which I don't necessarily understand). However, I've read plenty of MS documentation that says that this should work.
Can anyone provide any clarity around where my problem lies and how I might mitigate?
Thanks in advance,
i try to process datamining with DMX
first i create new mining:
CREATE MINING model ForexData ( timeseri DATE KEY, Xhnow TEXT DISCRETE, Muccl TEXT DISCRETE, Change TEXT DISCRETE, XH5be TEXT DISCRETE, XH3be TEXT DISCRETE, XH1be TEXT DISCRETE , XH1ne TEXT DISCRETE PREDICT_only, XH3ne TEXT DISCRETE PREDICT_only, XH5ne TEXT DISCRETE PREDICT_only)Using Microsoft_Association_Rules (Minimum_Probability = 0.4, Minimum_Support = 0.01)
after that i use insert into statement:
INSERT INTO mining model ForexData(Change,Muccl,Timeseri ,XH1be,XH1ne,XH3be,XH3ne,XH5be,XH5ne)OPENQUERY([Forex DB],'Select Change,Muccl,Timeseri ,XH1be,XH1ne,XH3be,XH3ne,XH5be,XH5ne FROM dbo.dataprice')
there is the fisrt time i deploy ForexData so, it return an error:
Errors in the OLAP storage engine: An error occurred while the 'timeseri' attribute of the 'ForexData_Structure ~MC-timeseri' dimension from the 'Analysis Services Project1' database was being processed.
i dont know about it, i have read some docs and comments on web but can solve this problem, can you help me?
as soon as posible, please
i have create a data source and data source view by BI and it return database is 'Analysis Services Project1'. and data source name: 'Forex DB' ;data source VIEW name: 'Forex DB' ;
nick yahoo: remember_somebody; contact to me if you can, i really need these infomation
Hello, I am using SQL Server 2005, and trying to load a mining model : microsoft association rules through a VB.net.
When it is loading, this error msg displayed :
"An error was encountered in the transport layer. The peer prematurely closed the connection."
Any help is really appreciated.
Thanks a lot,
Mita
I am developing a multiple regression model for a super market site selection with 11 predictors.
As soon as I press the model viewer tab, the following message appears:
The server content appears to be out of date.
Would you like to build and deploy the project first?
I opt no and the error message pops up:
The tree graph cannot be created because of the following error:
'Either the user, ......., does not have access to the ....... database, or the database does not exist.'.
Could anyone mine out the cause please....
saji
Hallo
I've got a problem with the Report Model Wizard, when i run them i become following error:
Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
The datasource is a Access DB, when i do the same procedure with one of our other db (mssql) it works, but i need the report model to the Access DB.
Any Ideas?
I need to develop a language specific dwh, meaning that descriptions of products are available from a SAP system in multiple languages. English is the most important language and that is the standard. But, there are also requirements of countries that wants productdescriptions in their language.Â
Productnr Productdesc Language
1       product    EN
1       produkt    DE
One option is to column the descriptions, but that is not very elegantly. I was thinking of using bridge tables to model this but you have to always select a language in a filter (I think)..
I'm thinking of a technical solution, such that when a user logs on, the language is determined and a view determines whether to pick a certain product table specific for a certain language. But then I don't have the opportunity to interchange the different language specific fields in a report (or in my case PowerPivot).
We have the following scenario,
We have our Production server having database on which Few DTS packages execute every night. Most of them have Bulk Insert stored procedures running.
SO we have to set Recovery Model of the database to simple for that period of time, otherwise it will blow up our logs.
Is there any way we can set up log shipping between our production and standby server, but pause it for some time, set recovery model of primary db to simple, execute DTS Bulk Insert Jobs, Bring it Back to Full recovery Model AND finally bring back Log SHipping.
It it possible, if yes how can we achieve this.
If not what could be another DR solution in this scenario.
Thanks Much
Tejinder
How can I move the Model database to another location (i.e. from one drive / file location to another)?
I tried sp_detach_db (to be followed up with a sp_attach_db statement) but it rejected it because Model is a "system" database.
I tried (and it failed with a "Modify file command failed" message):
ALTER DATABASE model
modify file
(NAME='modeldev',FILENAME='f:MSSQL7DATAmodel.MDF')
I could not locate any help about moving model in books online (BOL).
Any ideas?
I have a question.
I have a database on Recovery model FULL, i do know that i have to use a Complete Backups and Log backups for it, my question is
If i made a Complete backup, what happens with the transaction log? same size? i mean need a backup log to clean it ? .
A complete backup on SQL Server doesn't inclued a log backup?
How do I change the Database owner for a MODEL database?
When I open the properties for a Model database, it shows "UNKNOWN" as the database owner, and I can't run the command 'sp_changedbowner 'sa' as it's not allowed to run on master, model, and tempdb.
Any help?