I think the question says it all. I have several monthly processes in stored procedures which take anywhere from a minute to an hour. If I declare them WITH RECOMPILE, an execution plan will be generated each time. If the underlying indexes or statistics or views are changed by the DBA, I don't want anyone to have to go in and force a...
I work with an application which uses rather big numbers and I need to store data as an unsigned 64-bit integer. I prefer to just store it without worrying about bit manipulation or anything like that so different programs can use the data in different ways. ...
I'm writing into a log file, but I want to log into a table named "Log" in my database. How can I accomplish this? ...
Is there a way to find out the size of a SQL Server database using WMI from .NET? I've had a look at the WMI documentation but I'm not clear how I'd be able to locate that information. We're using SQL Server 2008. -dave ...
I am looking to implement (or build as a last resort) a type of survey engine that allows for extensibility and integration into an existing workflow engine. The survey/questionnaire engine should allow for admin users to add new questions and response types (text/bool/multiple/etc), should use SQL Server for persistence and ASP.NET 2.0...
If have created a custom role within SqlServer which I added to the db__denydatareader and db__denydatawriter roles. I think went through the db and granted exec permission to all neccersary stored procedures. Everything works fine, calling those sps will run fine. The one exception is a stored procedure which executes dynamic sql by u...
My problem is that I want a grid that is populated with a set of times spent on tasks. It needs to have the days of the week at the top (these would preferably be fixed - i.e. Sun, Mon... Sat) and task names down the left column. The contents of the grid will have the individual hours spent for that day on that task. What would the be...
We have a merge replication topology including one publisher, multiple publications and multiple subscriptions. It has been running for at least 8 months without problems. A few days ago I was informed that my PO codes were being "changed" without any reasons, from a standard "ZWWTP/PO-0092" style to a new "ZWWT" style: characters 5 to ...
Some naive questions the numbers in sysprocesses. What I conclude by looking at the numbers cpu, physical_io, memusage Do any of these numbers sum to a finite amount? Also, I notice that when I run a query, that the status beomes 'runnable'. When the query stops it becomes 'sleeping'. However the resources-used figures are still up Am I...
I'm trying to fix a broken SSP on a MOSS 2007 site. The problem I am running into manifests itself as follows... In the SSP "Search Settings" page I get this message: The search service is currently offline. Visit the Services on Server page in SharePoint Central Administration to verify whether the service is enabled. This might also ...
I'm planning to set up log shipping to a remote site for disaster recovery but I still want to take a nightly full backup so I can copy it to our backup tape and also use it to restore onto our reporting server. Can I do that without breaking the cycle of log backups? ...
Hi all, I have some databases that have four files each; one for PRIMARY, IDX, IMAGE, LOG their initial sizes were set to 200MB each but they are consuming far less space, about 100MB total. 1) is it possible to resize the database files while they are in use down to more reasonable sizes, say "current consumption" + 10MB? 2) is it p...
I have setup both mirroring and and log shipping on 8 databases of about 10 GB each size on same instance, but now when I want to mirror another database it very long to display the Database Properties page. Any suggestion for this problem. ...
I have a table like so: keyA keyB data keyA and keyB together are unique, are the primary key of my table and make up a clustered index. There are 5 possible values of keyB but an unlimited number of possible values of keyA,. keyB generally increments. For example, the following data can be ordered in 2 ways depending on which key c...
Hi, There is a column in a database that is of type INT (Sql server). This int value is used at a bit flag, so I will be AND'ing and OR'ing on it. I have to pass a parameter into my sproc, and that parameter will represent a specific flag item. I would normally use an enumeration and pass the int representation to the sproc, but sinc...
I have set up transactional replication between two SQL Servers on different ends of a relatively slow VPN connection. The setup is your standard "load snapshot immediately" kind of thing where the first thing it does after initializing the subscription is to drop and recreate all tables on the subscriber side and then start doing a BCP...
I have a connection to a Microsoft SQL Server and want the change the connection authenticated user. Is it possible to do it without closing and reopening the connection? The ideal is something like Oracle set role feature. I'd love if the solution also works for SQL Server 2000. ...
I thought it is a very simple task to export data in a view from SQL Server 2005 to a fixed width text file. But the wizard is a pain. The format is not correct. Does anybody know how to deal with it? or any better way to do that? Thanks! ...
I'm working on a script in PHP that needs to get some info from a SQL Server database. However, I am having trouble connecting to the database. When i use the mssql_connect() function, it gives me an error and says it cannot connect to the database. However, it gives no reason why. Is there any way to find out why it won't connect? There...
I'm not entirely sure if this is possible, but does anyone know how, or if you can make calls to a SOAP web service from SQL Server? Seems like it might be good performance-wise in the area of data sync applications. I feel like this might be a long shot though. Thanks. ...