On my local machine I have a SQL Server DB called Sales at the default location. I want to create a connection to this db but when I try open it I get no permissions. I'm the admin on my machine. Any help to resolving this is greatly apprec ...

What are the differences between Mongodb versus Sql Server? It seems Mongodb is in between a nosql database and a relational database. Reference: [url=http://www.mongodb.org/]http://www.mongodb.org/[/url]

I just got my computer upgraded at work and it has windows 7. So while we were upgrading, I upgraded my Visual studio from version 5 to version 8 and SQL Server 2005 to 2008. I have a reporting project that I use to create reports (it cr ...

What exactly are the benefits of using sql server schema's? Is it for partitioning the database permission wise or something else?

I want to purge all rows in a table except for the row with ID = 1. I then want to reseed the table so that the next row that is inserted will have the ID value of 2. I remember that you can reseed the identity column, how can I do th ...

Sql server has a data type named float (floating point). Which data type in c# best matches float?

I can't seem to figure out how to create a foreign key relation using sql management studio. Creating a primary key, setting the increment etc. I have done but where do I set a FK on the table?

I dropped all my database tables in the designer when setting up my linq to sql .dbml file. Now I modified some columns in a table, how do I refresh my dbml file with the updated table structure?

My database needs to be analyzed for the number of rows and actual disk space it is using. Is there a way to query the database, and list all the tables with row/disk usage information?

hi all i'm trying to install the sql native client on the client side machine in order to access my sql server 2008 database that placed on my server, i searched on microsoft website and i found this: [url]http://msdn.microsoft.com/en ...

If i have a foreign key on a table that I haven't actually setup as a foreign key, will setting the column as a FK create any sort of index on the table?

I need to store email attachments, which may be an image,file, or document in sql server. Which datatype should I use for the column? would it be nvarchar(MAX)?

I have a Products table with columns: ProductID INT PK SoldCount INT My other table, ItemsSold, contains items sold: ProductID INT FK Quantity INT So this is a many to one relationship. I want to update the Product.SoldCo ...

I need to create a report that will return all the results in our sales table, grouped by day. So the report will return, row by row, all sales for the given day summed together. My sales table looks like: Sales -ID int pk -produ ...

If I download a backup of a database and store it on my hard drive, when I go and restore the database, will the restore process create a copy of that file and move it to the sql server folder i.e. /data/mydatabase or will it just reference ...