Using MS SQL Server

Database security (non-existent?)
I recently downloaded and install SQLServer Express. I am considering using it as the backend db for my app (i.e. moving from the current PostgreSQL). I run sqlcmd without specifying any username or pwd, and I was suprised that I had access to the 'server', and could create and drop databses (admittedly I dr... 2 Jul 2008 11:53

Computing a column that is a percentage of the sum of another column
To keep things as simple as possible : I have a table with the following information: Unit1 Unit1 Unit2 Unit2 Unit2 Unit3 I want to return a result set that shows Unit1 2 33% Unit2 3 50% Unit3 1 16% Total 6 100% Any suggestions? ... 25 Jun 2008 08:48

Latest updates on SQL server 2008 tools and techniques
Find the latest updates in SQL server 2008 tools and techniques. Get details on database management, software testing, flowchart preparation and many more http://www.sqlserversoftware.blogspot.com ... 24 Jun 2008 21:35

Tool to chase down the consequences of adding field to DB tables?
Hi all, I'm tasked with adding a few fields to our database, and all of the stuff that goes along with it (updating c# UI code, etc.). The database is a few hundred tables, with all of the procs, logic code, etc. that goes along with it. The consequences (i.e. what breaks) of adding a new field should be larg... 24 Jun 2008 17:28

Applying tranaction log to old data file
Hi, on my SQL Server data file is corrupted. Unfortunately last backup was made about half year ago. Transaction log seems to be ok. Is it possible to restore data file from old backup and apply transactions from current transaction log? regards ... 26 Jun 2008 21:49

Latin1_General_BIN comparing two char strings
My database is Latin1_General_BIN. My table is called CUSTOMER. One column in this table (descr_id) is defined as char(10). When I query… SELECT * FROM CUSTOMER WHERE descr_id = ‘ABCD’ Result set from above query is: descr_id ABCD I get the same result back as I do when… SELECT * FROM CUSTOMER WHER... 24 Jun 2008 09:13

alter table query not working after working at least once. MS SQL 2000
(quincy451(a)yahoo.com) writes: Table already exists. [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'PK_begin_call_temp' in the database. [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint. See previous errors. This works the first time then... 24 Jun 2008 17:28

alter table query not working after working at least once. MS SQL 2000
drop table [dbo].[begin_call_temp] CREATE TABLE [dbo].[begin_call_temp] ( [Event_Datetime] [datetime] NULL , [Machine_ID] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Line] [smallint] NULL , [Outbound_Line] [smallint] NULL , [Call_Number] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NUL... 26 Jun 2008 16:41

Database naming conventions?
What database naming conventions do you use? Hi, I spent my whole Sunday reading database naming conventions,. And this only made me more confused. One thing that I do in my tables was one of the more “allways avoid” one. I allways prefix the column name with a prefix that identifies the table where It resi... 25 Jun 2008 18:06

Transact-SQL for Restore Filelistonly using a variable
I am trying to script the process RESTORE FILELISTONLY using an Exec() statement. I cant seem to get it to work with a variable. Here is what I have. Declare @Sql varchar(100) Declare @File varchar(100) Select @File = 'C:\atest\RO_Backup.bak' SELECT @Sql = ''''+ 'RESTORE FILELISTONLY FROM DISK=''' + '''' + @F... 22 Jun 2008 08:07