SQL Server database programming

I know enough about SQL sytax to get things done - perhaps this is just enough to be dangerous! I'm storing heirarchical data in a table using preorder tree logic. Whenever I add a new node to the tree, I need to update the left and/or ...

I think I've seen this before but am not sure. Is there a way to insert rows into a table from a stored procedure? For example, I'd like to run sp_spaceused and output the values to a table. This is the idea: SELECT EXEC ...

Ok maybe I am asking too much. But is there a simple way to run a script that will defrag/reindex a whole table ...

The development of an application that handles encryption of data stored in a database (SQL server) at the application level. This is what I am trying to develop, but I am just in a researching face for the moment, hence my question. ...

Hello all. I am pretty new to SQL Server, and I am using SQL Server 2005 Developers edition. I am sorry if this question has a really obvious answer, but I am just starting to use the SQL Server 2005. ...

Hello, I can't figure out the line or limits between developers and DBAs, i for myself do everything, from creating the DB and all its objects, tables , stores procedures , views , logins , roles , permissions , etc. to preparing backup/restore jobs to designing the client application using VB.NET , i ...