I have a very simple case and I wanna have some suggestion from guru in this forum. Currently, I am using a SP to build a Live To Date history table....
I would like to know is there anyway that SQL Server can call external assembly function without creating a reference internally. I can do it in SQL...
I have installed visual studio 2008 and .net framework 3.5 in my computer. I have then created an assembly in 3.5, but when I try to create assembly...
When I restore a database from mdf and ldf file, all the primary key are lost and the data type are not the same. How can I recoever the primary key...
I need to create a report on the traffic distribution to our site. It means that I have to find # of people from different country. THe IP Look up...
How can I know when the deadlock occur in SQL Server besides is slowed down or stop running? Anyway to resolve it besides waiting itself to kill the...
I have moved the sql server file from 1 machine to another machine. After I restore it, it lost the permission setting and the user config I remember...
HI, I would like to know if someone can configure 1 sql statement that can do the following. example: I have a table containing 1 2 3 4 5 I need...
I am a newly hired person in a company. Their server is having a big performance issue and I tried to re-index the table at the beginning. The...
Separate names with a comma.
