Is there a way to set some column of each row in a table to some unique value e.g. update mytable set myCol=rownum() using SQL (not T/SQL) on SQL Server 2000. I can't touch the schema but I do have a spare column or two. ...
Im planning to implement triggers on all my DML statements for log management. So please identify if there are some issue or drawbacks to do so. ...
Dear Friends, I found the following value in my SQL server Startup paramenter what is the meaning of that: -T1118 Thanks in advance. ...
hi all, my system is connected Trhough LAN.. totally four systems connected. and all systems having MS SQl server installed in it. now i need to retreive that - which all server's i can connect to..? server names - for connection string...!! thanx' ...
I want to know the wt is the exact difference between SQL Server 2008 vs SQL server native client ? ...
When I use Symmetric Encryption on a database and then back it up and then restore it to another SQL Server and use the same keys I can't decrypt the data. Is there a way around this? Using SQL Server 2008 Code: GO CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'PASSWORD' GO CREATE CERTIFICATE PasswordFieldCertificate WITH SUBJECT = ...
I want to Install New SQL Server 2008 Instance. I want to know whether Installing New Instance would create any problem to already installed instances. I have SQL Server 2005 Instances transformed to SQL Server 2008 and It has many databases, so If i installed SQL Server 2008 New Instance will i be able to see all my previously install...
HI, folks, Previously, I had a SQL Server 2008 installed, but then I deleted it, and installed SQL Server 2008 Express Management Studio. And now I can't connect to local computer. I get error : A network-related or instance-specific error occured while establishing a connection to SQL server. The server was not found or was...
I use Microsoft Visual Studio 2010 Professional (I installed all components). Here is what I'm trying to do. I create a new ASP.NET project. Then I open Server Explorer (View->Server Explorer), right click on Data Connections and choose Add Connection. Then I choose Microsoft SQL Server and press Continue, but the 'Server name' list is ...
Possible Duplicate: How to install fulltext on sql server 2008? I have recently installed SQL Server 2008 R2 When I tried to create Full Text Search Index Example CREATE FULLTEXT INDEX ON DATABASENAME.dbo.MYTABLE ( column_to_index Language 0X0 ) KEY INDEX myindex ON DATABASENAMECatalog WITH CHANGE_TRACKING AUTO It had giv...
I have a Users table and a profile table. The reason they are separate is because information about the user can be put in before they are registered for the site. The problem I'm running into is that when I set the relationship in Sql Server it wants to create a one to many relationship. I don't see any way to change this. ...
Trans Id Date Description Credit Debit 1 12/05/2009 Amount Deposited 1000 1000 2 15/05/2009 Amount withdrawn -500 500 3 20/05/2009 Deposited 2000 2500 4 25/05/2009 Amount withdrawn -1000 1500 1500 Trans I...
I'Ive been working on Java/Hibernate/BlazeDS integrations - but am getting stuck with sending the child entities in a one-to-many relationship across BlazeDS... For starters I have a Client and ClientLinks table in MS Sql Server Now java-side in Client the property defining the ClientLinks entity is private Set clientLinks = new HashS...
I am interested in people's opinions on MySQL vs SQL Server. Our database is fairly simple; no stored procedures, and we use NHibernate as our ORM layer. I would like to make a case for switching from SQL Server to MySQL cluster on Linux. We need an enterprise level, clustered DB with failover and load balancing. Any opinions pro or con ...
Here are my steps: Created the controls manually by dragging a textbox then a button besides it which i think its not the right way to do it. Example: Any idea which control should i use? 2.The column's datatype (in sql-server) is varbinary(MAX) which will hold the document file. Is this the correct datatype for holding documents...
Hi, We are using sharepoint server 2007 and if i create any files and folders the sharepoint site is throwing some error "Exception from HRESULT: 0x80040E14" and i checked event viewer.here also some error showing " CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limi...
Hi all, I have basic knowledge of SQL Server and interested to gain much more and for that I would like to give SQL server Certification exam, Can Anyone please Suggest me any good certification and exam ?? ...
Hi All, A movement is afoot in my place of employ to move away from using #temp tables and instead to use permanent physical tables with SPIDs. Whenever one would have previously INSERTed INTO a #temp table, now an INSERT INTO dbo.MyPermanentTable (SPID, ...) VALUES (@@SPID, ...) is required - together with a bunch of DELETE FROM dbo.M...
Just curious if this is the best way of updating the balances? It executes fine but I am new to SQL Thanks for any advice... */ CREATE DATABASE KFF GO USE KFF CREATE TABLE COA ( Account INT NOT NULL, Description VARCHAR(250), Short_Description VARCHAR(250), ) BULK INSERT COA FROM 'C:\COA-IMPORT.TXT' WITH ( FIELDTERMINATOR = ',', RO...
Can you monitor SQL server to tell exactly what queries it is running? We have an application that is exhausting the application pool. A server administrator has sent us a report from Debug Diag [http://www.microsoft.com/downloads/details.aspx?FamilyID=28bd5941-c458-46f1-b24d-f60151d875a3&displaylang=en][1] which shows threads runni...