copy a table with data to another db in sql server 2005 express
hi, i've a db with a table. i want copy it with the data in another db. How can i do it in sql server 2005 express? thanks ...
sql-server-2005-express
Unable to cast object of type 'System.Object[]' to type 'System.String[]'
I am developing a C# VS 2008 / SQL Server website application. I am a newbie to ASP.NET. I am getting the above error, however, on the last line of the following code. Can you give me advice on how to fix this? This compiles correctly, but I encounter this error after running it. All that I am trying to do is to store the items from...
Replication SQL SERVER
In my Production Server i have replication which working fine, i do have Distributed Database which as 2 subscriber db . My data is replicated from Production envi (working fine) but while data gets replicated to Distributed database in Subscriber it throws an Error Err msg = Replication-Replication Distribution Subsystem: PRD01-XYZ-VR...
How do I add NETWORK SERVICE login via SQL Authentication?
I am trying to add the NETWORK SERVICE login cause I still can’t connect to the AdventureWorks3 database. But I want to add this NETWORK SERVICE login via SQL Server Authentication and not Windows. When I select Windows authentication, it lets me create this login. But when I select SQL Server Auth, it gives me the following error: Crea...
How can I avoid a deadlock between these two SQL statements?
I have two stored procedures running in separate threads, running on SQL Server 2005. One procedure inserts new rows into a set of tables and the other procedure deletes old data from the same set of tables. These procedures are running into a deadlock on the tables DLevel and Model. Here is the schema: Table DFile: Primary Key = D...
SQL Server 2005 Express - could not open a connection
I installed Microsoft SQL Server 2005 Express edition on my Vista Ultimate computer. However, when it opens I enter my computer name / SQLEXPRESS. When I click the Connect button, it gives me an error message. Under the configuration tools I cannot find the SQL Server Surface Area Configuration. It only has SQL Server Error and Usage R...
Cannot start "SQL Server Management Studio Express"
I use SSMSE normally yesterday but today when I started the SSMSE together with Adobe Dreamweaver CS3, the SSMSE window show and then exit immediately. I'd tried several times and also open the Event Viewer to see if any error occured but find nothing. I also went to the Add/Remove Programs and tried to "repair" the program but nothin...
Visual Studio 2005 SQL Server Express edtion username pass
Visual Studio 2005 I connect with SQL Server Express edition with SQL Server Management Studio Express using Windows authentication. When I installed Visual Studio 2005 I didn't get asked for SQL Server Express edition user name or password. How can I connect without Windows authentication ? ...
Error opening .mdf file through SQL Server Management Studio Express
I am doing a project of a web enabled database. I have created the database file in my PC. Now when I just want to open .mdf i.e. of the database I created, I cannot open it in other PC. I even had copied the .ldf file i.e the log file to that PC. Since I need to transfer the database to the Server later, I don't know how I will dump t...
Insert into table variable from stored procedure not working
Using SqlServer 2005. Here is the procedure code from a second stored procedure that calls the first one: USE [SBS]; GO SET ANSI_NULLS ON; GO SET QUOTED_IDENTIFIER ON; GO CREATE PROCEDURE [dbo].[EU75_ALL_SP] WITH EXECUTE AS CALLER AS DECLARE @COLUMN_MAP_TEMP TABLE (COLUMN_VALUE varchar); INSERT INTO @COLUMN_MAP_TEMP EXEC SBS.dbo.COLUM...
Cascade tree deleting in MS SQL Server Express 2005
One table has name "Stages", every Stage can have 0..infinity childrens, in table Stages there are column named Parent. This column is foreigh key for same table Stages. How to make cascade deleting in this tree? I want to on deleting any row in this table, auto delete all their childrens and childrens of their childrens....etc При тако...
unable to restore database in sql server (single_user)
I am trying to restore a database in my sql server 2005 express edition. I know that to restore the database I need to make it to single user. I am giving this command to make it to single user use [master] alter database database_name set single_user with rollback immediate This command executed properly and I can even see a small ima...
Same name tables under different schemas with SQL Server 2005 Management Studio Express
I know how to create a new schema and write a DDL script to create tables with the same name that reside in different schemas in the same database. I want to know how to do that using SQL Server 2005 Management Studio Express. To repeat, I want to know if I can create two tables having the same name but residing in different schemas of ...
create database in sql server 2005 express edition without Browser
I have an SQL server Express edition Instance and I need to create a database on it but I don't have the Sql Browser how can I do it other wise ...
How do I retrieve data from SQL server table which has two columns say PatientID and TestNo, Differnt TestNo can have same patient ID
I have a database (SQL server 2005 Express) table wth columns PatientID (more than 1 records can have same patient ID) and TestNo. I want to retrieve the maximum of testNo column among all the records with same PatientID.What should be the SQL statement to do so?I am using RecordSet pointer to access the records in a vc++ application. ...
ASP.NET app wont share database with Sql Server Management Studio Express
I have an ASP.NET 3.5 app with a SQL 2005 Express .mdf database file in its App_Data folder. Lets call that Foo.mdf. On its own the ASP.NET app can connect to the database with no problems. So far so good. Then, if I install Sql Server Management Studio Express on the server and start it, it finds the local SQLEXPRESS instance and conne...
How do I secure the data in my winform's SQL 2005 Express database?
I have a c# winform application that uses SQL 2005 Express. The application creates math and reading quizzes and is marketed to parents of school-aged children. The parents purchase and download SQL files containing quizzes from my website and install them in the application (which is installed on their child's computer). I have two S...
Cannot Connect to the SQL Server , SQL 2005 and it doesnot want to connect to the server and there is no Server name ?
TITLE: Connect to Server Cannot connect to .. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: ...