View Complete Post
When I try to attach a database using SQL server 2008 express version, it gives me an error message. it says
"Msg 18456, Level 14, State 1, Server LINDA\SQLEXPRESS, Line 1
Login failed for user 'LINDA\Linda'"
How can I fix this error?
I want to read metadata like (Author,Modified By, comments..etc) on OLE Files. Please tell me any reliable approach using C# on how to read metadata from File System which is running Windows Server 2008 machine x64 Environment .
Thanks in advance.
Devi Prasad M
how do I move a 2008 SQl Express DB without code?
Stop the service then move the db then restart???
I have a main report that has two parameters (RptMonth, Reports). RptMonth which the user selects from a calendar, and Reports which is a dropdown list. Produces main report correctly.
I want to goto a second report (Detail) based on clicking a textbox named KPI. I configured the textbox to Go To Report, added this parameter named ID value [ID] that is in the dataset of the query. Parameter settings - Name=ID, datatype=Integer, parameter
Get values from query=Dataset1, value field=ID, label field=KPI. Using always refresh. This is all configured in the main report. In the detail report I have one parameter named ID, type Integer, visibility=hidden.
Security for both reports use embedded connection, type SQL server. When I run the main report and click on the KPI textbox it passes the ID and I get the correct detail report. When I deploy it to the server I get
Database 'Northwind' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415)I have, of course, verified countless times that the files are NOT read-only.Could any please explain what could be happening here? All suggestions much appreciated.many thanks,Danny
I have an SQL 2000 server. I am managing it with SQL Management Studio 2008. I have to assign read only access to jobs to few users. Not able to figure out how to do it and which roles to assign.
Need help. Thanks.
i am new to Sqlserver2005, when i attach .mdf file it takes Read-only mode, how to change it into writeable?
pls help me any one... and advance thanks
I am trying to deploy an SSIS package through dtutil.
I am getting an error 'Could not find stored procedure sp_ssis_putpackage'.
I have read that having both BIDS 2005 and 2008 installed on my PC could be a problem.
Does any body know how to get around this error?
I have Windows Vista Home Premium and the 180 day evaluation version of SQL Server 2008 installed.
I am getting the following error when trying to attach the AdventureWorks2008 database. I was able to attach the Northwind:
TITLE: Microsoft SQL Server Management Studio
Attach database failed for Server 'HOME-PC'. (Microsoft.SqlServer.Smo)
For help, click:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
FILESTREAM feature is disabled.
A file activation error occurred. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL10.M
I am having problems with a user control. I want my solution to have a separate project for holding my user controls.
The main project can get a reference to this user control project and can import this user control dll into my main project.
Thanks in advance,