First get the name of your database logs use ycsoftware select * from sys.database_files Next just run the following to truncate the logs use ycsoftware go dbcc shrinkfile (ycsoftware_Log,1) backup log ycsoftware with truncate_only dbcc … Read more
“SQL Server Setup failed to modify security permissions on registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib for user XXXX. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL … Read more
I am writing this post for all the Microsoft pundits out there whose answers to a question such as “How do i export data to an excel spreadsheet using ssis?” is the following “it is … Read more
MySQL TINYINT 127 SMALLINT 32767 MEDIUMINT 8388607 INT 2147483647 BIGINT 9,223,372,036,854,775,807 MSSQL TINYINT 255 SMALLINT 32767 INT 2147483647 BIGINT 9,223,372,036,854,775,807 Reference MSSQL http://msdn.microsoft.com/en-us/library/aa258271(v=sql.80).aspx MySQL http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
Add to 1 hour to the Current Date DATEADD(hh,1,getdate()) Subtract 1 hour to the Current Date DATEADD(hh,-1,getdate()) Add 1 hour to the Current Time and returns just the time part select Convert(varchar,( DATEADD(hh,-1,getdate())),8) Reference http://msdn.microsoft.com/en-us/library/ms186819.aspx
