Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/awarren/worstpracticesmakingdatabasescasesensitiveoranythi.asp
2001-10-20
253 reads
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
Windows 2000 Advanced Server With SP2 SQL 2000 Enterprise With SP1 I have Install SQL2K with Active/Active mode with 2 instance names such as Node1 Local drive install SQL Program on D: Share storage Drive install Data in drive L: M: N: SQL Instance name as node1\sql2000_1 Node2 Local drive install SQL Program on D: […]
2001-10-18
2 reads
I am facing a problem while calculating a field from an aliased field. The err that it gives me is: Invalid Column name This is my code: select case EmployeesVestingSchedule.BasedOn when 'P' then Portion when 'T' then 0 end 'PerformanceBased_PerCent' , PerformanceBased_PerCent * Employee_Options.NoOfOptions/100 as PerformanceBased_Numbers, ---- this gives an error ---- Employee_Options.NoOfOptions from EmployeesVestingSchedule […]
2001-10-16
1 reads
Hello! I am trying to set up a package that would insert new user accounts from an Excel file into the appropriate SQL2k table. I'd like to include some error handling to catch when a new record tries to use a taken userID (which is the prmary key in my table). Ideally, the package would […]
2001-10-16
Hi, I would like to know how do i remove the publications from the tables which are already published.. Details of the problem : when i configure replication from a local sql server to a web server.. every thing works fine.. Now at a point of time i want to disable this replication process..(infact remove […]
2001-10-15
7 reads
I had tried Merge Replication. But due to some problem (supposedly connection problems)... some tables got replicated but at one point of time when the replication failed ... it had deleted data from the server (from where I was pulling data). Why did this happen... does merge replication firstly delete all data and then re-inserts […]
2001-10-14
4 reads
Hi, This query below is intended to generate a new table ordered on its EmployeeID column. SELECT * INTO db1..test1 FROM db2..Orders ORDER BY [EmployeeID] However, it generates a table where the first fith (consistently!) is actually the last fifth??? e.g. on my particular base table it orders the new table like such: _EmployeeID values______Rows […]
2001-10-08
1 reads
Can anyone direct me to some info on best practices for hooking up a database to the web? I am mainly concerned with security practices and these seem to be often overlooked in books and articles talking about web access. Our latest strategy is to create a partial copy of the production db's on the […]
2001-10-02
3 reads
2001-09-26
3,387 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers