Edit table error in SQL server 2008
Hi I use SQL server 2008 and I have created some tables but I want to edit some of them but it does not let me and will show an error ! how can i solve my problem ??? please help me ...
sql-server
Update table.column with another table.column with common joined column
Hit a speed bump, trying to update some column values in my table from another table. This is what is supposed to happen when everything works Correct all the city, state entries in tblWADonations by creating an update statement that moves the zip city from the joined city/state zip field to the tblWADonations city state TB...
# of servers for secure/best-practice setup of SQL Server 2005, Reporting Services, IIS
I want to set up a SQL Server 2005 database, a Reporting Services instance, and IIS to view reports via the web and web applications. How many servers are optimal for this setup? I hear various things about the security of having IIS on the same box as a SQL Server. I'm preparing to price out some servers for this type of configuration...
SQL Server connection identification
Hi, I have several developers which connect to production and test servers where we have DBs with similar names and structures. In SSMS there are info related to the connection, but sometimes are not properly displayed and/or hidden. I know that it is possible to customize the status bar of each connection in SSMS, but how do you ensu...
Microsoft Sync Framework
I've got a central SQL server database. My solution has a WCF service responsible for synchronizing data with clients running SQL Server or SQL Server Express. The service uses Microsoft Sync Framework and it works well, but the Sync Framework requires a direct connection to my client's server, and clients that are running SQL Server Ex...
How to programatically create a database from an ADO.Net Entity Model?
I am using .Net Framework 4.0. I have an entity model (.edmx) and I have a menu option in my program for connecting to an existing database or creating a new one. When the user selects to create a new database, I want to generate the database and schema from the entity model. Any idea how to do so? ...
How can I dump my SQL Server Database Schema to a human readable & printable format?
I want to generate something like the following: LineItems Id ItemId OrderId Price Orders Id CustomerId DateCreated Customers Id FirstName LastName Email I don't need all the relationships, the diagram that will never print correctly, the metadata, anything. Just a list of the tables and their columns in a simple text format...
help optimize sql query
I have tracking table tbl_track with id, session_id, created_date fields I need count unique session_id for one day here what i got: select count(0) from ( select distinct session_id from tbl_track where created_date between getdate()-1 and getdate() group by session_id )tbl im feeling that it could be ...
How to solve the sql server 2008 restore error 3203
I am trying to restore the database in SQL Server 2008. The backup file is SQL Server 2008 from another PC . When i want to restore show me the error TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInf...
How to list all duplicated rows which may include NULL columns?
Hi guys, I have a problem of listing duplicated rows that include NULL columns. Lemme show my problem first. USE [tempdb]; GO IF OBJECT_ID(N'dbo.t') IS NOT NULL BEGIN DROP TABLE dbo.t END GO CREATE TABLE dbo.t ( a NVARCHAR(8), b NVARCHAR(8) ); GO INSERT t VALUES ('a', 'b'); INSERT t VALUES ('a', 'b'); INSERT t VALUES ('a...
"NT AUTHORITY\ANONYMOUS LOGON" error in Windows 7 (ASP.NET & Web Service)
I have an asp.net web app which works fine in Windows XP machine in a domain. I am porting it to a Windows 7 stand alone machine. The app uses a web service which makes a call to sql server. The web server (IIS 7.5) and SQL Server are on the same stand alone machine. I enabled Windows authentication for the website and web service. The ...
T-SQL - Is there a (free) way to compare data in two tables?
I have table a and table b. (SQL Server 2008) Both tables have the exact same schema. For the purposes of this question, consider table a = my local dev table, table b = the live table. I need to create a SQL script (containing UPDATE/DELETE/INSERT statements) that will update table b to be the same as table a. This script will then b...
Can I install a different edition of a SQL Server 2005 instance?
Possible Duplicate: Can I install a second SQL Server instance on the same location as the first instance? Hi guys, Can I install a different edition of a SQL Server instance? I mean, let's say I already installed standard edition of SQL Server 2005 on my Windows XP SP3 machine, then I want to install another instance and use...
Calling SQL Functions directly from C#
I have a requirement to run a query against a database that will return either a zero or one (Checking for existance of specific criteria). The Tech specs I've been given for review state that I should be creating a stored procedure, that will return a single row, with a single column called "result" that will contain a bit value of 0 or...
SQL Server Performance
I have tables in which 35000 to 40000 records are available. Inspite using ajax the performance of the website is very low. Can any body please suggest some ideas or tips for the problem. Thanks in advance. ...
How to retrieve all errors and messages from a query using ADO
When a SQL batch returns more than one message from e.g. print statements, then I can only retrieve the first one using the ADO connection's Errors collection. How do I get the rest of the messages? If I run this script: Option Explicit Dim conn Set conn = CreateObject("ADODB.Connection") conn.Provider = "SQLOLEDB" conn.ConnectionStrin...
Installable ISAM not found
I have a requirement in which, i upload excel sheets to sql server database. The business logic is executed and display as reports in php. It is working fine till yesterday. Today i tried to upload excel files. It is throwing an error message stating:- The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" could not f...
DB Design Pattern - Many to many classification / categorised tagging.
I have an existing database design that stores Job Vacancies. The "Vacancy" table has a number of fixed fields across all clients, such as "Title", "Description", "Salary range". There is an EAV design for "Custom" fields that the Clients can setup themselves, such as, "Manager Name", "Working Hours". The field names are stored in a "C...
Loading Dimension Tables - Methodologies
Hello, Recently I been working on project, where need to populated Dim Tables from EDW Tables. EDW Tables are of type II which does maintain historical data. When comes to load Dim Table, for which source may be multiple EDW Tables or would be single table with multi level pivoting (on attributes). Mean: There would be 10 records - ...
SQL Server lock/hang issue
Hi, I'm using SQL Server 2008 on Windows Server 2008 R2, all sp'd up. I'm getting occasional issues with SQL Server hanging with the CPU usage on 100% on our live server. It seems all the wait time on SQL Sever when this happens is given to SOS_SCHEDULER_YIELD. Here is the Stored Proc that causes the hang. I've added the "WITH (NOLOCK...