I'm attempting to help our network engineers troubleshoot a situation for one of our clients. This client purchased a point-of-sale system from quite literally a "mom-and-pop" vendor, and said vendor recommended SQL Server Express 2005 as the back-end database to save the client from having to incur extra licensing fees. (Please don't ge...
Hi, We have SQL Server database setup. We are setting up a replication scenarios where we have one publisher and on subscriber. The subscriber will be used as a reporting platform so that we can run all the BI queries that we need and have to hit the server that is reciving all the data from our clients. The subscriber is set to pull ...
If you have a lot of Stored Procedures and you change the name of a column of a table, is there a way to check which Stored Procedures won't work any longer? Update: I've read some of the answers and it's clear to me that there's is no easy way to do this. Would it be easier to move away from Stored Procedures? ...
I would like to set up a localhost server to test my site on in sql server 2005. I just installed sql server 2005 and I have never set up a database in this before. There is a login screen and I tried everything and it will not let me log into anything. What are the steps I need to do to get this to work. Thanks ...
How can we create a trigger to send an email on any insert or delete action on a table.It should send an email and also it should have the location of the server and the database. Please, let me know. ...
Hi, I have an MS sql server database. There is a table with one of the column of the "image" type. Now, the customer wants to read the data from an MS access. He wants to display the images in a form. I have never used access and have no idea of how to do simple things there. Any help will be greatly appreciate. Thanks, Ramjee ...
I am having a similar issue to this person. The primary difference being the application is NOT meant for a developer environment, and therefore I need to know how to optimize the space used by Sql Server (possibly per machine based on specs). I was intrigued by Ricardo C's answer, particularly the following: Extracted fromt he SQL...
Folks, I'm trying to wrap my head around how to search for something that appears in the middle of a word / expression - something like searching for "LIKE %book% " - but in SQL Server (2005) fulltext. How can I do that?? It almost appears as if both CONTAINS and FREETEXT really don't support wildcard at the beginning of a search expre...
Hi, I was wondering if it is possible to get a large, enterprise-scale sample Sql Server database? I am working with Sql Server 2005, and feel that looking at a large scale database would really improve my database design skills. I'm aware of, and have checked Nortwind and AdventureWorks, but these aren't large enough. Also, when worki...
Aside from executing XP_CmdShell, which I have disabled in my SQL 2005 installation, what could a malicious user who gains DBO rights to my database do: to my database, to my server? I'm assessing the worst-case security risk of someone obtaining DBO to justify running a "least-privileged" user account in an application. Some allege ...
Hey guys, I have an importer process which is running as a windows service (debug mode as an application) and it processes various xml documents and csv's and imports into an SQL database. All has been well until I have have had to process a large amount of data (120k rows) from another table (as I do the xml documents). I am now findi...
What are some recommended resources/books/blogs on SQL Server Integration Services? Thanks. ...
In SQL Server Mgt Studio 2005, when I open the Object Explorer to script an object to a new Query Editor window, the tab for that new script window is titled something like 'MyServerName.MyDatabaseName - sqlquery37.sql' Not very descriptive. So when I get a bunch of windows open at the same time, I have no idea which one is which. Th...
I have seen posts that show three ways to reset the DMV views: Reset the SQL Service Detatch the database Close the database All of these methods seem to require taking the system off-line for a few moments. Is there a way to reset the statistics on demand without interrupting use of the database? When we have odd performance issue...
Which command will executed first,If a stored procedure have individual multiple select commands; ...
When I try to execute grant permissions on an Assembly for users I get the following message: Incorrect syntax near 'EXECUTE...'. This problem has only come about with SP2, MS took away the ability to grant execute permission on UDA's. The loop whole is that they didn't take grant execute permissions away on the database that the UD...
I have many jobs that have a step to send 1 specific email out to a list of people. That list of reciepients is hardcoded in the step command and I need to remove one person from that list, in all jobs. How do I loop through ALL the jobs in the Sql Server Agent and modify the command text to find+replace a specific piece of text. I ...
Is it possible to generate a XML Schema of a Database programatically with .Net and C#? I want to look into NDbUnit but for big databases it would not really be feasible to make a Schema manually? EDIT: Question wasn't clear. ...
What is the maximum number of publishers one can create on one Database on that same database server itself? Also, Vice - versa , What is the maximum number of subscribers one can create on one Database on that same database server itself? ...
say I want to find the latest added rows (UPDATE by any user, not necessarily the one which is executing UPDATE) in XX table. ...