I have a rails app that uses freetds to establish an ODBC connection into a SQL Server Database. This app is on a server running under mongrel, in theory. If I start the app with: sudo mongrel_rails start -e development -p 9000 -d I get S1000 (0) [unixODBC][FreeTDS][SQL Server]Unable to connect to data source However, when run w...
I am working on a site where I will need to be able to track ad impressions. My environment is ASP.Net with IIS using a SQL Server DMBS and potentially Memcached so that there are not as many trips to the database. I must also think about scalability as I am hoping that this application becoming a global phenom (keeping my fingers cros...
Which version of SQL Server I would need to purchase in order to be able to legally include in a web app I am going to package? In other words, I need to be able to build it into the package along with the app so when it is loaded on the users machine, they have a local db available. To date I've only worked with Sql db's on a server. ...
I think I made a mistake and I lost my connection to my SQL Server Express. In SQL Server Management Studio under security I disabled the login option. Now when I try to connect to the Server I get the message : "Cannot connect to HP16969\SQLEXPRESS". Additional informations : Login failed for user 'HP16969\Bernard (Microsoft...
If i have bills (from vendors), and invoices (to customers), would it be better to keep them separate (in two tables), or in a single table? What about vendors / customers? These are all relational-inheritance problems, can you give me some best practices regarding this? ...
I've created an assembly for CLR integration in SQL Server 2008. It has one reference to System.Web.Extensions, which is an issue because when I try to add my assembly, I get the following error: Assembly 'system.web.extensions, version=3.5.0.0, culture=neutral, publickeytoken=31bf3856ad364e35.' was not found in the SQL catalog. (Mic...
We have a high volume web application based on ASP.NET 3.5 and SQL 2008 where we hope to maintain high availability levels 24x7 without the need for a maintenance window. Over time, we have become reliant upon some stored procs which perform housekeeping operations to purge data which is no longer needed, compile some metrics, etc. O...
select * from ( select year, week, salesperson, count(*) as transactions, rank() over(partition by week order by count(*) desc) as ranking from sales where year = '2010', group by year, week, salesperson ) temp w...
How I can obtain the collation of a specific table in a database? Is it possible that a table have different collation in db? ...
I execute a bcp command in 2 computer. The first computer has windows xp and second one has windows server 2003. when I execute command in first, the bcp run successfully but when I run this on second one, occur this error: Starting copy... SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Code pag...
Hi all Here is the data Flag Zone Info Date R North AAA 2010-2-14 R North AAA 2010-2-24 T North AAA 2010-2-4 R South AAA 2010-2-23 T South AAA 2010-2-14 R EAST AAA 2010-2-...
What is the mechanism for Transaction Rollback in sql server? ...
For the first time in years I've been doing some T-SQL programming in SQL Server 2008 and had forgotten just how bad the language really is: Flow control (all the begin/end stuff) feels clunky Exception handling is poor. Exceptions dont bubble in the same way they do in every other language. There's no re-throwing unless you code it yo...
Consider two tables: Transactions, with amounts in a foreign currency: Date Amount ========= ======= 1/2/2009 1500 2/4/2009 2300 3/15/2009 300 4/17/2009 2200 etc. ExchangeRates, with the value of the primary currency (let's say dollars) in the foreign currency: Date Rate ========= ======= 2/1/2009 ...
I am in the process of building a corporate web site. We are looking for any open source or paid search engine based on the ASP.NET. It should be able to Search web content of all the pages in the site. All office documents. etc. If we have some searach reseults filtering based on the user type and styff. Please let me know what k...
I have a database table with the primary column defined as: ID bigint identity primary key I also have a text column MiddlePart. I'm trying to create a full text index, like so: CREATE FULLTEXT INDEX ON domaining.dbo.DomainName ( MiddlePart Language 0X0 ) KEY INDEX ID ON domaincatalog WITH CHANGE_TRACKING AUTO I get this e...
I want to run the following rename EXECUTE sp_rename N'dbo.Semesters.IsPublic', N'Tmp_ShowNCs', 'COLUMN' I get the error Msg 4928, Level 16, State 1, Procedure sp_rename, Line 547 Cannot alter column 'IsPublic' because it is 'REPLICATED'. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, ...
I have a User table and a ClubMember table in my database. There is a one-to-one mapping between users and club members, so every time I insert a ClubMember, I need to insert a User first. This is implemented with a foreign key on ClubMember (UserId REFERENCES User (Id)). Over in my ASP.NET MVC app, I'm using LinqToSql and the Repositor...
I am using this vb.net code file to call a procedure to get dates (among other things). When I execute this procedure in SQL 2005 Server Management Studio, I get about 10 columns. However when I execute this code, the dataset seems to only have one index value, maybe I am misunderstanding something. When I change this ds.Tables(0).Rows...
SQL Server 2008 supports data at rest security through TDE (Transparent data encryption), but the encryption excludes files stored on harddrive through FILESTREAM feature. How have you handled encryption of this data on file system stored through FILESTREAM? Encrypted File System seems to be an option, but would cause problem during DB...