I have created a database system for a cms for a news website. I want to have only 4 roles in my db system : Admin, Author, Editor and Guest ( who only read the web pages). But there are some pre-defined roles in every db system like sys and db_owner and… and they are not removable but I want the only 4 roles I mentioned above. How can I...
I googled. I asked in forums but I could not find any forum, newsgroup or discussion boards for "trainers" (teachers, coachers) and supporters (writers of courses, sysadmins of labs, et al) of professional courses for IT developers Might be the certified by major vendors trainers have the sites with forums but they are closed to non-...
is view in database updatable ? if yes , how ? if no, why ? ...
Hi. I have a table called [Test], which has a single column [Id] int. I open a transaction, insert one row to the table and NOT commit it. begin tran insert into [Test]([Id]) values(1) In another request I want to select data from table [Test]. How can I read only commited data immediately? Readcommited table hint holds a lock. sel...
It is written everywhere that data in SQL Server is written in pages of 8K (8192 B) each with 8060 bytes for data and the rest is overhead (system info). Though, the recent article [1] gives code example illustrating, as I understood, that 8078 bytes of data fit into a page. What do I miss in understanding 8,060 B per per page? I ve...
I am looking for a database that could handle (create an index on a column in a reasonable time and provide results for select queries in less than 3 sec) more than 500 millions rows. Would Postgresql or Msql on low end machine (Core 2 CPU 6600, 4GB, 64 bit system, Windows VISTA) handle such a large number of rows? Update: Asking this q...
I am trying to understnad how SQL Server allocates and reserves space. Having run the examples from the article "How table design can impact your SQL Server performance?" [1], I received the results [My 1.1] diverting from those in article [1.1]. Why? Why in one case the excessive space is reserved/allocated (all cases in [1]) but ...
I'm building some HTML to be included in the body of an email and sent using sp_send_dbmail. I'd like to right-align some of the columns. Is there an easy way to do this (short of rewriting it using FOR XML EXPLICIT)? declare @html varchar(max) set @html = '<table cellpadding=0 cellspacing=0 border=0>' set @html += cast( (sele...
I want to Achieve the following: Current State of table (my_table) id totalX totalY totalZ --------- -------------- -------------- -------------- 9 34 334 0 10 6 56 ...
could someone pls tell me the version requirements for query notification? we are running sql server 2008 and use ODBC 3.0 but are still on visual studio 6. on compile some of the ODBC parameter (ex: SQL_SOPT_SS_QUERYNOTIFICATION_OPTIONS) are not found. any help would be greatly appreciated. thanks in advance, Bill Riggio ...
I am using the Java Joda Time library, and have a date and time stored as an org.joda.time.DateTime object. How can I reliably convert this DateTime object into a String that will be parsed correctly by SQL server (including timezone), such that I can use it in an INSERT SQL statement? ...
I am testing the error-handling of an Access-VBA controlled process: A script in an Access 'controller' DB starts. The script starts a macro in a 2nd Access file (the 'database'). The macro in the 'database' file runs a bunch of maketable queries. These queries pull from tables linked to an ODBC source (SQL-Server actually). When thi...
I have a stored procedure that takes a table name and writes out a series of INSERT statements, one for each row in the table. It's being used to provide sample, "real world" data for our test environment. It works well but some of these sample rowsets are 10, 20k records. The stored proc writes them out using the PRINT statement and ...
Hi Allm I have been working on a new project for a little while and already have the Database in sqlServer2008. I would like to put the DB into a database project to make installation better. Is there a way to import an exisiting database into a DB project? Thanks, EDIT: This is in VisualStudio 2010 btw... oops! ...
I'm using Hibernate Annotations and trying to save an object. But when saving object I get: Cannot insert the value NULL into column 'status' The thing is that in my SQL Server 2008 configuration that field is defaulted to '0'. Now I dot not want to manually set the default value in my Java code like status='0', because I think this...
I am soliciting for suggestions on reporting solutions We develop a lot of in house projects(.net and sql server). For larger database we use business objects and build universes for reporting so that analysts or report writers can build reports and developers dont need to be involved. Many of our projects house important data, but ar...
I seem to be facing a strange issue in SQL 2008. I have a query which runs fine and fast from query analyser, but times out if run through a stored procedure! The SP just starts with this query and has no other code before this query SELECT col1,col2 FROM TBL1 (nolock) INNER JOIN TBL2 (nolock) ON tbl1.col=LEFT(tbl2.col1,LEN(tbl2.col1)...
Dear friends, I have installed SQL Server 2008 express and logging in through windows authentication, it doesn't allow me to do anything. How do i change sa password or gain full privilege in my local computers 2008 express ? I am using windows 7. ...
I have two "date" fields that I need to join on. The first is a normal datetime in the format yyyy-mm-dd hh:mm:ss The second is a varchar(8) in the red-headed step child format mmddyyyy Now this gets painful because there is no easy way to convert to the corresponding type. There is a built-in format that is yyyymmdd but that does...
I´m using Delphi 5 with SQL Server 2000 here. I have created an ADOQuery on top of an updatable view with an INSTEAD OF DELETE trigger. The updatable view is basically used for controlling soft deletes. It filters out records which are marked as deleted and it hides the controlling column as well. It all works fine when I´m issuing di...