| Thread | Last Post | Replies |
|
| SQL Server 2005 Triggers | 31 May 2007 23:10 GMT | 14 |
I have created a simple trigger on a table in my SQL Server 2005 database, i have a C#.net 2 program that inserts rows into this table and the trigger does not run. If i run an INSERT statement from within the management studio, the trigger does run and gives the desired results. ...
|
| SQL Profiler - view stored procedure parameters | 30 May 2007 23:10 GMT | 1 |
How can I setup SQL Profiler so I can see the parameters passed from one stored procedure to another? If my client app calls sp1, I can see the parameters passed to it, but when sp1 calls sp2, is there a way of trapping the parameters passed into the proc?
|
| Maintenance Plan Problem - 15404 Error | 30 May 2007 19:20 GMT | 7 |
I have a SQL 2005 database that is set up for integrated auithentication. I can back it up successfully by right-clicking and selecting Tasks > Backup. I created a simple maintenance plan to back up this database using the Maintenance Plan Wizard. However when I right-click the ...
|
| Alternative to SQL Server Management Studio? | 30 May 2007 16:35 GMT | 3 |
Does anyone have any suggestions for 3rd party tools to replace SQL Server Management Studio. SMS is such bloatware and lacks so many nice features of Enterprise Manager that there must be some decent tools out there to use instead. I know there's Microsoft SQL Server
|
| SQL Server 2005 - templates with dynamic parameters? | 30 May 2007 13:08 GMT | 2 |
Is it possible to edit/create templates which use functions such as SUSER_NAME() or GETDATE() to automatically populate parameters? Thanks
|
| Using Import and Export Data tool from SQL Server to Oracle with Timestamp | 28 May 2007 11:54 GMT | 4 |
I am trying to use the Import and Export Data tool that comes with SQL Server 2000 to transfer data from SQL Server into Oracle 9i. (I'm not migrating away from SQL Server, the software I'm writing supports both and I need to duplicate data for testing purposes.) When using the
|
| Different versions of SSMS? | 28 May 2007 10:54 GMT | 2 |
Does it exist different versions of SSMS? I'm now working with SSMS Express and SQL Server 2005 Express. How can I make a scheduled backup from SSMS?
|
| Using Profiler in SQL 2005 Express | 27 May 2007 03:17 GMT | 1 |
I am installing SQL 2005 express on a couple client systems that will not be accessable from a central SQL 2005 Standard instance. Is it possible to install and run profiler and query analyzer on each client instead of from a central instance since it does not come with the ...
|
| Using profiler to track Excel external data refreshes | 26 May 2007 18:40 GMT | 2 |
I've got a spreadsheet that uses Excel 2007's external data feature to pull data from SQL Server 2005 via a stored procedure. I would like to track those events in profiler, but when I set up a SQL:Batch Completed trace, these refreshes don't show up. Seems like it should,
|
| Relationship Diagrams | 26 May 2007 06:34 GMT | 3 |
I was wondering if there is a tool available that maps the relationships between tables in a SQL Server database. I need this to help document a user guide to a DB I've designed for them and they are familair with the MS Access diagrams and can't get
|
| SQL Agent don't start with a Domain Account | 24 May 2007 02:54 GMT | 1 |
I've tried start SQL Agent on a SQL Server 2005 SP2 and Windows 2003 Xp64 db server with a Domain Account (Non administrative), but it didn't work. This account is used to start SQL Server too and it works fine. I followed everything that is on Books online about Local ...
|
| SQL Server 2005 Management Studio Express and Importing SQL 2000 D | 24 May 2007 00:07 GMT | 5 |
Can I use SQL Server 2005 Management Studio Express to import a SQL 2000 database into a SQL 2005 database? Is there any tool that will do this? Can I get a FREE copy of SQL Server 2005 Management Studio (NOT Express)
|
| Dumping sql server | 23 May 2007 04:55 GMT | 2 |
Is there a way to dump all the sql server data into some sort of file that can be imported into a local sql server later? I have used sql server dumper but it is not very stable and crashes during sump. Thanks
|
| Monitor DB Usage at Column Level | 22 May 2007 15:31 GMT | 3 |
I'm looking for a tool that will compile historical usage information for a specific SQL Server 2000 database down to the column-level. This is a read-only database and I need to know how many times each column of each table has been included in a query over a period of time. ...
|
| Autoimport from xls to SQL 2000? | 17 May 2007 22:30 GMT | 2 |
I have a program setup the exports check request data into a xls file every week on a shared directory on Windows 2003 server. I'd like a way to import that data into SQL 2000 on a weekly basis. (Shared directory and SQL on same server).
|