Browse by Tags
All Tags »
SQL Server (
RSS)
Sorry, but there are no more tags available to filter with.
It's a fact that no integration services and SQL agent available in SQL Express products, but it's a must to backup SQL Express databases in a timely basis. There is a very useful article describing how to do it with TSQL and Windows Schedule...
Just find few useful tips/tool when I try to compare the schema and content of two SQL databases: DBComparer (free) Find out DB lock: select distinct object_name(a.rsc_objid), a.req_spid, b.loginame from master.dbo.syslockinfo a (nolock) join master.dbo...
With the principle of least privilege of application / database account, web app normally uses a DB account with limited permission to specific database objects in Connection String. Manually typing of "GRANT EXECUTE ON <Object> to <User>"...
Apart from the capacity planner tool for System Center and SharePoint Server, I was looking for a tool which can help me to estimate the capacity of SQL Server. I found an article on Microsoft.com for SQL Server 2000 sizing but unfortunately the links...
I worked with SQL 2008 in a recent project, but I got the following message whenever I try to make change to a table structure in SQL management studio: Saving changes is not permitted. The changes you have made require the following tables to be dropped...
More Posts