62 items | 4 visits
Bookmarks pertaining to database theory or practice. With emphasis on Microsoft SQL (sorry).
Updated on Apr 15, 14
Created on Mar 25, 09
Category: Computers & Internet
URL:
Neklan B's List: Databases
-
Dec 01, 09
more flexible support of schema changes in SQL 2005 replication
-
Sep 03, 09
exec sp_change_users_login Update_One, 'MyLogin', 'MyLogin'
used to recover when a local SQL account is defined in a database, but not in the server (for example, after a DB restore to a different server) -
Aug 22, 09
for when the time comes... sa password recovery on SQL 2005
-
Jul 23, 09
nice convinient example of an example SMTP session. (for diagnostic type purposes)
-
-
Nov 13, 07
All of a sudden can't generate a new snapshot?
check disk space :( -
-
Feb 22, 08
our application using linked servers stopped working after applying SP2 to the server. you need to set "no authentication required" for the transaction coordinator.
-
-
The patch installation uses the SQL SA user, which has sysadmin privileges. If you download and attempt to install the patch manually, you get a dialog box where you are asked to enter the SA password.
-
-
Sep 02, 08
exactly right. UDFs can sometimes cause "database in transition" errors or simillar
-
This happened to me once when I had UDF in a view with derived tables when I took the code from the UDF and pasted it in the SQL it was fine I guess it was something to do with the levels of nesting and joining with derived tables
-
-
Jan 06, 09
There can be a problem installing the SQL 2005 developer edition where it complains it can't install the SQL native client. This post notes that the client is already installed due to .Net 3.5.
Uninstall the existing native client, then let the installe -
-
Feb 04, 09
referencing blobs as filesystem files instead of blobs within the database.
-
-
Linked servers are a superset of "remote servers." Remote servers allowed the running of stored procedures on distributed SQL Server machines. SQL 2000 BOL states, "Support for remote servers is provided for backward compatibility only. New applications that must execute stored procedures against remote instances of SQL Server should use linked servers instead." Support for remote servers may be discontinued in the future. In addition, remote servers only allowed stored procedures to be run. Linked servers allow both stored procedures and ad hoc queries.
-
-
List Comments
(0)
List Info