I.T. Notes

If you get an error message as in subject line; add [assembly: NeutralResourcesLanguageAttribute(/*"xx-XX" (for example :*/"en-US"/*)*/, UltimateResourceFallbackLocation.Satellite)] statement into AssemblyInfo.cs file on your project. Good Luck...

Here is a basic stored procedure concept i personally offer to advanced SQL Server users; SET NOCOUNT ON DECLARE cur_sor CURSOR DECLARE @CURSOR_FETCH_STATUS INT DECLARE @varible1 as [anytype] ,@variable2 as [anytype],.... SET cur_sor = CURSOR LOCAL FORWARD_ONLY STATIC READ_ONLY FOR SELECT .... FROM ..... /* for Arguments Detail check http://msdn.microsoft.com/en-us/library/ms180169.aspx */ OPEN cur_sor BEGIN TRY BEGIN TRANSACTION FETCH NEXT FROM cur_sor INTO @varible1,@variable2 ,... /* not more than selected columns above*/ SELECT @CURSOR_FETCH_STATUS = @@FETCH_STATUS WHILE @CURSOR_FETCH_STATUS = 0 BEGIN ....... /* INSERT,DELETE,UPDATE ( DML) or any other process */ ....... FETCH NEXT FROM cur_sor INTO @varible1,@variable2 ,... SELECT @CURSOR_FETCH_STATUS = @@FETCH_STATUS END COMMIT END TRY BEGIN CATCH PRINT(ERROR_NUMBER()) PRINT(ERROR_SEVERITY()) PRINT(ERROR_STATE()) PRINT(ERROR_PROCEDURE()) PRINT(ERROR_LINE()) PRINT(ERROR_MESSAGE()) ROLLBACK END CATCH CLOSE cur_sor DEALLOCATE cur_so

If you get an error message on Replication Monitor that is given by Distributor Agent about "Error executing a batch of commands Retrying individual commands" and figure out table does not replicate to subscriber.There will probably occur data integrity problem.Check foreign key or any other relations,constraints over the table and verify in subscriber database Nevertheless you may omit the error adding "-SkipErrors 20598 " parameters into Replication distributor agent job... good luck,

-Creating CREATE PARTITION FUNCTION IdPartition ( int ) AS RANGE RIGHT FOR VALUES ( 10000 , 20000 , 30000, 40000, 50000 ) CREATE PARTITION SCHEME IdSchema AS PARTITION IdPartition TO ( Filegroup1,Filegroup2,Filegroup3,Filegroup4,Filegroup5,Filegroup6) Altering ALTER PARTITION SCHEME IdSchema NEXT USED Filegroup2 ALTER PARTITION FUNCTION IdPartition () SPLIT RANGE ( 100000 ) retrieving partition status of databases SELECT $partition.IdPartition(DCEProjects.ID) AS [Partition Number],max(DCEProjects.ID) FROM dbo.DCEProjects --WHERE $partition.IdPartition(DCEProjects.ID) = 2 GROUP BY $partition.IdPartition(DCEProjects.ID) ORDER BY [Partition Number]

Here is T-SQL Statment; Select A.name 'TabloAdi_TableName' , B.rowcnt 'SatirSayisi_RowCount' from sysobjects A, sysindexes B where A.id =b.id and A.type = 'u' and indid <2 order by TableName good luck,

Syntax : is_srvrolemember(SQLServerRole in String) Returns : if user has right for given return will be 1 for example; if (not (is_srvrolemember('sysadmin') = 1)) -- Make sure that executing by SQ. begin raiserror(...) return(1) end

There is good statement that you can see what is going on Database DBCC SQLPERF('waitstats') it collects wait status group by Wait Type.