tag:blogger.com,1999:blog-77033703810854630132019-01-16T12:45:37.283+01:00All that I know about SQL Server 2000, 2005, 2008 and 2012Nil CGnoreply@blogger.comBlogger61125tag:blogger.com,1999:blog-7703370381085463013.post-9339819082479409152013-10-30T16:50:00.000+01:002013-10-30T16:50:21.290+01:00

Sometimes, there are people who needs to work with SQL Server and Windows authentication, but they are external employees and their notebooks are loggued into different domain. Example: SQL Server from Domain XXX External Employee with PC from Domain YYY External User Account of XXX Domain logged with YYY Domain. Trying left shift + right button mouse and select execute SSMS like another user.

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-6590528593699848592013-07-25T11:41:00.000+02:002013-07-25T11:41:30.623+02:00

Buena opción para obtener más almacenamiento de forma gratuita. 100GB Gratis de almacenamiento en Shared

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-65227107273239044802013-06-18T12:34:00.000+02:002013-06-18T12:34:14.708+02:00

There is an issue with the SQL Server Database engine components of original Cumulative Update 6 package (CU6). Microsoft release a fix to all servers with CU6 installed, in order to repair the error. (Index corruption ocurred). There is a COD (Critical on-demand) for installed CU6 http://support.microsoft.com/kb/2830140/en-us Microsoft removes CU6 link and creates a new Cumulative Update, CU7

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-50924652925376481632013-06-14T10:15:00.001+02:002013-06-14T10:15:41.479+02:00

I want to share with us... Successfully passed: Exam 70-462: Administering Microsoft SQL Server 2012 Databases

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-14079959108575299402013-05-10T13:07:00.003+02:002013-05-10T13:07:40.468+02:00

I’ll explain the scenario: It’s needed to drop Queues and services that aren’t in use, I’ve a mirrored DB’s for each country on different servers. DB’s are in FULL mode, with full backup at night and Log backup hourly. All queues were dropped correctly, except in one server, it’s running for a long time, and never ends. I tried to disable and enable Service broker. It didn’t work. “The

Nil CGhttps://plus.google.com/116806974987536440963noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-56167922045161554052013-04-24T09:06:00.001+02:002013-05-02T09:09:26.025+02:00

sp_procoption sets stored procedure for autoexecution. It runs stored procedures every time that SQL Server instance is started. (Applicable for SQL Server 2005 and above versions). See the sintax: sp_procoption [ @ProcName = ] 'procedure'      , [ @OptionName = ] 'option'     , [ @OptionValue = ] 'value' [ @ProcName = ] 'procedure' Is the name of the procedure for which to set

Nil CGhttps://plus.google.com/116806974987536440963noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-39414066933564303132013-03-27T17:19:00.000+01:002013-03-27T17:19:13.722+01:00

Quizás os haya sucedido que trabajando con cualquier fichero Excel (versiones 2007 en adelante), que ocupa por ejemplo 5MB, sin darte cuenta, ha pasado a ocupar 15MB. ¿Por qué? No hemos añadido nada fuera de lo normal como para que se triplique el tamaño (En mi caso contengo 50 hojas). Bien, la explicación que da Microsoft al respecto es la siguiente: Microsoft Excel sólo guarda la parte

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-38185625033057038692013-01-03T19:30:00.000+01:002013-01-04T13:27:59.555+01:00

The Center for Internet Security (CIS) Security Benchmarks Division released “CIS Microsoft SQL Server 2008 R2 Database Engine Benchmark V1.0.0” on November 16, 2012.  It can also be used for SQL Server 2008. This is a consensus-based development of security best practices which have become the de facto security configuration standards.  If you are in charge of your SQL

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-58918647326718686502012-12-28T18:20:00.000+01:002012-12-28T18:20:00.261+01:00

You can avoid executing a function when NULL values are passed as parameters. To achieve this you need to create function with RETURNS NULL ON NULL INPUT In example, this function concatenates two strings, if two arguments are passed, otherwise NULL result are returned.  USE db GO CREATE FUNCTION dbo.ConcatenateSTR (       @string NVARCHAR(MAX),       @string2 NVARCHAR(MAX) ) RETURNS

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-29077476583132100102012-12-21T19:07:00.000+01:002012-12-21T19:07:00.398+01:00

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-24120439491741159822012-12-18T16:44:00.000+01:002012-12-19T16:45:16.019+01:00

If you've this scenario, probably it can help you. SQL Server has Shared Memory Protocol disabled There is a suggestion for improve better performance in Servers with Biztalk and SQL Server. Under certain stress conditions (such as clients accessing SQL Server from the same computer), the SQL Server Shared Memory protocol may lower BizTalk Server performance. You can resolve this

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-22228741497607175892012-11-29T00:10:00.000+01:002013-10-11T08:21:42.214+02:00

Actually, I've T-SQL scripts in my USB, but today I'm thinking about the possibility to store it in Template Explorer of Management Studio, it's more fast to get scripts than in USB. First of all, Scripts of Template Explorer are stored in %AppData%\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\SQL 100 for SQL Server 2008 R2, the number depends on your SQL Server version. It's not

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-24332012273465658232012-11-28T07:40:00.000+01:002012-11-28T15:23:42.533+01:00

The server network address “TCP://SQLServerName:5022″ cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418 ). If this error occurs when you're trying to create a mirror, check this points: Restore backup at secondary server has to be with NORESTORE option. All log backup

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com1tag:blogger.com,1999:blog-7703370381085463013.post-61597088603046653272012-11-28T07:30:00.000+01:002012-11-30T16:05:45.719+01:00

