Hi, I was trying to do a database mirroring( for learning purposes). But the mirroring process failed. I am currently having sql server 2005...
Hi, I am having a table( a Junction Table aka Cross Reference table ) named XrefList, This table is holding TableIds Which are the primary keys of...
Hi, This is not much related to sql server 2005; but I hope some one among You might have encountered such problem in his/ her experience. I am...
Hi, I am having a newbie question here which was asked in an interview: How to find the fifth largest salary from an employee table where the salary...
Hi, Is there any performance benefit from a self referencing foreign key, If I have a choice for reference from other table or the current table;...
Hi, I need help regarding the identity column. I have a column whose Identity seed was 1 when the column was initially created. Now I have to change...
hi, I need help with the following table designs. CREATE TABLE dbo.one( one_a INT IDENTITY(1,1) NOT NULL, one_b VARCHAR(50),--This will be having a +...
Hi, I am new to this stuff, I tried Restoring my database through the script which is as follows: RESTORE DATABASE db FROM DISK='D:db1.bak' WITH...
Hi, I have read a number of articles regarding nonclustered, clustered indexes, about included columns But now I have become confused Like I did a...
Hi, is it possible to get the name of the database through some t-sql actually I am creating a procedure where I have to get the name of database...
Hi, I need some help with table design I am having a table here CREATE TABLE dbo.lists( columna INT IDENTITY(1,1) NOT NULL, columnb VARCHAR(1000)...
Hi, I am little new to setting a job agent, I have created a job agent through SSMS it has two steps, I have done that as well, The job agent is...
Hi, I am new to Database administration, I am having a problem regarding database maintenance, creating maintenance plans; I am having over 6...
Hi, I am just wondering, how do You select( or Whats the selection procedure to) which posts or threads You sent in the newsletter? I can see my...
Hi, is it possible to raise an alert and send an email to an operator, when some value is inserted in a table? I don't want to raise an error here....
Hi, is it possible to access the elements of the currently inserted row in a table( I have never designed a trigger) Please see this table...
Hi, I need help with proc sp_executesql The following script when run shows an error I am not able to debug the script or may be I am using it...
Hi, A Basic Question? Is there a parameter to know the depth of the calling procedure; just like @@TRANCOUNT which reports the open transactions, is...
Hi, I am new to SQL database administration, I have created a login/user for a database, is there a way I can check that what objects has been...
Hi, I have a basic question here: I have two tables( dbo.some_table, dbo.some_other_table), there is a columna in dbo.some_table, I have created...
Separate names with a comma.
