Gunnar Peipman's ASP.NET blog

ASP.NET, C#, SharePoint, SQL Server and general software development topics.

Sponsors

News

 
 
 
 
 
Programming Blogs - Blog Catalog Blog Directory
 
 
 

Links

Social

Browse by Tags

All Tags » SQL Server (RSS)
Links 2009-08-19
JQuery and web development Limit Number of Characters in a TextArea using jQuery Find out which Key was pressed using jQuery jQuery Superfish Menus Plug-in Make website images look like a video with this CSS effect CSS2 – opacity Mobile 55 per cent of...
Attaching SQL Server database without log file
I needed to attach SQL Server 2008 database to server. There was no log file, just mdf. I don’t know why but it is not very easy to get this database online. After some digging in internet I found solution. I suggest you to read and try out example by...
List of Microsoft training kits
Microsoft training kits are pretty good things to explore when you start learning some new technology. Here are links to some training kits I found to be interesting and useful. Some of these live also in my laptop and when I have free moments I explore...
The changes you have made require the following tables to be dropped and re-created
When changing tables in SQL Server Management Studio 2008 you may get the following error: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created . I was surprised when I saw this message first...
Posted: Apr 08 2009, 07:24 PM by DigiMortal | with 4 comment(s)
Filed under:
You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column
One error you may get when querying SQL Server databases through MS Access is "You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column" . This error appears when you open recordset...
SQL Server 2008 Reporting Services - save your time!
Some time ago I tried out SQL Server 2008 Reporting Services and I was amazed. I'm serious MS Paint terrorist and nice pictures are not one of my strong skills. So, if something makes things look nice to me I'm very happy. I downloaded last CTP of SQL...
Posted: Apr 20 2008, 12:16 AM by DigiMortal | with 4 comment(s)
Filed under:
SharePoint: Changing comments of document versions in code
During one SharePoint migration project I had problem with document versions comments. I needed some way to set these in my code. As I didn't found any normal way to do it through SharePoint API I worked out something I call dirty hack. But it works....
Some cool SQL Server user names
One day when I checked SQL Server messages in Event Viewer I found a long series of unsuccessfull attacks. Somebody desperately tried to guess user names and passwords. The favourite ones were the following user names: sa sql admin administrator administrador...
Posted: Feb 16 2008, 10:17 PM by DigiMortal | with 6 comment(s)
Filed under:
SQL-DMO and searching from meta-data
Lately I faced the need to search for specified strings in all stored procedures in given database. I found SQL-DMO library very useful for it. So, ten minutes later I had a simple form that fits my needs perfectly. And some minutes later I had there...
More Posts