Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
@@servername = NULL
Hi ! I wanted to set up my sql server for replication I always get the errormessage : "Error 14114 : '[null]' is not configured as distributor" the statement SELECT @@servername returns NULL I tried to change that with "sp_addserver ..." and got 3 times '1 row affected' afterwards I restarted...- Moonrider
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Setup and Administration
-
disable/enable constraints of all user tables
the following stored procedure DISABLES constraints of all user tables : CREATE PROCEDURE dbo.disable_constraints AS DECLARE @tabelle varchar(50) DECLARE tbl_tabellen CURSOR FOR select [name] from sysobjects where type = 'U' OPEN tbl_tabellen FETCH NEXT FROM tbl_tabellen INTO...- Moonrider
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
startposition of selected text ???
function sel_text() { var selectedHTML = document.selection.createRange().htmlText; alert(document.selection.createRange().selectionstart); var allHTML = document.all.FirstCol.innerHTML; var LinksZahl = allHTML.indexOf(selectedHTML, document.selstart); var Links =...- Moonrider
- Thread
- Replies: 3
- Forum: Javascript
-
View & Trigger works just in QA
Hi! I wrote this trigger on a view to write the data into two different tables : Don't worry about the strange field and tab-names and the print-statements: IT'S GERMAN CREATE TRIGGER vieRechnung_Ins ON dbo.vieRechnung INSTEAD OF INSERT AS SET NOCOUNT ON DECLARE @Nr VarChar(12)...- Moonrider
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
