While browsing the SQL Server newsgroups, every once in a while, I see a request for a script that can search all the columns of all the tables in a given database for a specific keyword. I never took such posts seriously. But then recently, one of my network administrators was troubleshooting a problem with… Leer más: How to search all columns of all tables in a… »
SQL Server es una aplicación Winsock que se comunica a través de TCP/IP utilizando la biblioteca de red de sockets. SQL Server escucha las conexiones entrantes en un puerto concreto; el puerto predeterminado para SQL Server es 1433. El puerto no tiene por qué ser el 1433, pero 1433 es el número de socket oficial… Leer más: SQL Server Port Firewall 1433 »
Problema de instalación Windows Clean Utility
MySQL: CREATE TABLE ORDERS (Order_ID integer, Order_Date date, Customer_SID integer, Amount double, Primary Key (Order_ID), Foreign Key (Customer_SID) references CUSTOMER(SID)); Oracle: CREATE TABLE ORDERS (Order_ID integer primary key, Order_Date date, Customer_SID integer references CUSTOMER(SID), Amount double); SQL Server: CREATE TABLE ORDERS (Order_ID integer primary key, Order_Date datetime, Customer_SID integer references CUSTOMER(SID), Amount double); Below are… Leer más: ALTER TABLE ORDERS FOREIGN KEY »
MySQL migration: MyISAM to InnoDB By Keith Winston on July 18, 2005 (8:00:00 AM) The MySQL database is unique in that it offers multiple storage engines. The SQL parser and front end interfaces are separate from the storage engines, so you can choose among nine low-level table formats the one that suits your application… Leer más: MySQL migration: MyISAM to InnoDB »
Simply put, referential integrity means that when a record in a table refers to a corresponding record in another table, that corresponding record will exist. Look at the following:
http://i-admin.blogspot.com/2005/06/how-to-crack-windows-terminal-services.html
T-SQL code BACKUP: USE myDatabaseName GO BACKUP DATABASE myDatabaseNameTO DISK = ‘C:\filePath\myDatabaseName.bak’NAME = ‘The name of the back up.’ RESTORE: RESTORE databaseName FROM DISK = ‘C:\filePath\backupFilename’ Tags: backup, restore
<download> This Utility will enable Remote Desktop connections on remote servers. UPDATE!! now it will also change the port number that RDP listens on. This is good to add a layer of security in. If you find this tool useful please think about a donation using the link below. File Attachment: RDPEnable.zip (597 KB)