If you get some error description like this, "Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011."  Probably this link to Microsoft's Fix can help you: http://support.microsoft.com/kb/2315727 

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-39229317286077325502012-11-21T07:41:00.000+01:002012-11-21T15:42:45.233+01:00

Here we've different errors that can occurs trying to insert some rows into table that has Identity field. I want to insert all data from Table Banca_Movimientos_TEMP to table Banca_Movimientos3 Sentence 1: insert into dbo.Banca_Movimientos3  select * from dbo.Banca_Movimientos_TEMP On executing this, I get the error: Msg 8101, Level 16, State 1, Line 1 An explicit value for the identity

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-19670967070277868342012-11-09T20:47:00.001+01:002013-04-19T12:30:40.875+02:00

Today, Trying to restore a database from other server Backup,  RESTORE DATABASE DB   FROM DISK = 'X:\Backup\DB_1.dmp'   WITH      MOVE 'DB'         TO 'Y:\DATA\DB.mdf',     MOVE 'DB_log'   TO 'Z:\LOG\DB_log.ldf',     REPLACE,     Recovery,       STATS = 10 go I get this message: Msg 3634, Level 16, State 1, Line 1 The operating system returned the error '32(The

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-15731502075506734902012-10-28T19:30:00.000+01:002012-10-31T16:19:36.138+01:00

Sometimes we need to restore Databases in other servers, and logins probably doesn't exist on new server. The restored Database contains Users and permissions but it aren't mapped with Logins. Microsoft provides stored procedure to map user with login. If login doesn't exist, Auto_Fix option will create it. USE Database; GO EXEC sp_change_users_login 'Auto_Fix', 'USER', NULL, 'Password'; GO

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-90645924180417023972012-10-28T19:00:00.000+01:002012-10-29T15:55:36.735+01:00

If you don't modify the default paths for Data, Logs and Backup's on SQL Server Installation, you can modify it then. To Modify SQL Data or Log Directory, go to Server Properties, Database Settings, Database Default Locations (marked in red). But, where can we change SQL Backup directory? In Windows Registry. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-8150665268314834102012-10-28T18:00:00.000+01:002012-10-29T15:16:11.818+01:00

The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start. If this error ocurred when you install SQL Server 2008 R2, try to do this one: Open console command (Run->CMD with administrator privileges).  net stop

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-8910041185460303252012-10-08T23:42:00.000+02:002012-10-09T14:43:51.486+02:00

The syntax RESTORE…WITH STATS = X option allows you to see where is the restore process currently. The default display is 10%, but some value can be specified. RESTORE DATABASE ‘Adventureworks’ FROM DISK = ‘C:\Adventureworks.bak’ WITH STATS = 5 GO It refresh the restore status percentage from steps by 5%.

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-79442384711697233782012-10-08T08:03:00.000+02:002012-11-02T09:49:34.409+01:00

If you execute this sentence to restore database with FullTextCatalog, RESTORE DATABASE YourDB   FROM DISK = 'X:\ Backup\ DatabaseBackup.bak   WITH     MOVE 'YourDB_data'   TO 'Z:\DATA\YourDB.mdf',     MOVE 'YourDB _log'   TO 'Z:\DATA\YourDB_log.ldf',     REPLACE,     Recovery,      STATS = 10 go If you will have an error like this: Msg 9953, Level 16, State 1, Line 1 The

Nil CGhttps://plus.google.com/103765654113437460156noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-69526815946052367222012-08-21T09:38:00.001+02:002012-08-21T09:38:43.634+02:00

Allocation pages are special pages in the data files that track and mange extent allocations. There are 3 types. Global Allocation Map (GAM): Tracks which extents have been allocated. There is 1 GAM page for every 4 GB of data file. It is always page 2 in the data file and then repeats every 511,232 pages. Shared Global Allocation Map (SGAM): Tracks which extents are being used as mixed (

Nil CGhttps://plus.google.com/116806974987536440963noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-34342133847390030062012-04-27T14:05:00.000+02:002012-04-27T14:05:00.532+02:00

This T-SQL, allows you to add a Backup device, from remote directory (Don't forgett to give permissions to source backup folder).First of all, add de remote backup as Deviceuse master exec sp_addumpdevice 'disk','RemoteBackupDevice','\\yourRemotePath\backup.bak' goThen restore de database from the Device created.restore database yourdatabasename from [RemoteBackupDevice] with file=1, move

Nil CGhttps://plus.google.com/116806974987536440963noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-38668075373839337392012-04-24T13:41:00.000+02:002012-04-27T13:00:06.769+02:00

When for some reason, a SP code can't be migrated, and beteewn BEGIN and END it doesn't appear something, SSMA createadeclaration variable to prevent SP creation error.For example: Create procedure stp_Test_Migration_Code (@nombre varchar(50) OUTPUT) ASBEGINselect @nombre = db_name (tempdb_id(@@spid))ENDGO This SP has to be migrated to SQL Server, but SSMA and SQL Server doesn't have tempdb_id(

Nil CGhttps://plus.google.com/116806974987536440963noreply@blogger.com0tag:blogger.com,1999:blog-7703370381085463013.post-70726149754765742892012-04-19T19:42:00.000+02:002012-04-27T13:00:06.811+02:00

Following with conained Databases in SQL Server 2012 (Enabling contained databases), we must create a User for login in.The first step is to create the SQL user User with Password (userName: containedUser)Make sure to set a membership role, for example db_owner.Now, try to connect to Contained database, choose SQL Authentication and complete your Login and Password.The most important!, don't

Nil CGhttps://plus.google.com/116806974987536440963noreply@blogger.com0