Search results for query: *

On one publisher, there are 4 publications. I have 6 subscribers. I have a dedicated distributor. It is hosting quite a few publishers. So it is busy :-) Do you know any settings or tricks to make the monitor act faster?

In replication monitor, when I expand a Publisher to see my publications, it will take too much time to expand. The monitor shows "<MYSQLSERVER> (expanding...)" for a long time then eventually expands. Is there any setting for this to make it faster?

gmmastros, you're great! thanks a lot. that's exactly what i'm looking for. thanks also to others who responded.

Thanks Qik3Coder. I'm actually looking for a single select without a while loop. If it can't be done, then I go with the while loop as in your example. But in my case, i need a loop inside a loop. Outer loop is to go through the rows and inner loop is for splitting the columns, just like your...

Yes i tried charindex along with substring. i can do it cleanly for the first 2 columns, "drive" and "capacity", but the query becomes ugly after that. The challenge is how to get the starting and ending position. Can you give me your code? I can use cursor with a while loop also but that's my...

Hello, I have a table with one column and i want to split it into 4 columns. Values are comma delimeted. Is there a way using SQL query alone? Column1 ====================== C,18432,6196,12236 E,409595,112464,297131 H,407548,11915,395633 I want the output to be: Drive Capacity Used...

I don't actually know what happen but what I did is to delete the whole page and recreate it. I used the same code and it works. thanks anyway.

I'm trying to assign a default value to my radiobuttonlist but for some reason the following code gives "Build Failed" when I publish my web. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If IsPostBack = False Then...

I'm using the above code to insert my data. I tried converting it to a string but it gave me different error. Can you please give me an example?

I ceated a table with a UserID field. This is a uniqueidentifier type field. (I would use this as foreign key of the UserID from aspnetdb..aspnet_users table.) The problem is that I can't figure out how to insert data in it. Here's my current code. Protected Sub btnSubmit_Click(ByVal...

Thanks a lot folks!

hello, can you please explain how? i'm new to this. thanks.

I cannot figure out how to resize my loginview control. I want to make it wider so that i can position my texts better.

ok, but will it still execute the raiserror if app_name() not like 'SQLAgent - TSQL JobStep%'?

Hello folks, I'm trying to use RAISERROR on my stored proc to log an error message to the event log. This is fine. The problem is, when I use SQLServerAgent to run the stored proc, the sqlagentjob reports failure everytime. How can I use the raiserror command and have the sqlagent job reports...

can't you use update qustn set qustntext = replace(qustntext, '"','')

do you have a unique key included in the first view? if so, you should be able to calculate the 'moving' column in a new view.

can you give a sample table and the desired result of your query?

Thanks for you guys response. Bill, i'm not sure how to use your query. I'm trying to change a database owner. Here's my current script (that doesn't work). CREATE DATABASE MyNewDB ON PRIMARY (NAME = Scratch_Data, FILENAME = 'H:\MSSQL\DATA\MyNewDB.MDF', SIZE = 5000, MAXSIZE = 10001...

i'm guessing if the bed is not occupied then departuredate would be > blank or is not null? so can you try this. select b.bedname, c.firstname, c.lastname from beds b join bedusage bu on b.bedid = bu.bedid join client on bu.clientid = c.clientid where bu.DepartureDate > '' -- or you can use...