BISHOP33
Last Activity: Sep 18 '07, 05:01 PM
Joined: Feb 21 '07
Location:
-
You need to attach the database to the default instance. (SQL Server) Once attached, you can view the tables or data in that .mdf file. -
BISHOP33 replied to Getting an Error while attaching the database using System Architect Enterprise managin SQL ServerIs the log file there as well?Leave a comment:
-
If I understand you correctly...the password complexity checkbox is in the properties of the login (user) you are trying to use. Open the default instance on your server, expand the security folder and click on the logins folder. Right click the user you are attempting to login with and select properties. In the middle of the properties page you will see 3 check boxes with the options you are seeking. Hope this is what you needed.Leave a comment:
-
.MDF and .LDF are usually associated with SQL. In order to view the data you will need SQL Server. The .MDF file is the primary file.Leave a comment:
-
This will reseed the identity no for a column in a table.
declare @intCounter int
set @intCounter = 0
update (YOUR_TABLE)
SET @intCounter = (YOUR_COLUMN) = @intCounter + 1Leave a comment:
No activity results to display
Leave a comment: